Date:         Mon, 31 Oct 2011 08:50:55 -0400
Reply-To:     Tom Abernathy <tom.abernathy@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Tom Abernathy <tom.abernathy@GMAIL.COM>
Subject:      Re: commen frequency
Content-Type: text/plain; charset=ISO-8859-1

What do you mean?
Do you want to take the frequency of value rsXXXXX in column A and add the
number of times that same gene appeared in column B?

proc freq data=have;
  tables a / noprint out=a(rename=(a=gene count=a));
  tables b / noprint out=b(rename=(b=gene count=b));
  tables c / noprint out=c(rename=(c=gene count=c));
  tables d / noprint out=d(rename=(d=gene count=d));
run;
data want ;
  merge a b c d ;
  by gene;
  ab=sum(a,b);
  ac=sum(a,c);
  ....
run;

Or do you want to count the number of rows where A=B?
data temp;
  set have;
  ab=a=b;
  ac=a=c;
  ...;
run;
proc means data=temp;
  var ab ac ... ;
  output out=want sum=;
run;


On Sun, 30 Oct 2011 21:00:08 -0700, oslo <hokut1@YAHOO.COM> wrote:

>Dear SAS-L Users;
�
I have a data set with 4 columns given as follows. I need get the commen
frequency of variable in the columns. That is I need get
a) Frequency of the same variables in A-B columns
b) Frequency of the same variables in A-C columns
c) Frequency of the same variables in A-D columns
d) Frequency of the same variables in B-C columns
.
.
Then frequency of the same variables in A-B-C columns
�Frequency of the same variables in A-B-D
.
.
At the end the frequency of the same variables in A-B-C-D
�
Best regards,
Oslo
�
�

A  B  C  D
rs29024430   �rs43708440  rs29024430  �r29024430
rs29009912  �rs29009907  rs43708440  �rs43708440
rs29009979  �rs29009912  rs29009907  �rs29010802
rs29010147  �rs29012086  rs29009912  �rs17871338
rs29010295  �rs29012174  rs29009979  �rs29009907
rs29010510  �rs29013844  rs29010295  �rs29009912
rs29011155  �rs29016146  rs29010461  �rs29009979
rs29012070  �rs29017980  rs29011155  �rs29010295
rs29012174  �rs29018185  rs29012070  �rs29010461