topic convert flat files in PC format to Unix format in SAS Programming

convert flat files in PC format to Unix format

4john — Wed, 01 Dec 2010 17:31:51 GMT

Can any one please suggest a way to convert multiple(>25) flat files in PC format to Unix format in SAS?

Thanks

Re: convert flat files in PC format to Unix format

Cynthia_sas — Wed, 01 Dec 2010 17:56:32 GMT

HI:
I'm confused, ASCII text files are ASCII text files. Both the PC and UNIX use ASCII. Can you elaborate a bit on how you expect the format to differ between PC format and Unix format?

Whenever I FTP my ASCII flat files from the PC to Unix, or vice versa, I don't need to do anything to convert them....hence my confusion.

cynthia

Re: convert flat files in PC format to Unix format

4john — Wed, 01 Dec 2010 18:10:23 GMT

all the .csv files are created on a PC and all have ANSI format.So before I read them into Unix SAS,I need to convert them into Unix format.Else,last variable is not getting populated properly.

Re: convert flat files in PC format to Unix format

Doc_Duke — Wed, 01 Dec 2010 18:42:15 GMT

The PC ASCII format uses a different end-of-line marker () from that used in Unix ASCII (). This can cause some headaches. FTP knows about this difference.

There are programs that can do the conversion and run as batch files or unix scripts. They are called dos2unix (there is also a unix2dos) and exist for both the PC and unix platforms.

Doc Muhlbaier
Duke

Re: convert flat files in PC format to Unix format

4john — Wed, 01 Dec 2010 19:13:30 GMT

Is there a way to do it using call system or %sysexec ?

Re: convert flat files in PC format to Unix format

Doc_Duke — Thu, 02 Dec 2010 21:02:43 GMT

sure. Just code it like any other X-type command.

Re: convert flat files in PC format to Unix format

andreas_lds — Fri, 03 Dec 2010 10:33:19 GMT

Why do you want to convert the files? Importing the text-file by using the infile-statements' termstr-option set to crlf works like charm.

Re: convert flat files in PC format to Unix format

4john — Mon, 06 Dec 2010 21:37:29 GMT

Thanks Andreas.