topic Reading flat file using pass through facility in SAS Programming

Reading flat file using pass through facility

Siddhartha — Thu, 13 Aug 2009 17:16:59 GMT

How can i read a flat file using pass through facility(not odbc)?
Could any one help me in this regard.

Regards,
Sidhu

Re: Reading flat file using pass through facility

sbb — Thu, 13 Aug 2009 17:46:24 GMT

From the SAS support http://support.sas.com/ website - topic-search resulted in this SAS-hosted DOC match/link:

SAS Language Reference: Concepts, Reading Raw Data:
http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a001112330.htm

SAS Language Reference: Concepts, Ways to Read Raw Data
http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a003209898.htm

I believe that the pass-through facility is specific to PROC SQL:

SAS Language Reference: Concepts, SQL Procedure Pass-Through Facility
http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a001044413.htm

Scott Barry
SBBWorks, Inc.

Re: Reading flat file using pass through facility

LinusH — Fri, 14 Aug 2009 14:15:09 GMT

Can you be more specific about your situation?
Where is the flat file stored vs your SAS session?
Where do you want to store the imported data?
Why do you think you need pass thru? SQL pass thru generally is used for work with data base data, not raw data.

/Linus