Lesson 2, Part 4B: SAS Code for Excel Workbooks/Sheets

ProcImport.sas

Method 1: Importing an Excel Spreadsheet into a SAS data set

options nodate nonumber nodate;
  PROC IMPORT DATAFILE= "C:\Explore\SAS\Lesson2\Lesson2Data\MEPS_MCCC.xlsx"
     dbms=xlsx REPLACE OUT= work.MCCC;
     SHEET="Sheet1";
     GETNAMES=YES;
 RUN;
Title;
 proc print data=work.MCCC (obs=5); 
 run;

Method 2: Using LIBNAME XLSX to read Excel files

The LIBNAME statement references the whole Excel file. The SET statement uses the Excel sheet as an input data file for this DATA step.

options validvarname=any;
libname XL XLSX 'C:\Explore\SAS\Lesson2\Lesson2Data\MEPS_MCCC.xlsx';
data work.MCCC;
  set XL.Sheet1;
run;
libname XL CLEAR; 
proc print data=work.MCCC (obs=5); 
run;

%let Path = C:\Explore\SAS\Lesson2\Lesson2Data;
options validvarname=any;
Libname XL XLSX "&Path\MEPS_MCCC.xlsx";
Libname new "&Path";
data new.MCCC_Data_x(keep=CCSR_Code MCCC);
  set XL.sheet1;
run;
libname XL CLEAR;