FOR EXPOTING IN TEXT with 3 Delimiters

[sas_]

Hi i am having data but i wnat to export the data into text file but i want to give 3 delimeters ,how can i do it ,i have tested it but it was taking only one delimter.

proc export data=test outfile="/tmp/mydata/test.txt"

   dbms=dlm replace;

   delimiter='^?/';

run;

[ArtC · Accepted solution]

The DATA step can be used to write delimited files.  Consider this step as a starting point.

data _null_;

   set sashelp.class;

   file "c:\temp\test.txt"

         dlmstr='^?/';

   put name age sex height weight;

   run;

[sas_]

Thqs

[sas_]

but i am not getting the variable names if i wnat the variable names what should i do i have used put also.

[ArtC]

This will add the variable names.

data _null_;

   set sashelp.class;

   file "c:\temp\test.txt"

         dlmstr='^?/';

   if _n_=1 then put 'name^?/age^?/sex^?/height^?/weight';

   put name age sex height weight;

   run;

There are DATA step solutions that do not require you to know the variable names, but they are more complicated.