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: 159

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

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: 159

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

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
  • 402 views
  • 0 likes
  • 2 in conversation