In Windows operating environments, SAS autoimporterv9 programs enable you to automatically import all worksheets in a Microsoft Excel Workbook. In order to use these programs, you must have SAS/ACCESS^® Interface to PC File Formats and SAS^®9 licensed and installed.

You can obtain all of these programs from the Downloads tab or you can access individual programs directly by clicking the following filenames:

• autoimporterv9.sas automatically imports all worksheets in a Microsoft Excel workbook. The program requires that you specify the XLS file.
  
  
• autoimporterv9csheettrack.sas automatically imports all worksheets in a Microsoft Excel workbook and identifies the original importing sheet in a master file. The program requires that you specify the XLS file.
  
  
• autoimporterv9attrib2h.sas automatically imports all worksheets in a Microsoft Excel workbook, but it has an additonal option to calculate the lengths of the variables in the individual data sets before you create a master data set. The program requires that you specify the XLS file.
  
  
• autoimporterv9access.sas automatically imports all Microsoft Access tables in a Microsoft Access MDB file. The program requires that you specify the MDB file.
  
  
• autoimporterv9accesspw.sas automatically imports all Microsoft Access tables in a Microsoft Access MDB file that has a password. The program requires that you specify the MDB file and the password.

Both autoimporterv9access.sas and autoimporterv9accesspw.sas have the ability to append or create a new master SAS data set that contains all the sheets of data.

Operating System and Release Information

Click the following link to access SAS autoimporterv9 programs that enable you to automatically import all worksheets in a Microsoft Excel workbook:

ftp://ftp.sas.com/techsup/download/base/