Date: Sun, 19 Jul 2009 13:15:18 -0500
Reply-To: Joe Matise <snoopy369@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Joe Matise <snoopy369@GMAIL.COM>
Subject: Re: PROC SUMMARY
Content-Type: text/plain; charset=ISO-8859-1
Sounds like a CLASS situation to me...
proc means data=have;
class a b c d;
types a b c d;
output out=want mean=;
or whatever. If you just want the A=1 etc. (not 0) then put a where
condition on your output dataset to require A or B or C or D to be 1.
On Sun, Jul 19, 2009 at 12:50 PM, OR Stats <firstname.lastname@example.org> wrote:
> I would like to do a PROC SUMMARY for the means and size of the group
> membership of my data. The problem is that each record can belong to more
> than one group. And I would like to calculate the summary statistics for
> the groups in a non-exclusive way.
> Group membership is currently captured across binary columns of my data.
> record_id A B C D y
> 1 1 0 0 0 #
> 2 0 1 0 0 #
> 3 1 1 1 1 #
> Group is therefore A, B, C, or D. In the output summary table, I would
> summarized y by groups A, B, C, and D.And I would like to get the summary
> statistic for y by Group, where A includes records 1, 2 and 3; B is just 2
> and 3; C is just record 3; and D is also just record 3.
> Can I do this in one PROC SUMMARY datastep? Or do I need an intermittent
> dataset to reorganize my table above?
> Thank you!!