DATA Step, Macro, Functions and more

row delimiter other than CRLF

Reply
N/A
Posts: 0

row delimiter other than CRLF

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!
Super Contributor
Super Contributor
Posts: 3,174

Re: row delimiter other than CRLF

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.
N/A
Posts: 0

Re: row delimiter other than CRLF

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?
Super Contributor
Super Contributor
Posts: 3,174

Re: row delimiter other than CRLF

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
N/A
Posts: 0

Re: row delimiter other than CRLF

Thanks, Scott!
Ask a Question
Discussion stats
  • 4 replies
  • 379 views
  • 0 likes
  • 2 in conversation