05-08-2016 03:43 PM
When importing several worksheets ( but not all) from Excel into SAS, is there a way to import several worksheets instead of just one at a time with separate proc import procedure?
Thank you in advance!
05-08-2016 03:59 PM
Yes there is - using the LIBNAME statement with the EXCEL engine option:
You can then use the DATASETS procedure to copy all tabs in a workbook or choose selected tabs.