BookmarkSubscribeRSS Feed
Aar684
Calcite | Level 5
Hi all,

I am trying to export a data table to txt file WITHOUT the column headers. I feel like I am doing this correctly but I keep getting the statement is not valid or used out of order error. What am I doing wrong?

PROC EXPORT DATA= WORK.Final

OUTFILE= "C:\Documents and Settings\dubauaw\Desktop\r1.txt"
DBMS=TAB REPLACE;
putnames = no;
RUN;
2 REPLIES 2
Reeza
Super User
dbms option should be dlm for delimited and delimiter='09'x I think.

proc export data=sashelp.class outfile='c:\temp\test.txt' dbms=dlm replace;
delimiter='09'x;
putnames = no;
run;
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
I found PUTNAMES documented with SAS 9.2 -- I too received the same error when using it with SAS 9.1.3.

Scott Barry
SBBWorks, Inc.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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