topic Re: Computing a variable in SAS Procedures

Computing a variable

deleted_user — Tue, 27 Apr 2010 18:58:57 GMT

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!

Re: Computing a variable

P_J — Tue, 27 Apr 2010 19:12:57 GMT

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;

Re: Computing a variable

deleted_user — Tue, 27 Apr 2010 19:21:38 GMT

Works wonderfully! Thank you for your help.