| Date: | Mon, 2 Jul 2007 10:18:39 -0700 |
| Reply-To: | "jjj912@yahoo.com" <jjj912@YAHOO.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | "jjj912@yahoo.com" <jjj912@YAHOO.COM> |
| Organization: | http://groups.google.com |
| Subject: | delimeter not being recognized |
|
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
SAS isn't recognizing a delimeter and I'm not sure why. I've pasted
the code, a sample of the input data below, and the results below.
The input data is a csv file with commas separating the values.
data sched ;
infile "c:\schedules.csv" DELIMITER=',' DSD TRUNCOVER MISSOVER lrecl =
600 ;
input assign $12. tag $12. start $24. end $24. localstart $24.
localend $24. cap $;
run;
Sample of the data (it's all on one line):
"1019492","`0059536`","6/1/2007 6:00:00 AM","6/1/2007 7:00:00
AM","6/1/2007 1:00:00 AM","6/1/2007 2:00:00 AM","1"
The number portion of the first two variables vary in size. The
"truncover" and $12. is an attempt to capture that. If I get rid of
the "truncover" and replace the $w. with $, I just get the first 8
characters of the data.
The results looks like this:
assign,tag,start,end,localstart,localend,cap
"""1019492"",""`","0059536`"",""6","/1/2007 6:00:00 AM"",""6/1","/2007
7:00:00 AM"",""6/1/2","007 1:00:00 AM"",""6/1/200",,
What am I doing wrong?
|