Using the Import Wizard to Convert a Spreadsheet to a SAS Data Set
Creating an Excel Spreadsheet from a SAS Data Set
Using an Engine to Read an Excel Spreadsheet
Using the SAS Output Delivery System to Convert a SAS Data Set to an Excel Spreadsheet
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 option—see Chapter 3 for more information) and INPUT statements. However, ...