SAS Certification Prep Guide, 4th Edition

Creating Excel Worksheets

In addition reading Excel data, SAS can also create Excel worksheets from SAS data sets.

To do this, you use the SAS/ACCESS LIBNAME statement. For example, to create a new worksheet named high_stress from the temporary SAS data set work.high_stress and save this worksheet in the new Excel file newExcel.xlsx, you would submit the following LIBNAME statement and DATA step:

libname clinic xlsx 'c:\Users\mylaptop\newExcel.xlsx';
data clinic.high_stress;
   set high_stress;
run;

Last updated: January 10, 2018