BookmarkSubscribeRSS Feed
cjohnson
Obsidian | Level 7
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
3 REPLIES 3
RickM
Fluorite | Level 6
Try the following:

DATA _NULL_;
FILE "TEST.TXT" MOD;
SET ISO.POLTRANS;
PUT (_ALL_) (+(-1));
RUN;
NickR
Quartz | Level 8
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;
cjohnson
Obsidian | Level 7
Thanks guys! That did the trick!
Christopher Johnson
www.codeitmagazine.com

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand in the Innovate Hub.

Watch Now →
What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 3 replies
  • 4747 views
  • 0 likes
  • 3 in conversation