topic Re: Round by 500 in SAS Programming

Round by 500

Ronein — Wed, 12 Feb 2025 07:01:46 GMT

Hello

I want to round the number by 500 (up or down)

for example

17524.5 will be converted to 18000

25475.37 will be converted to 25000

6475.3 will be converted to 6000

what is the way to do it please?

Re: Round by 500

LinusH — Wed, 12 Feb 2025 07:10:59 GMT

SAS Help Center: ROUND Function

Re: Round by 500

Ksharp — Wed, 12 Feb 2025 07:15:36 GMT

I think it is easy for you .

data have;
input have;
want=1000*round(have/1000);
cards;
17524.5  
25475.37 
6475.3 
;
proc print;run;

Re: Round by 500

Patrick — Wed, 12 Feb 2025 10:06:28 GMT

@Ronein Like below:

/* %let round_to=500; */
%let round_to=1000;

data test;
  do val=1,249.9,250,250.1,499.1,500,500.1,749.9,750,750.1,17524.5,25475.37,6475.3;
    round_val=round(val,&round_to);
    output;
  end;
run;

proc print data=test;
run;

Above updated after @Kurt_Bremser 's remark

Re: Round by 500

Kurt_Bremser — Wed, 12 Feb 2025 09:09:17 GMT

Given your examples, you want to round by 1000, not by 500.

@Ronein wrote:

Hello

I want to round the number by 500 (up or down)

for example

17524.5 will be converted to 18000

25475.37 will be converted to 25000

6475.3 will be converted to 6000

what is the way to do it please?

Re: Round by 500

Tom — Wed, 12 Feb 2025 14:52:05 GMT

Exactly.

data have;
  input x expect;
cards;
17524.5   18000
25475.37  25000
6475.3     6000
;

data want;
  set have;
  round1000=round(x,1000);
  round500=round(x,500);
run;