🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 03-08-2011 10:11 AM
(81331 views)
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
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
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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:
Hi.
How about this:
[pre]
proc export data=sashelp.class outfile='c:\class.txt' dbms=tab replace;
putnames=no;
run;
[/pre]
Ksharp
4 REPLIES 4
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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:
Hi.
How about this:
[pre]
proc export data=sashelp.class outfile='c:\class.txt' dbms=tab replace;
putnames=no;
run;
[/pre]
Ksharp
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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 !!
I read previous forum posting.
In the end I use
data _null_;
set db ;
file "P:\Risk Management\MORTGAGE\.........";
put (_all_) (:);run;
Thanks !!
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Do you test it by yourself.
I test it successfully in my SAS 9.2
Ksharp
I test it successfully in my SAS 9.2
Ksharp