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

[rkolupoti9001]

Have_Var	Want_Var
123q987	###$###
324s784	###$###
386	###
58881	#####
afgelk	$$$$$$

Hi,

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

Thanks in advance!!!!

[Reeza]

Look at the TRANSLATE function

Or the TRANSWRD

[Ksharp · Accepted solution]

Code: Program

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;