Help using Base SAS procedures

Inputting CSV data that doesn't contain variable names

Reply
Occasional Contributor
Posts: 9

Inputting CSV data that doesn't contain variable names

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?

Super User
Posts: 19,860

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

Posted in reply to jwestra84

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;

Occasional Contributor
Posts: 9

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

Thank you. That is very helpful!

Super User
Super User
Posts: 7,076

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

Posted in reply to jwestra84

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;

Ask a Question
Discussion stats
  • 3 replies
  • 230 views
  • 0 likes
  • 3 in conversation