topic row delimiter other than CRLF in SAS Programming

row delimiter other than CRLF

deleted_user — Sat, 30 Aug 2008 11:19:25 GMT

Hi,
I need to know if it is possible to create a delimited variable length 'flat' file which requires a row delimiter other than the standard CRLF (in this case, the row delimiter is 'F3'x, i.e., ascii character 243). Not sure if it matters, but the operating system is Windows.

Thanks!

Re: row delimiter other than CRLF

sbb — Sat, 30 Aug 2008 12:29:37 GMT

Consider the TERMSTR option for the FILE statement in a DATA step. Have a look at the SAS support website http://support.sas.com/ and search on the parameter for DOC and other useful references.

Scott Barry
SBBWorks, Inc.

Re: row delimiter other than CRLF

deleted_user — Sat, 30 Aug 2008 21:17:17 GMT

Scott, thank you for the suggestion. I looked up termstr in the online docs, and it says:

TERMSTR=specifies the end-of-line character for the file. Use this option to share files between the UNIX and Windows operating environments. Valid values are:

CRLF
Carriage return line feed. Use TERMSTR=CRLF to write Windows formatted files. CRLF is the default.

LF
Line feed. Use TERMSTR=LF to write UNIX formatted files.

NL
New line. Use TERMSTR=NL to write UNIX formatted files.

...it looks like it doesn't give me the option to specify the row delimiter I'm trying to use; just crlf / lf / and nl ...any other thoughts on this?

Re: row delimiter other than CRLF

sbb — Sat, 30 Aug 2008 22:22:21 GMT

Sorry for the less-than-useful guidance. Check this comp.soft-sys.sas thread that is similar to yours? Mind any broken URL.

Scott Barry
SBBWorks, Inc.

http://groups.google.com/group/comp.soft-sys.sas/browse_thread/thread/67f67f471338bca6

Re: row delimiter other than CRLF

deleted_user — Sat, 30 Aug 2008 23:21:16 GMT

Thanks, Scott!