topic Data step in SAS Programming

Data step

aniketwagare0 — Wed, 27 Jul 2016 23:50:01 GMT

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 — Thu, 28 Jul 2016 00:12:20 GMT

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

Reeza — Thu, 28 Jul 2016 00:52:37 GMT

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: