topic Re: Excel to Datasets by passing Macros in SAS Procedures

Excel to Datasets by passing Macros

R_Win — Fri, 08 May 2009 05:14:14 GMT

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

Re: Excel to Datasets by passing Macros

Peter_C — Fri, 08 May 2009 11:20:34 GMT

why use a macro?
just use a LIBNAME statement.

PeterC

Re: Excel to Datasets by passing Macros

Doyleuk — Fri, 08 May 2009 11:45:35 GMT

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 */