topic Re: Calculating Frequencies in SAS Programming

Calculating Frequencies

axeloop — Sun, 23 Dec 2018 05:40:00 GMT

Hi all,

I'm a SAS newbie! I have a very large dataset and it looks similar to this:

var1 var2 var3 var4 var5

10384 35 1 5 1

10383 56 2 3 2

10567 76 1 4 5

Var5 indicates the number of rows with the same information so it really is this:

var1 var2 var3 var4

10384 35 1 5

10383 56 2 3

10567 76 1 4

How do I find the frequency for var1, var2, var3, and var4 without expanding the dataset?

Re: Calculating Frequencies

novinosrin — Sun, 23 Dec 2018 07:07:39 GMT

A simple transpose gives

proc transpose data=have out=w;
by var5;
var var1-var4;
run;

proc print noobs;run;

gives

1 var1 10384
1 var2 35
1 var3 1
1 var4 5
2 var1 10383
2 var2 56
2 var3 2
2 var4 3
5 var1 10567
5 var2 76
5 var3 1
5 var4 4

I'm not clear with your expected output yet. Do you want the frequencies of each value of var1 -- var4 or number of records in var1,var2 and var4?

If I were to assume it is frequencies of each value of var1-var4,


proc sql;
create table want as
select col1, sum(var5) as freq
from w
group by col1;
quit;

gives

COL1 freq

1 6
2 2
3 2
4 5
5 1
35 1
56 2
76 5
10383 2
10384 1
10567 5

Re: Calculating Frequencies

Ksharp — Sun, 23 Dec 2018 09:28:36 GMT

data have;
input var1       var2         var3          var4        var5  ;
cards;
10384     35            1                5            1
10383     56            2                3            2
10567     76            1                4            5
;
run;
proc freq data=have noprint;
table var1/out=want1 ;
table var2/out=want2 ;
weight var5;
run;

Re: Calculating Frequencies

VDD — Sun, 23 Dec 2018 14:07:37 GMT

data have;
infile cards missover;
input var1       var2         var3          var4;
cards;               
10384     35            1                5            
10383     56            2                3           
10383     56            2                3            
10567     76            1                4            
10567     76            1                4            
10567     76            1                4            
10567     76            1                4            
10567     76            1                4   
run;
proc freq data=have;
	tables var1 var2 var3 var4 / out=want;
run;
proc freq data=have;
	tables var1*var2 /out=want2;
run;

Depends on what you really want

Re: Calculating Frequencies

axeloop — Sun, 23 Dec 2018 17:48:56 GMT

I see that I needed to use "weight". It worked perfectly! Thanks.