BookmarkSubscribeRSS Feed
SASPhile
Quartz | Level 8


How to export with a control A character as delimiter and not giving any file extension like .txt or csv. just a flat file and no column names in output file.

   proc export data=qc1

  outfile='/idn/crdc//link/qc1

dbms=dlm;

        delimiter='01x';

replace;

putnames=no;

run;

2 REPLIES 2
data_null__
Jade | Level 19

You have the syntax a bit off.  Here I create a TEMP file write to it and use a data step to look at.

filename FT48F001 temp;
proc export data=sashelp.class outfile=FT48F001 replace DBMS=DLM;
   DELIMITER='01'x;
  
PUTNAMES=no;
   run;


data _null_;
  
infile FT48F001;
   input;
  
list;
  
run;
art297
Opal | Level 21

Like data_null_ suggests:

1. remove the semicolon after dbms=dlm

2. change your delimiter option from delimiter='01x'; to

     delimiter='01'x;

but also 3.  end your outfile statement filename with a single quote since you began it with a single quote.

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
  • 3472 views
  • 2 likes
  • 3 in conversation