1 st obs values came in variable names

Reply
Occasional Contributor
Posts: 15

1 st obs values came in variable names

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

Super User
Super User
Posts: 6,842

Re: 1 st obs values came in variable names

Delete the empty row at the top of the spreadsheet.

PROC Star
Posts: 7,431

Re: 1 st obs values came in variable names

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;

Contributor
Posts: 37

Re: 1 st obs values came in variable names

Set the GETNAMES option to YES in your libname.

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

Thanks

Karthik

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