iam reading excel sheet in sas using libname
variables names came in f1 f2 f3 .............
my requirment is 1st obs values come in to variable name,
for example ;
i have data like this:
obs f1 f2 f3 f4
history jan feb mar apr
saves 400 300 200 100
expences 500 300 100 700
i want like this:
history jan feb mar apr
saves 400 300 200 100
expences 500 300 100 700
help me ,
thanks in advance
Delete the empty row at the top of the spreadsheet.
If it's an XLS file you can use proc import with the XLS engine. e.g.:
proc import file='c:\temp\filename.xls' out=op dbms=xls replace;
namerow=2;
startrow=3;
getnames=yes;
run;
Set the GETNAMES option to YES in your libname.
Eg : libname doctors 'c:\clinicNotes\addresses.xlsx' GETNAMES=YES ;
Thanks
Karthik
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.