topic Re: How to pass variable value to round function second argument in SAS Programming

How to pass variable value to round function second argument

raja777pharma — Tue, 06 Sep 2022 13:35:12 GMT

Hi Team,

I would like to check whether possible to pass the variable value as the second argument in round function.

please help me how to pass the VAR2,VAR3 and VAR4 values in round function.

My data;

VAR1 VAR2 VAR3 VAR4

23.453472 0.1 0.01 0.001

My code:

new_var = round(VAR1,VAR2);

new_var1=round(VAR1,VAR3);

new_var2=round(VAR1,VAR4);

Thank you,

Rajasekhar

Re: How to pass variable value to round function second argument

SASJedi — Tue, 06 Sep 2022 13:41:01 GMT

There is nothing wrong with that syntax - it works just fine:

data have;
	input VAR1 VAR2 VAR3 VAR4;
datalines;
23.453472  0.1  0.01 0.001
; 

data want;
	set have;
	new_var = round(VAR1,VAR2);
	new_var1=round(VAR1,VAR3);
	new_var2=round(VAR1,VAR4);
run;

Results:

VAR1	VAR2	VAR3	VAR4	new_var	new_var1	new_var2
23.4535	0.1	0.01	.001	23.5	23.45	23.453

Re: How to pass variable value to round function second argument

sbxkoenk — Tue, 06 Sep 2022 13:44:03 GMT

Hello,

When you wonder if something is possible, just try it out.
In this case : there's no problem whatsoever !

data have;
VAR1=23.453472;
VAR2=0.1;
VAR3=0.01;
VAR4=0.001;
new_var =round(VAR1,VAR2);
new_var1=round(VAR1,VAR3);
new_var2=round(VAR1,VAR4);
run;

Koen

Re: How to pass variable value to round function second argument

ballardw — Tue, 06 Sep 2022 15:06:25 GMT

Depending the values of your second variable you may not immediately recognize that the Round worked as used though. SAS Round function doesn't complain about rounding to the nearest 6.07 for example.