PROC EXPORT file .txt

[CMilena]

When I export txt file whit PROC EXPORT

PROC EXPORT DATA= RATA_0_TXT
OUTFILE= "P:\Risk Management\MORTGAGE\...............txt"
DBMS=TAB REPLACE;
RUN;

I wouldn’t write the column's name .
How can I do?

Thanks in advance

[Cynthia_sas]

Hi:
There have been many previous forum postings on this topic. If you use the forum's search facility you should be able to find some of those previous solutions.

cynthia

[Ksharp · Accepted solution]

Editor’s Note: This is a popular topic. Thanks to @Ksharp for providing the solution below. The following SAS Note shows how to control variable names when using PROC EXPORT with a comma, tab or delimited file:

Usage Note 41735

Hi.
How about this:


[pre]
proc export data=sashelp.class outfile='c:\class.txt' dbms=tab replace;
putnames=no;
run;
[/pre]


Ksharp

[CMilena]

The option putnames=no don't run.
I read previous forum posting.

In the end I use

data _null_;
set db ;
file "P:\Risk Management\MORTGAGE\.........";
put (_all_) (:);run;


Thanks !!

[Ksharp]

Do you test it by yourself.
I test it successfully in my SAS 9.2


Ksharp