topic Need to translate 0-9 to # and A-Z to $ in SAS Enterprise Guide

Need to translate 0-9 to # and A-Z to $

rkolupoti9001 — Wed, 01 Jul 2015 16:52:22 GMT

Hi,

I want to translate 0-9 character # and A-Z to $

Thanks in advance!!!!

Reeza — Wed, 01 Jul 2015 18:48:23 GMT

Look at the TRANSLATE function

Or the TRANSWRD

Ksharp — Thu, 02 Jul 2015 14:12:13 GMT

data have;
input x $20.;
cards;
123q987
;
run;
data want;
 set have;
 t=prxchange('s/\d/#/',-1,x);
 y=prxchange('s/[a-z]/$/i',-1,t);
 drop t;
run;