topic Recreate a sum(var)/sum(var) from proc sql into something else in SAS Programming

Recreate a sum(var)/sum(var) from proc sql into something else

MeganE — Fri, 17 Jun 2016 18:26:01 GMT

Hi,

I inherited this code:

            proc sql;
               create table junk.k5_sex_2003 as
               select sex, 2003 as year, (sum(payamt) / sum(yar)) as value
               from junk.py_2003b (where=(mod1 in (1 2 3 4)))
               group by sex.;
           quit;

And i don't think it's working right, so i'd like to recreate it in something else, but i don't know enough about proc means/tabulate/summary to do it.

The only part i want to double check is:

(sum(payamt) / sum(yar)) as value,

by var

What's the best way to do this calculation another way other than proc sql? There are way too many records to do it by hand.

Thanks

Megan

Re: Recreate a sum(var)/sum(var) from proc sql into something else

Reeza — Fri, 17 Jun 2016 18:31:49 GMT

Here's the proc means code, which will create the sum variables and then you'll need to do the division by hand or another data step.

proc means data=junk.py_2003b sum nway;
where mod1 in (1 2 3 4);
class sex;
var payamt yar;
output out=totals sum(payamt yar) = tot_payamt tot_var;
run;

data check_value;
set totals;

value = tot_payamt/tot_var;
run;

Re: Recreate a sum(var)/sum(var) from proc sql into something else

MeganE — Fri, 17 Jun 2016 18:36:04 GMT

Thanks! Gave me the exact same numbers. Guess it was working, lol. 🙂