topic Re: Help exporting to a text file (not delimited) in SAS Procedures

Help exporting to a text file (not delimited)

cjohnson — Fri, 15 Apr 2011 14:51:52 GMT

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

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

RickM — Fri, 15 Apr 2011 15:24:13 GMT

Try the following:

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

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

NickR — Fri, 15 Apr 2011 15:24:16 GMT

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;

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

cjohnson — Fri, 15 Apr 2011 16:03:28 GMT

Thanks guys! That did the trick!