Infile Format Question -Pipe delimtied file

deleted_user — Thu, 07 Jun 2007 15:24:02 GMT

infile "O:\Raw Data Extracts\Client.txt" recfm=v dsd dlm='|' pad missover LRECL=1100 firstobs=1;

I am trying to import a file to SAS; it is a text file in a pipe delimited format. Though I am using dsd function it truncates 2 pipes as one pipe example

Firstname|Lastname|City|PostalCode|Country
Gautam|Mohorikar|Toronto||Canada

Here If I import this file with the dsd statement, Canada will appear in the PostalCode column.

But if this file was a comma delimited file the dsd function works well see the below command.

infile "O:\Customer Knowledge\Client Information\Client.txt" recfm=v dsd dlm=',' pad missover LRECL=1100 firstobs=1;

I hope you guys can help.

Thx,

Gautam

Re: Infile Format Question -Pipe delimtied file

Cynthia_sas — Thu, 07 Jun 2007 19:51:30 GMT

Hi!
This is really not an ODS-related question. Your best bet for help with DATA step statements for INFILE and INPUT is Tech Support. To learn how to contact Tech Support, consult:
http://support.sas.com/techsup/contact/index.html

Good luck!
cynthia

topic Infile Format Question -Pipe delimtied file in ODS and Base Reporting

Infile Format Question -Pipe delimtied file

Re: Infile Format Question -Pipe delimtied file