topic Re: Move deimal 2 places to the right in SAS Programming

Move deimal 2 places to the right

nbwest76 — Mon, 15 Jun 2020 23:59:11 GMT

I'm having trouble finding out which format will get the results I am looking for.

I'd like to convert a number like this 0.032258 to 3.2

Re: Move deimal 2 places to the right

novinosrin — Tue, 16 Jun 2020 00:04:46 GMT

Hi @nbwest76 are you asking percent format?

0.032258 is 3.2 %

Re: Move deimal 2 places to the right

Reeza — Tue, 16 Jun 2020 01:52:12 GMT

Multiply by 100 and format? Or apply a percentage format to your variable?

want = x * 100;
format want 8.1;
format x percent12.1;

Re: Move deimal 2 places to the right

ChrisNZ — Tue, 16 Jun 2020 01:58:51 GMT

You can also use the multiplier option in a picture format.

Re: Move deimal 2 places to the right

ghosh — Tue, 16 Jun 2020 02:04:25 GMT

Create a format to simulate percent if you don't want the % sign


proc format;
  picture perc (round)
  low - high ='009.9' (mult=1000);
run;
data x;
input a;
cards;
0.032258 
0.12345
1.2345
;

proc print;
  format a perc.;
run;