DATA Step, Macro, Functions and more

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

Reply
Frequent Contributor
Posts: 97

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

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

Respected Advisor
Posts: 3,124

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

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.

Ask a Question
Discussion stats
  • 1 reply
  • 151 views
  • 3 likes
  • 2 in conversation