DATA Step, Macro, Functions and more

Considering second row in excel table as variable names in SAS

Accepted Solution Solved
Reply
Contributor
Posts: 55
Accepted Solution

Considering second row in excel table as variable names in SAS

Hi,

 

I am trying to create a SAS dataset using excel table as a source data. The below code is working if first row in excel table contains field names but I am facing problem for few .xlsx files which contains field names in second row.

I am using excel table import into SAS approach since .xlsm files works fine  instead of Proc import 

 

libname xlsFile XLSX "/usr/path/Monthly_8.2016.xlsx";
options validvarname=v7;
options SYMBOLGEN MPRINT;

PROC SQL;
    create table  work.raw_data as 
	(select * from xlsFile.'calc result'n);
quit;

Accepted Solutions
Solution
‎09-23-2016 02:55 PM
Regular Contributor
Posts: 175

Re: Considering second row in excel table as variable names in SAS

Posted in reply to jayakumarmm

Try specifying the range you import. See the example here.

View solution in original post


All Replies
Solution
‎09-23-2016 02:55 PM
Regular Contributor
Posts: 175

Re: Considering second row in excel table as variable names in SAS

Posted in reply to jayakumarmm

Try specifying the range you import. See the example here.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 457 views
  • 0 likes
  • 2 in conversation