1 st obs values came in variable names

[padmakumariMiriyala]

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

[Tom]

Delete the empty row at the top of the spreadsheet.

[art297]

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;

[Karthikeyan]

Set the GETNAMES option to YES in your libname.

Eg :    libname doctors 'c:\clinicNotes\addresses.xlsx'  GETNAMES=YES ;

Thanks

Karthik