Try the following Code: if u want "LBREFID" to be in numeric then keep as shown below, else if u want it in char then Update LBREFID $ 8 in Length and $CHAR8. in input . /* The file will probably have DOS line-endings, so specify the delimiter as both the comma and the carriage return. The way the do this is to write them in hexadecimal, as "DLM='2C0D'x" on the infile statement. Specify infile option "dsd" so that consequtive commas are recognized as missing values. Specify infile option "missover" so that trailing missing values on a line are recognized as such (Excel doesn't output consequtive commas for trailling missing values). Specify infile option "lrecl" long enough for the longest record (it defaults to 256). Specify infile option "firstobs=2" so that the line of column names is skipped. */ Data AAA; LENGTH STUDY $ 8 PT 6 LBREFID 8 ; infile "<<Path>>\Lab_data.csv" dlm='2C0D'x dsd missover lrecl=10000 firstobs=2 ; INPUT STUDY : $CHAR8. PT : ?? BEST6. LBREFID : ?? BEST8. ; run;
... View more