Data step

[aniketwagare0]

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

[ChrisNZ · Accepted solution]

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

[Reeza]

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...