Chapter 2: Reading, Combining, and Managing Data for Later Analysis 39
Display 2.13 includes the contents of the spreadsheet as it appears in a SAS library.Each
worksheet becomes a separate data set in SAS.Only Sheet1$ ispopulated with data; the
other two spreadsheets areempty.It is interesting that an Excel column labelthat isalso a
valid SAS variable name isassigned the SAS variable nameas itslabel. AnExcel column
that doesnot map to a valid SAS variable name (e.g., %WC) is modified to have a valid
SAS name by substituting an underscore for the percentage sign (e.g., _WC).The Excel
column headings areassigned as labels for ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.