Excel to Datasets by passing Macros

[R_Win]

In a Excel work book i have 20 sheets of data .Now i want to create 20 datasets from them by passing a macro.

[Peter_C]

why use a macro?
just use a LIBNAME statement.

PeterC

[Doyleuk]

Yeah thats what i would suggest.

libname test 'c:\excel_file.xls';

what you need to remember is when you are using the sheets in datasteps.

For Example

data New_dataset;
set test."Sheet1$"n;
run;

/*You need to have the sheet1 enclosed within brackets*/
/*there is also a need to include the $ and the n for the */
/*data step to work correctly */