convert flat files in PC format to Unix format

[4john]

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

Thanks

[Cynthia_sas]

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

[4john]

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.

[Doc_Duke]

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

[4john]

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

[Doc_Duke]

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

[andreas_lds]

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.

[4john]

Thanks Andreas.