Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange Adapters for PowerCenter 10.5.1
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for SAS
  3. Installation and Configuration
  4. Working with SAS Sources
  5. Working with SAS Targets
  6. Working with SAS Sessions
  7. Appendix A: SAS Datatype Reference
  8. Appendix B: SPI Server Configuration Parameters
  9. Appendix C: Error Messages

PowerExchange for SAS User Guide for PowerCenter

PowerExchange for SAS User Guide for PowerCenter

Back Next

Editing a SAS Session

Editing a SAS Session

When you edit a SAS session, you can configure the SAS source and the target properties.
You can configure the following SAS properties in a session:
Property
Description
Libname Overrule
Optional. Overrides the library name associated with the SAS source or target.
By default, the PowerCenter Integration Service uses the library name configured on the
Metadata Extensions
 tab of the source or target.
Tablename Overrule.
Optional. Overrides the name of the SAS source or target table.
By default, the PowerCenter Integration Service uses the table name of the source or target as defined in the PowerCenter Designer.
Whereclause Overrule
Optional. Overrides the value for the WhereClause used while accessing the SAS data for reading for a SAS source.
PreSASCode overrule
Overrules the value for the PreSASCode exit attribute. The valid values are a SAS Macro or a SAS %include statement.
PostSASCode overrule
Overrules the value for the PostSASCode exit attribute. The valid values are a SAS Macro or a SAS %include statement.
Read From File
Determines whether you can read data from a SAS source or from a SAS file.
Specify
Yes
 to read data from a SAS file or file list.
Specify
No
 to read data from a SAS source.
SAS File Directory
The path to the directory where the SAS file or file list for a SAS source resides from where you want to read the data.
Applicable when you specify
Read From File
 as
Yes
.
SAS File Name
The name of the SAS file for a SAS source from which you want to read data.
Applicable when you specify
Read From File
 as
Yes
.
File Type
Determines whether the Integration Service reads data from a file or from a file list.
You can select from the following options to read data:
  • Direct. Reads data from a SAS file you specify.
  • Indirect. Reads data from a SAS file list you specify.
SAS File List
The name of the file list
.txt
 file that contains a list of SAS files from which to read data.
The Integration Service reads data from the file list
.txt
 file that is available in the path you specify in
SAS File Directory
 field.
Within the
.txt
 file, you can specify either the name of the SAS file or the full path where the SAS file is available on the Informatica server machine.
When you do not specify a path for the SAS file in the file list, the Integration Service searches for the SAS file in the
SAS File Directory
 path.
Join Type Overrule
Optional. Overrides the join type defined for the SAS sources.
By default, the PowerCenter Integration Service uses the join type defined in the source qualifier.
Join Condition Overrule
Optional. Overrides the join condition defined for the SAS sources.
By default, the PowerCenter Integration Service uses the join condition defined in the source qualifier.
Load Type
Configures the load type for the session.
Password
Determines whether SAS compresses target data. Used in sessions writing to SAS targets using a full load type.
For more information about SAS compression, see
“Data Set Option COMPRESS'"
 in the
SAS
 documentation.
You can use mapping parameters and variables in the Libname, Tablename, WhereClause, Pre/PostSASCode Overrule, SAS File Directory, and SAS File Name properties.
0 COMMENTS
We’d like to hear from you!