Help using Base SAS procedures

Help exporting to a text file (not delimited)

Reply
Frequent Contributor
Posts: 97

Help exporting to a text file (not delimited)

I could really use some help exporting data to a text file. I have a table of data, all columns are text. I need to export this data (append to the end of) a text file with no delimiter between variables.

I have tried the following methods:

PROC EXPORT DATA=ISO.POLTRANS OUTFILE="TEST.TXT" REPLACE;
DELIMITER="";
RUN;

DATA _NULL_;
FILE "TEST.TXT" dsd dlm="";
SET ISO.POLTRANS;
PUT (_ALL_) (+0);
RUN;

Either method puts a space between variables. Also, either method replaces, not appends to, the file.

I would really appreciate any help.

Thanks,
Chris
Christopher Johnson
www.codeitmagazine.com
Regular Contributor
Posts: 165

Re: Help exporting to a text file (not delimited)

Try the following:

DATA _NULL_;
FILE "TEST.TXT" MOD;
SET ISO.POLTRANS;
PUT (_ALL_) (+(-1));
RUN;
Frequent Contributor
Posts: 81

Re: Help exporting to a text file (not delimited)

You can use 'mod' option to append the text.

data test;
name1 = 'Dan';
name2 = 'Tom';
name3 = 'Randy';
run;

data _null_;
file "test.txt" dsd dlm='' mod;
set test;
put (_all_) (+(-1));
run;
Frequent Contributor
Posts: 97

Re: Help exporting to a text file (not delimited)

Thanks guys! That did the trick!
Christopher Johnson
www.codeitmagazine.com
Ask a Question
Discussion stats
  • 3 replies
  • 906 views
  • 0 likes
  • 3 in conversation