57
Is There a LIBNAME Engine to Excel?
SAS/ACCESS for PC file formats does support LIBNAME.
• Probably the most simple of all techniques.
• LIBNAME assigns a libref to Microsoft Excel and other data sources.
• Allows you to reference an Excel workbook as a SAS library.
• Worksheets within the workbook are treated as SAS data files.
• Some naming conventions and internal storage are different.
• Generally we can read and write Excel data as a SAS dataset.
Choosing the Right Tool from Your SAS
®
and Microsoft Excel
®
Tool Belt
Kommentare zu diesen Handbüchern