July 2018
Beginner
536 pages
12h 32m
English
Chapter 6: Reading and Writing Data from an Excel Spreadsheet
6.2 Using the Import Wizard to Convert a Spreadsheet to a SAS Data Set
6.3 Creating an Excel Spreadsheet from a SAS Data Set
6.4 Using an Engine to Read an Excel Spreadsheet
6.5 Using the SAS Output Delivery System to Convert a SAS Data Set to an Excel Spreadsheet
6.6 A Quick Look at the Import Utility in SAS Studio
It is quite common to be given a Microsoft Office Excel spreadsheet as your data source. Luckily, SAS has several methods to easily convert a spreadsheet into a SAS data set. One way is to convert the spreadsheet into a comma-separated values (CSV) file and to read the file using INFILE statements (using the DSD ...