SAS : Importing multiple excel sheets in a single dataset

Suppose you want to import multiple excel sheets with the same variable names into a library and then merge data from all the sheets to a single data set.

How to use :

1. Paste the above program into SAS program editor window
2. Change the path mentioned in the first line of program (highlighted below in red)

libname myxl excel 'C:\Deepanshu\SAS\Excel Sheets.xls' ;

3. Run the program

SAS Tutorials : 100 Free SAS Tutorials

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*

Related Posts:

1 Response to "SAS : Importing multiple excel sheets in a single dataset"

  1. Thanks a lot sir, Your Posts are really helping me good


Next → ← Prev