topic Re: PROC EXPORT file .txt in SAS Procedures

PROC EXPORT file .txt

CMilena — Tue, 08 Mar 2011 15:11:14 GMT

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

Re: PROC EXPORT file .txt

Cynthia_sas — Tue, 08 Mar 2011 15:19:01 GMT

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

Re: PROC EXPORT file .txt

Ksharp — Mon, 19 Dec 2016 14:31:26 GMT

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

Re: PROC EXPORT file .txt

CMilena — Wed, 09 Mar 2011 15:24:17 GMT

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 !!

Re: PROC EXPORT file .txt

Ksharp — Thu, 10 Mar 2011 03:30:57 GMT

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

Ksharp