topic FOR EXPOTING IN TEXT with 3 Delimiters in SAS Programming

FOR EXPOTING IN TEXT with 3 Delimiters

sas_ — Thu, 09 Feb 2012 06:07:32 GMT

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;

FOR EXPOTING IN TEXT with 3 Delimiters

ArtC — Thu, 09 Feb 2012 06:50:20 GMT

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;

FOR EXPOTING IN TEXT with 3 Delimiters

sas_ — Thu, 09 Feb 2012 07:07:41 GMT

Thqs

FOR EXPOTING IN TEXT with 3 Delimiters

sas_ — Thu, 09 Feb 2012 07:15:27 GMT

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

FOR EXPOTING IN TEXT with 3 Delimiters

ArtC — Thu, 09 Feb 2012 16:51:01 GMT

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.