Computing a variable

[deleted_user]

I have a dataset that contains a character/string variable (var1).

Is there a way to get the counts (in proc freq) to produce another variable in a new dataset?

For example, the original dataset:

var1
a
a
b
c
c
c

proc freq produces output like this:

var1 frequency
a 2
b 1
c 3

I would like to take the frequency and divide it by another number (ie, 10) to get another variable so that my new dataset looks like this:

var1 frequency new_var
a 2 0.2
b 1 0.1
c 3 0.3

Any help would be appreciated!

[P_J]

Please try below;

data a;
input var1 $;
cards;
a
a
b
c
c
c
;
run;

proc sql;
create table b as
select distinct var1, count(var1) as freq, divide(calculated freq,10) as ave
from a
group by var1;
quit;

[deleted_user]

Works wonderfully! Thank you for your help.