SUGI 27: Accessing Microsoft Excel and Microsoft …

Paper 25-27 Accessing Microsoft Excel and Microsoft access Through the Use of a Simple Libname Statement Kee Lee, Purdue University, West Lafayett e, Indiana ABSTRACT With the help of the SAS Acc ess , ODBC, and OLEDB, using Microsoft Excel Spreadsheet, Microsoft access data table, ORACLE data table and many other types of data that are ODBC/OLEDB compli ant has never been easier. Among other methods, you can use the LIBNAME statement to assign a li bref to the external data. Once a libref is successfully ass igned, you can use the da ta as you use the na tive SAS da ta set in the DATA step and many SAS procedures. You can even use SAS/ASSIST to access diff erent kinds of external data by pointing and cli ck ing. For people who need to integrate and distribute data to and from different types of external data, this feature cer tainly can allev iate a lot of pain.

Paper 25-27 Accessing MICROSOFT EXCEL and MICROSOFT ACCESS Through the Use of a Simple Libname Statement Kee Lee, Purdue University, West Lafayette, Indiana

Loading..

Tags:

  Excel, Access, Microsoft, Accessing, Accessing microsoft excel and microsoft, Accessing microsoft excel and microsoft access

Information

Related search queries