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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.