So if the data is in fixed columns then that is also simple with SAS. You could tell SAS to read from specific columns (input ID $ 1-10) or tell it to use a specific format (input ID $10.). I would use formatted mode so that I did not need to type all of the column numbers. If you input your non-id variables as numeric then it will treat '1' as the number one , '0' as the number zero, and ' ' as a missing value. So if you have a 10 character ID value and then 20 one character variables then you could write: data want ; infile 'myfile.txt' truncover ; input id $10. (var1-var20) (1.) ; run;
... View more
