Date:         Mon, 16 Jun 2003 16:58:51 -0400
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: how calculate freq code in table
Comments: cc: fernd alois <ferndalois@HOTMAIL.COM>
Content-Type: text/plain

> From: fernd alois [mailto:ferndalois@HOTMAIL.COM]
> I have a   table with    3  var      :     id-person
> code-used  count
> How can I calculate the  ratio for each combination of codes
> by person
>
> I tried this  but  need I some  transpose   first ?
>
> proc feq data=dset;
> by person ;

> tables code * code;

too many vars:
tables code;

> weight count ;
> run ;

to get the combination of codes, per person
you will have to restructure your data

Date:         Thu, 5 Jun 2003 16:47:48 -0400
Subject:      Re: SQL problem -- alphabetical concatenation across rows
http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0306A&L=sas-l&P=R24376&m=127617

you may find the following papers handy in understanding
the complexity of your task:

SUGI 22: 1997 San Diego CA
Coder's Corner  80 %ARRAY
%ARRAY: construction and usage of arrays of macro variables
http://www2.sas.com/proceedings/sugi22/CODERS/PAPER80.PDF

Posters        204 %SHOWCOMB
%SHOWCOMB: a macro to produce a data set with frequency of
combinations of responses from multiple-response data
http://www2.sas.com/proceedings/sugi22/POSTERS/PAPER204.PDF

Posters        236 %CHECKALL
%CHECKALL: a macro to produce a frequency of response data
set from multiple-response data
http://www2.sas.com/proceedings/sugi22/POSTERS/PAPER236.PDF

Ron Fehd  the macro maven  CDC Atlanta GA USA RJF2@cdc.gov