Database Reference
In-Depth Information
to the subset of used cells in the worksheet and the full worksheet. Both of names listed in the PROC
CONTENTS listing point to the same data. If the workbook had a named range created by Excel, the
named range would also show up in the PROC CONTENTS listing as a table. Full worksheet names end in
a $ when viewed as a SAS file, while the named ranges do not have a trailing $.
LIBNAME xls_data EXCEL 'C:\My_excel_files\my_excel_file.xls';
proc contents data=xls_data._all_;
run;
Figure 4.9.5a: Contents of the Created Excel File.
The CONTENTS Procedure
Directory
Libref XLS_DATA
Engine EXCEL
Physical Name C:\My_excel_files\my_excel_file.xls
User Admin
DBMS
Member Member
# Name Type Type
1 sheet1 DATA TABLE
2 sheet1$ DATA TABLE
The CONTENTS Procedure
Data Set Name XLS_DATA.sheet1 Observations .
Member Type DATA Variables 7
Engine EXCEL Indexes 0
Created . Observation Length 0
Last Modified . Deleted Observations 0
Protection Compressed NO
Data Set Type Sorted NO
Label
Data Representation Default
Encoding Default
Alphabetic List of Variables and Attributes
# Variable Type Len Format Informat Label
6 Inventory Num 8 DOLLAR21.2 DOLLAR21.2 Inventory
2 Product Char 14 $14. $14. Product
1 Region Char 25 $25. $25. Region
7 Returns Num 8 DOLLAR21.2 DOLLAR21.2 Returns
5 Sales Num 8 DOLLAR21.2 DOLLAR21.2 Sales
4 Stores Num 8 Stores
3 Subsidiary Char 12 $12. $12. Subsidiary
The CONTENTS Procedure
Data Set Name XLS_DATA.'sheet1$'n Observations .
Member Type DATA Variables 7
Engine EXCEL Indexes 0
Created . Observation Length 0
Last Modified . Deleted Observations 0
Protection Compressed NO
Data Set Type Sorted NO
Label
Data Representation Default
Encoding Default
Search WWH ::
Custom Search