topic Re: Inputting CSV data that doesn't contain variable names in SAS Procedures

Inputting CSV data that doesn't contain variable names

jwestra84 — Sun, 16 Nov 2014 20:33:46 GMT

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?

Re: Inputting CSV data that doesn't contain variable names

Reeza — Sun, 16 Nov 2014 22:04:10 GMT

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;

Re: Inputting CSV data that doesn't contain variable names

jwestra84 — Sun, 16 Nov 2014 22:09:29 GMT

Thank you. That is very helpful!

Re: Inputting CSV data that doesn't contain variable names

Tom — Mon, 17 Nov 2014 15:35:17 GMT

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;