topic Re: how to read second row as columns names in csv file without deleting first row in SAS Programming

how to read second row as columns names in csv file without deleting first row

thanikondharish — Fri, 12 Mar 2021 10:09:31 GMT

I have one csv file path is 'D:\Parc\file_dump.csv' and we have to take 2nd row as column names.

Note: dont delete first row.

Re: how to read second row as columns names in csv file without deleting first row

PaigeMiller — Fri, 12 Mar 2021 10:51:07 GMT

Use the INFILE statement with option FIRSTOBS=2

Re: how to read second row as columns names in csv file without deleting first row

Ksharp — Fri, 12 Mar 2021 11:25:42 GMT

How do you import this CSV file ?
data step or PROC IMPORT ( try option : datarow=3 )

Re: how to read second row as columns names in csv file without deleting first row

thanikondharish — Fri, 12 Mar 2021 11:27:45 GMT

Proc import only and datarow option is like data starting record but this
option won't use for column names

Re: how to read second row as columns names in csv file without deleting first row

Ksharp — Fri, 12 Mar 2021 11:52:35 GMT

Delete the first line ?

filename x temp;
data _null_;
 infile 'c:\temp\root.csv' lrecl=32767;
 input;
 file x ;
 if not missing(_infile_) then put _infile_ ;
run;

proc import datafile=x out=x dbms=csv replace;
getnames=yes;
guessingrows=max;
run;

Re: how to read second row as columns names in csv file without deleting first row

Ksharp — Fri, 12 Mar 2021 12:04:02 GMT

Or rename it after importing ?

proc import datafile='c:\temp\root.csv' out=data dbms=csv replace;
datarows=3;
guessingrows=max;
run;


options obs=2;
proc import datafile='c:\temp\root.csv' out=vname dbms=csv replace;
run;
options obs=max;

proc transpose data=vname out=vname2;
var _all_;
run;

proc sql noprint;
select catt(_name_,'=',col1) into :rename separated by ' ' from vname2;
quit;

proc datasets library=work nolist nodetails;
modify data;
rename &rename. ;
quit;