Transcription of SUGI 27: Accessing Microsoft Excel and Microsoft …
{{id}} {{{paragraph}}}
Example: barber
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. This paper focuses on acc ess Microsoft Excel and Microsoft ACCESS data. Let s see how it To do this, I use PC with NT or Window 2000, SAS/BASE product and SAS/ACCESS for PCs.
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:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
A Grade Sheet With Microsoft Excel, Using Microsoft Excel, Microsoft Excel, Intermediate Microsoft Excel, Intermediate . Microsoft Excel, Microsoft, Apache OpenOffice, Excel, Getting the Most From Microsoft Excel, Formulas & Functions in Microsoft Excel, Creating Stylish Multi-Sheet Microsoft, Creating Stylish Multi-Sheet Microsoft Excel, Microsoft Excel 2016 Parts of, Microsoft Excel 2007 Keyboard Shortcuts