Ebook: SAS ACCESS 9.1 Interface to PC Files: Reference

The SAS/ACCESS interface to PC files enables you to access and use PC files quickly and easily. All the power and flexibility of SAS can be used to analyze and present data directly from popular PC file formats. Gaining access to PC files can be as simple as filling in the blanks, and analyzing and reporting can be as easy as pointing and clicking. In this handy reference, you will find detailed information about PC file specific procedures, statements, options, and environment variables, as well as basic information about each PC file. You will learn how to use statements and options for the IMPORT, EXPORT, ACCESS, DBLOAD, DBF, and DIF procedures to transfer data between SAS and the supported PC files, use the Import/Export wizard and procedures to access files stored on the PC, access data in DBF files under Windows, UNIX, and OpenVMS; and in DIF, Excel, Access, and Lotus files under Windows and UNIX, create and update access descriptors and view descriptors, use the LIBNAME statement to provide direct access to data, use the Pass-Through Facility to interact with data using the data source's SQL syntax, communicate with the PC using the new pcfiles engine, and access data stores using the PC files server.