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

[allurai0412]

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]

1)

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.