multiply frequency with a constant number

[gtran]

Hello,

I try to multiply frequencies with a constant number but don't know how to do it. I use proc freq as follows:

proc freq data=abc;

table var1*var2/out=xyz;

run;

I want to multiply frequencies in the dummy table with a number to obtain adjusted frequencies. Anyone can tell me how to do it? if proc freq does not work, how Can I do it? It will take much of my time if I have to do it manually as it is repeated procedures.

Thank you very much.

George

[FreelanceReinh · Accepted solution]

Hello @gtran and welcome to the SAS Support Communities!

If that constant number is contained in a variable of the input dataset (abc), you can use the WEIGHT statement to obtain the desired adjusted frequencies. Otherwise, you can add such a weight variable in a preliminary DATA step as shown below (creating a view to avoid redundancy), but for large input datasets it might be more efficient to multiply the frequencies in a subsequent DATA step using the mostly smaller output dataset (xyz) from PROC FREQ.

data _tmp / view=_tmp;
set sashelp.class;
_w=3.14;
run;

proc freq data=_tmp;
tables age*sex / out=want;
weight _w / zeros;
run;

[gtran]

Thank you very much @FreelanceReinh for your prompt help. I tried your second option and it worked. 

Best 

George