Hi , I have an dataset with multiple columns, some of the columns are derived fields with no values.I need to export an data to the text file with delimited tilde , in that need to get an spaces between two '~'. Example : data test; input id name $ ; datalines; 1 bob 2 dave 3 cari 4 laura 5 sunny ; run; Adding extra variables to the table: proc sql; alter table test add prov_localty char, prov_spec char; quit; proc sql; create table test1 as select id as id_num, prov_localty, prov_spec, name from test; quit; proc export data=work.test1 outfile="C:\Documents and Settings\Desktop\test.dat" DBMS=DLM Replace; DELIMITER= '~'; RUN; output looks like this when exporting an data: id_num~prov_localty~prov_spec~name 1~~~bob 2~~~dave 3~~~cari 4~~~laura 5~~~sunny Need to get an outlike look like this: id_num~prov_localty~prov_spec~name 1~ ~ ~bob 2~ ~ ~dave 3~ ~ ~cari 4~ ~ ~laura 5~ ~ ~sunny Thanks in advance
... View more