To Do,D290,15557,,WS Live 10/20/17,jdoe,admin,,Closed,Done,10/20/2017 7:00,10/20/2017 9:07,
To Do,D289,14456,,ACS 10/20/17,jdoe,admin,,Closed,Done,10/20/2017 7:00,10/20/2017 7:22,
Data data.have;
infile 'U:\SAS\table\data.csv' truncover dsd
delimiter = ',' ;
informat Type $6. ;
informat Key $10. ;
informat ID $10. ;
informat PID $10.;
informat Summ $45. ;
informat Assigned $14. ;
informat Reporter $6. ;
informat Priority $6. ;
informat Status $15. ;
informat Resolution $6. ;
informat Created anydtdtm16. ;
informat Updated anydtdtm16. ;
informat Due_Date $6. ;
format Type $6. ;
format Key $10. ;
format ID $10. ;
FORMAT PID $10.;
format Summ $45. ;
format Assigned $14. ;
format Reporter $6. ;
format Priority $6. ;
format Status $15. ;
format Resolution $6. ;
format Created datetime21. ;
format Updated datetime21. ;
format Due_Date $6. ;
input
Type $
Key $
ID $
PID $
Summ $
Assigned $
Reporter $
Priority $
Status $
Resolution $
Created anydtdtm16.
Updated anydtdtm16.
Due_Date $
;
Run; @ballardw Is the above enough? I can paste a few more lines if necessary. Thank you again for the help! I changed it back to what I originally had, plus the datetime21. and anydtdtm16. you and Patrick had suggested however same results the data is not being populated correctly/nor fully.
... View more
