LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (July 2007, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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
Comments:   To: sas-l@uga.edu
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?


Back to: Top of message | Previous page | Main SAS-L page