topic Re: converting data to a different scale in SAS Programming

converting data to a different scale

olivia123456 — Tue, 09 Apr 2019 21:07:54 GMT

How do you convert data scores that are normally out of 30 to out of 100 on SAS and how to round them to a 2 decimal space.

Re: converting data to a different scale

PaigeMiller — Tue, 09 Apr 2019 21:38:02 GMT

@olivia123456 wrote:

How do you convert data scores that are normally out of 30 to out of 100 on SAS

Do you mean you have scores 0 to 30 and you want them to be 0 to 100?

If so, you can multiply each score on the 0 to 30 scale by 100/30

and how to round them to a 2 decimal space.

Use the ROUND function

https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p0tj6cmga7p8qln1ejh6ebevm0c9.htm&docsetVersion=3.1&locale=en

Re: converting data to a different scale

olivia123456 — Wed, 10 Apr 2019 03:43:07 GMT

I am personally confused on the round function because I don't understand what to put in the parenthesis for round(x, #).

Yes two decimal space

I need to change the scale as in if I had a score of 19/30 and all my other numbers are out of 30, is there a SAS function for SAS to translate them all out of 100 such as 15/30 to 50/100?

Re: converting data to a different scale

ScottBass — Wed, 10 Apr 2019 04:32:02 GMT

/* algebra:
15/30 = X/100
(15/30)*100 = (X/100)*100
(15/30)*100 = X
*/

data want;
   do score=0 to 30;
      result30=score/30;
      result100=(result30)*100;
      result100rnd0=round(result100,1);
      result100rnd1=round(result100,.1);
      result100rnd2=round(result100,.01);  * <<< this is probably what you want? ;
      result100rnd3=round(result100,.001);
      output;
   end;
run;

is there a SAS function for SAS to translate them all out of 100 such as 15/30 to 50/100?

No. Nor is there one to translate them all from 23 to 105, 42 to 132, 13 to 48, etc. But the math is relatively simple.