|Date: ||Mon, 8 Sep 2003 09:07:22 -0700|
|Reply-To: ||"Choate, Paul@DDS" <pchoate@DDS.CA.GOV>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Choate, Paul@DDS" <pchoate@DDS.CA.GOV>|
|Subject: ||Re: Import Delimited Long Variable Character fields|
Try $CHAR255. - it retains leading blanks.
DDS Data Extraction
From: David Wright [mailto:David_wright@SPRA.COM]
Sent: Friday, September 05, 2003 4:20 PM
Subject: Import Delimited Long Variable Character fields
Assume you have a delimited file with character fields of unknown length
(except they are less than the 255 max).
What is the best (simplest that works rather than efficient) format/informat
1. use a simple $255.
2. use $var255.
3. use format modifier x : $ 255
I have had very bad luck using any of these three, depending on other fields
in the file and so on. According to the manual, ":" is supposed to work with
delimited files, but I have found some problems with it as well.