LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2011, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 31 Oct 2011 18:26:33 -0700
Reply-To:     oslo <oslo@yahoo.com>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         oslo <hokut1@YAHOO.COM>
Subject:      Re: commen frequency
Comments: To: Joe Matise <snoopy369@GMAIL.COM>
In-Reply-To:  <CAM+YpE9asT4mzZiGpom9r8tQNnhQ-bhBT1vfPN3Y-7-PsfODeQ@mail.gmail.com>
Content-Type: text/plain; charset=iso-8859-1

Dear Joe;   Thanks a lot. It is much appreciated,   Oslo ________________________________ From: Joe Matise <snoopy369@GMAIL.COM> To: SAS-L@LISTSERV.UGA.EDU Sent: Monday, October 31, 2011 6:37 PM Subject: Re: commen frequency SQL would do this nicely: proc sql; select sum(case when varA=varB then 1 else 0 end) as varAvarB, sum(case when varB=varC then 1 else 0 end) as varBvarC, sum(case when varC=varD then 1 else 0 end) as varCvarD, sum(case when varA=varB and varB=varC then 1 else 0 end) as varAvarBvarC ... from have [group by things if you need to]; quit; If you want to do this programmatically you can from dictionary.columns. -Joe On Sun, Oct 30, 2011 at 11:00 PM, 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


Back to: Top of message | Previous page | Main SAS-L page