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
About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 8 years of experience in data science. During his tenure, he has worked with global clients in various domains like Banking, Insurance, Telecom and Human Resource.

Related Posts:
3 Responses to "SAS : Importing multiple excel sheets in a single dataset"
  1. Thanks a lot sir, Your Posts are really helping me good

    ReplyDelete
  2. Hii
    can u please tell me why there is a need of concatenate ''n to memname .for eg in ur code it is like sasuser.'admit'n . and also when i run your cod i get appended data two times .

    ReplyDelete

We have Zero Tolerance to Spam. Comments with links will be deleted immediately upon our review.

Next → ← Prev
Love this Post? Spread the Word!
Share