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.

CFC_SAS_Communities_400x225.jpgCFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

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
  • 2366 views
  • 0 likes
  • 3 in conversation