DATA Step, Macro, Functions and more

Data step

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

Data step

[ Edited ]

I am runing following code in OnDeamand Academic Studio,

libname orionx XLSX "/home/aniketwagare0/test/ecprg193/lpar.xls";
libname output "/home/aniketwagare0/test/output";

data output.test1;
set orionx.'lpar$'n;
run;

getting error shown in SAS1.png


SAS1.png

Accepted Solutions
Solution
‎07-28-2016 07:00 PM
PROC Star
Posts: 1,563

Re: Data step

Look at the contents of library orionx instead of looking at the file list.

 

View solution in original post


All Replies
Solution
‎07-28-2016 07:00 PM
PROC Star
Posts: 1,563

Re: Data step

Look at the contents of library orionx instead of looking at the file list.

 

Super User
Posts: 17,864

Re: Data step

lpar is your filename. 

In this type of access SAS is expecting the Sheet name. As @ChrisNZ navigate to the Library Pane and see the name there. 

 

As mentioned earlier, this was answered a few days ago, heres' the link:

 

https://communities.sas.com/t5/Base-SAS-Programming/Import-data-from-XLS-in-SAS-OnDemand-for-Academi...

☑ This topic is SOLVED.

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

Discussion stats
  • 2 replies
  • 225 views
  • 1 like
  • 3 in conversation