Chapter 4

Accessing Data: Oh, the Choices!

In This Chapter

bullet Using your PC files as data sources with SAS

bullet Using local PC connections to access your database

bullet Using super-fast data access to databases via your SAS server

The fact that SAS can meet just about any of your reporting and analysis needs is of little use if you can’t quickly and efficiently access your data wherever it exists. SAS has the broadest set of data access options available from any business intelligence or analytic product. Whether your data is in Microsoft Excel spreadsheets, relational databases, or legacy locations such as mainframe text files, you can access and use it as a source for your data reports and analyses.

SAS offers two approaches to accessing data:

bullet Opening a local data file or connecting to a data source from your local PC and moving it to your SAS server

bullet Accessing the data source directly from your SAS server

Using your local PC as a conduit to opening your data is more convenient than accessing ...

Get SAS For Dummies now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.