SAS ACCESS 9.1 Interface To Peoplesoft: User's Guide

✍ Scribed by The SAS Technical Team Writers

• Publisher: SAS Publishing
• Year: 2004
• Tongue: English
• Leaves: 49
• Category: Library

✦ Synopsis

The SAS/ACCESS interface to PeopleSoft gives you a way to utilize your PeopleSoft data with SAS and advanced SAS solutions. This interface gives you the power to uncover valuable facts about how your PeopleSoft system is organized and where valuable information might be found. In this title you will learn how to extract, browse, and search PeopleSoft metadata and use the PeopleSoft metadata to build SAS views of PeopleSoft tables. You can save these views as permanent SAS views, data files, or source code. This guide provides glossary definitions and tutorial instruction for a novice user. Once you have mastered the tutorial, you can use the rest of the guide for reference. This title is intended for applications programmers and other users who are familiar with either SAS or PeopleSoft software. It is assumed, however, that users are completely unfamiliar with using both of the systems together.

✦ Table of Contents

Front Cover
......Page 1
Contents......Page 4
Audience......Page 6
Product Overview......Page 7
Getting Started with SAS/ACCESS Interface to PeopleSoft......Page 9
Browsing and Querying Using the PeopleSoft Metadata......Page 10
Searching the Extracted PeopleSoft Metadata......Page 11
Browsing PeopleSoft Records......Page 14
Saving PeopleSoft Data and Queries......Page 18
Searching Your Extracted PeopleSoft Metadata......Page 20
Browsing and Saving Your Search Results......Page 24
Updating SAS Libraries and Default File Settings......Page 26
Updating Effective Date and Record Limit Defaults......Page 29
Defining Required Libraries......Page 32
Using the Metadata Extract Wizard......Page 33
PeopleSoft Database Administration......Page 36
SAS Naming Conventions and Support for PeopleSoft Names......Page 37
Recommended Reading......Page 38
Glossary......Page 40
Index......Page 44