Hello!
I am using Proc Import for importing Excel csv file, I have situation when the excel file collected in different way and SAS log is showing issues when I am just using this code(below). I tried to use "Infile" but again the same issues are showed.
Example from excel file:
Proc Import File = "filelocation"
Out = test
Dbms = csv
replace;
Run;
*Infile code;
Infile "filelocation"
delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2;
Informat STUDYID $15. SITENUM BEST32. SUBNUM BEST32. VISIT $35. XXDT date11. XXTIM TIME20.3;
Format STUDYID $15. SITENUM BEST12. SUBNUM BEST12. VISIT $35. XXDT date11. XXTIM TIME20.3;
Input STUDYID $ SITENUM $ SUBNUM $ VISIT $ XXDT XXTIM;
run;
... View more