Don't waste time with PROC IMPORT when reading text files, in the end you are faster writing the code yourself:
data want;
infile datalines dlm=";" dsd truncover firstobs=2;
input code :$1. description :$10. total;
datalines4;
code;description;total
1;hi;201
2;hey;301
3;good;401
;;;;
For your actual file, replace the DATALINES keyword in the INFILE statement with your filename, and remove the DATALINES4; block.
... View more
