BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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!
4 REPLIES 4
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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.
deleted_user
Not applicable
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?
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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
deleted_user
Not applicable
Thanks, Scott!

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1760 views
  • 0 likes
  • 2 in conversation