Inputting CSV data that doesn't contain variable names

[jwestra84]

I need to read in some csv data that does not have any variable names in it. There are 150 character variables that are questions to a test. How can I name these variables (q1,q2,q3,...) without having to list each variable in the input statement?

[Reeza]

Use proc import with getnames=NO option.

SAS will automatically name the variables var1-var150 and you can automatically rename it

data want;

set have;

rename var1-var150=q1-q150;

run;

[jwestra84]

Thank you. That is very helpful!

[Tom]

If you already know the structure then you do not need to use PROC IMPORT.

data want ;

  infile 'myfile' dsd lrecl=30000 truncover ;

  length q1-q150 $100 ;

  input q1-q150;

run;