Summary

h
  1. A file reference (FILEREF) is the name given to an external file. It can be created using a FILENAME statement.
  2. The Proc Import procedure includes four basic options:

    DATAFILE option
    The DATAFILE option specifies the external file to be imported. 

    OUT Option
    The OUT option specifies the output data set. 

    DBMS Option
    The DBMS option allows you to specify the type of data file to import.

    Below are the values for the different file types:
    XLSX: Excel Spreadsheet
    CSV: CSV File
    -TAB: Tab-delimited File
    DLM: Other Delimited File

    REPLACE Option
    The REPLACE option tells SAS to replace the existing data set if it already exists. 
  3. The SHEET statement is a separate statement from the Proc Import statement. It allows you to select another workbook to import.
  4. The GETNAMES statement allows you to control whether or not the first row of data contains variable names.
  5. The GUESSINGROWS statement specifies the number of rows to use to "guess" the attributes of the variables.
  6. The DELIMITER statement is used when importing delimited text files. It allows you to specify the delimiter for the external files.
  7. When reading a tab-delimited file, the DBMS option should be specified as TAB (not DLM) and the delimiter should be specified as '09'x
  8. The SAS XLSX engine is another method to read data from an Excel spreadsheet. It requires just a single LIBNAME statement.
  9. When you encounter situations where a SAS name contains a space, you can use a name literal to reference the SAS name.
  10. The SAS XLSX engine can also be used to export data to an Excel file.
  11. ‚ÄčThe library reference can be disassociated by using the CLEAR argument in the LIBNAME statement.