topic Re: export with a control A character as delimiter in SAS Programming

export with a control A character as delimiter

SASPhile — Fri, 16 Nov 2012 20:56:03 GMT

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;

Re: export with a control A character as delimiter

data_null__ — Fri, 16 Nov 2012 21:25:01 GMT

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;

Re: export with a control A character as delimiter

art297 — Fri, 16 Nov 2012 21:33:36 GMT

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.