topic Re: How to required output (multiple of 500)? in SAS Programming

How to required output (multiple of 500)?

allurai0412 — Thu, 27 Dec 2012 04:26:09 GMT

hi ,

i am working with large data base , but i am providing the sample one.

DATA TAXSAVERS;
INPUT AMOUNT LOAD;
DATALINES;
2779 50
16050 50
18000 45
17000 65
2566 20
;
RUN;

I need the REQUITED DATABASE as follows

1) The first step is "load should be deducted " i.e 2779-50=2729

2) The gross or final TAXSAVER amount should be multiple of 500...i.e 2729 ...would be 2500.

shall i use the MOD function for the second step.

please help ....is there any PROC in SAS ...if not go ahead with PROC SQL...

Re: How to required output (multiple of 500)?

RichardinOz — Thu, 27 Dec 2012 05:22:29 GMT

DATA TAXSAVERS;
INPUT AMOUNT LOAD;

nett = sum(amount, -load) ;

taxsaver = round(nett - 250, 500) ;
DATALINES;
2779 50
16050 50
18000 45
17000 65
2566 20
;
RUN;

The sum function will calculate the nett amount and return only the original amount if you have null (missing) values for load.

The round function will calculate to the nearest multiple of, in this case, 500; to get the highest value less than or equal to the given amount take 250 off first.

Richard

Re: How to required output (multiple of 500)?

allurai0412 — Thu, 27 Dec 2012 06:09:13 GMT

thanks richard good work...

is there any way to do in PROC SQL...?

Re: How to required output (multiple of 500)?

Patrick — Thu, 27 Dec 2012 10:58:41 GMT

Something like below?

DATA TAXSAVERS;
INPUT AMOUNT LOAD;
DATALINES;
2779 50
16050 50
18000 45
17000 65
2566 20
;
RUN;

proc sql;
create table want as
select round(amount-load,500) as taxsaver
from taxsavers
;
quit;