topic How to Replace numeric values to character in Statistical Procedures

How to Replace numeric values to character

vThanu — Thu, 24 Jan 2019 09:09:25 GMT

data have;
input a;
cards;
12.22
132.113
1.2455
;

run;

Can any one help me how to replace the entire numeric values expect '.' (decimals) with some charater

expeted result is like below.

xx.xx

xxx.xxx

x.xxxx

Re: How to Replace numeric values to character

Ksharp — Thu, 24 Jan 2019 10:02:58 GMT


proc fcmp outlib=work.func.fmt;
function fmt(x) $;
  length y $ 32;
  y=translate(strip(put(x,best32.)),'xxxxxxxxxx','0123456789');
  return (y);
endsub;
run;
options cmplib=work.func;
proc format ;
value xfmt
 low-high=[fmt()];
run;
data have;
input a;
format a xfmt32.;
cards;
12.22
132.113
1.2455
;

run;

Re: How to Replace numeric values to character

vThanu — Thu, 24 Jan 2019 10:25:40 GMT

Thank you soo mcuh for you support..