topic Re: Create a new variable for rounding in SAS Procedures

Create a new variable for rounding

starz4ever2007 — Sat, 21 Jul 2018 18:40:14 GMT

I have the following dataset:

Subject Score

1 3.432

2 4.83455

3 6.8333

4 14.834

and i want:

Subject Score Score_round

1 3.432 3

2 4.83455 5

3 6.8333 7

4 14.234 14

So far I've only found (but only as an output):

data new;
format score 9.0;
set old;
run;

I ultimately want a new variable created in the dataset called score_round (from the score variable)

Re: Create a new variable for rounding

novinosrin — Sat, 21 Jul 2018 18:49:21 GMT

data have;
input Subject       Score  ;              
cards;
1                  3.432
2                  4.83455
3                  6.8333
4                  14.834
5                  14.234 
;
data want;
set have;
score_round=round(score);
run;

did you try the round function?

score_round=round(score);

Re: Create a new variable for rounding

starz4ever2007 — Sat, 21 Jul 2018 18:52:53 GMT

thank you!! thought it was gonna be something more complicated 🙂

Re: Create a new variable for rounding

PaigeMiller — Sat, 21 Jul 2018 18:54:43 GMT

Although you can create a new variable that is the rounded value, perhaps you really want a format to show the rounded value rather than a new variable? There's good reasons to do things your way, and there's good reasons to NOT do things your way. It depends.