Translate replaces characters from the list with equivalent characters from the replace list, not the whole word.  Tranwrd is the tool for replacing a whole text string with something else.  Per the manual: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000215153.htm   The prx is simply replacing the text string with the text string /n as you say, and that is correct.  The /n means newline in some file formats,much like ^{newline} can be used in rtf code.  Therefore the code is working, but your output renderer (rtf, pdf etc.) is either not setup to use the /n syntax, or its not valid for that renderer. ... View more

*selecting ONE-TWO UNION TWO-ONE; proc sql; create table result as select * from ( (select * from work.one where record_id not in (select distinct record_id from work.two) union select * from work.two where record_id not in (select distinct record_id from work.one) ) ) ; quit; You had not made your self very clear, let us know if this helped.  ... View more