Prev: How to find t-stats
Next: count for certain criteria.
From: vncntj on 14 Apr 2010 10:23
I'm trying to import (csv)

department,cost,billedDate,billedYear
American Art,0,,
American Art,0,10-Mar,2010
American Art,0,9-Nov,2009

via

data Photography;
infile 'photography.csv' dsd;
input department $1-38 cost 40-47 billedDate 49-55 billedYear 57-61;
run;
quit;

But I keep getting:
Invalid data for cost in line 2 1-6
Invalid data for cost in line 3 1-7

Thanks,
From: PJ on 14 Apr 2010 11:29
Try below to see if it helps,

filename ifile "C:\Documents and Settings\nm36198\Desktop\ph.csv";

data ph;
infile ifile dlm=',' dsd missover pad;
length department $38;
input department $ cost billedDate $ billedYear;
run;
quit;

Regards

PJ
 | 
Pages: 1
Prev: How to find t-stats
Next: count for certain criteria.