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