Using the SAS LIBNAME to Process Excel Files - Exchanging Data Between SAS and Microsoft Excel - page 63

Figure 4.9.5b: SAS View Table of the Sales_data1 File Read from Excel.

Example 4.8 Using Dataset Options to Process Variable Type Conversions
The next segment of SAS code reads all five fields from the Sales_Data Excel file, and did nothing with the
first three fields (Product, Amount, and Date_Ordered). The DBSASTYPE= dataset option took control of
formatting the dates when processing the Date_Shipped and Date_Delivered fields.

Field Name Processing Option Applied

Product Default as a character string.

●

Amount Default as a numeric currency value.

●

Date_Ordered Default as a DATE9. value.

●

Date_Shipped DBSASTYPE option converted the date to a 22-byte character value.

●

• Date_Delivered

DBSASTYPE option converted the Excel date value to a real number.