topic creating datasets with multiple Excel 'sheets' with libname... in SAS Programming

creating datasets with multiple Excel 'sheets' with libname...

allurai0412 — Tue, 21 May 2013 09:07:39 GMT

hi,

I need to create datasets By excel file with sheet1 , sheet2 , sheet3 ....with LIBNAME statements...

i am not very good at LIBNAME...

1)Kindly provide me an example

2)Please provide me link or documentaion fo LIBNAME ...with excel,print...etc.,

Regards

Allu

Haikuo — Tue, 21 May 2013 12:52:34 GMT

libname test "multisheet.xls";

data test.sheet1;

set sashelp.class;

run;

data test.sheet2;

set sashelp.buy;

run;

data test.sheet3;

set sashelp.air;

run;

libname test;

2) Google it.