Date: Thu, 13 Feb 2003 09:18:14 -0500
Reply-To: "Fehd, Ronald J. (PHPPO)" <rjf2@CDC.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Fehd, Ronald J. (PHPPO)" <rjf2@CDC.GOV>
Subject: Re: Handling Multiple responses to Calculate Frequency
> From: MK [mailto:myquery5@YAHOO.COM]
> This is related to Calculating Frequency in SAS.
> I have 3 columns where the answers for ONE particular
> question is given and I need the frequencies of values in ALL
> 3 COLUMNS taken together, what is the procedure in SAS? In
> SPSS, we typically define a multiple response set and obtain
> frequencies from this set.
> For example
> if Column1 is quantity of merchandise bought in June,
> column 2 is quantity bought in July and
> column 3 is quantity bought in August,
> I need the frequencies of the quantities taking all the three
> columns together, how do I do it.
> One option is to create three different data sets for three
> different columns and then append these data sets one after
> another to get one single column of all these values and then
> use PROC FREQ.
> Is there any other efficient and simpler way to get the
> desired result?
This wheel has been invented in SAS.
for latest versions of the macros
send e-mail with
subject: request ARRAY, SHOWCOMB, CHECKALL
I usually wait until the next afternoon to send the reply.
SUGI 22: 1997 San Diego CA
Coder's Corner 80 %ARRAY
%ARRAY: construction and usage of arrays of macro variables
Posters 204 %SHOWCOMB
%SHOWCOMB: a macro to produce a data set with frequency of
combinations of responses from multiple-response data
Posters 236 %CHECKALL
%CHECKALL: a macro to produce a frequency of response data
set from multiple-response data
Ron Fehd the macro maven CDC Atlanta GA USA RJF2@cdc.gov