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

Reading Data from a SAS File List

Reading Data from a SAS File List

A SAS file list contains a list of SAS file names from which you want the Integration Service to read data.
When you configure a session to read data from a SAS file list, you must use the Indirect file type option.
In the
Read From File
session properties, type
Yes
and select
Indirect
as the
File Type
to indicate that you want the Integration Service to read data from SAS files specified within the SAS file list.
Specify the
SAS File Directory
path where the SAS file list resides and the
SAS File List
name, which is a
.txt
file that lists the SAS files.
Within the
.txt
file, you can specify the name of the SAS file, for example,
datetime1.sas7bdat
, or you can specify the full path where the SAS file is available on the Informatica server machine, for example,
C:\Informatica\10.2.0\server\infa_shared\SrcFiles\datetime2.sas7bdat
.
When you do not specify a path for a SAS file within the SAS file list, the Integration Service searches for the SAS file in the specified
SAS File Directory
path.

0 COMMENTS

We’d like to hear from you!