topic Re: 1 st obs values came in variable names in SAS Programming

1 st obs values came in variable names

padmakumariMiriyala — Sat, 04 Apr 2015 10:13:36 GMT

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 — Sat, 04 Apr 2015 13:32:45 GMT

Delete the empty row at the top of the spreadsheet.

art297 — Sat, 04 Apr 2015 13:50:45 GMT

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 — Sat, 04 Apr 2015 14:35:10 GMT

Set the GETNAMES option to YES in your libname.

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

Thanks

Karthik