topic Average Cell Frequency Across Multiple Variables in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Average-Cell-Frequency-Across-Multiple-Variables/m-p/10354#M982 <HTML><HEAD></HEAD><BODY><P>I am in the process of exploring the number of variables needed for a data linkage.</P><P></P><P>Would like to know after stratifying the data, whether there are cells that have frequencies greater than 0 or 1 and the magnitude of these frequencies.</P><P></P><P>What is a quick procedure for calculating 1) the average cell frequency across multiple variables (e.g., Age x Gender x Year of Birth) and the 2) Min and Max Cell count?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 07 Dec 2011 18:46:39 GMT Achambers035 2011-12-07T18:46:39Z Average Cell Frequency Across Multiple Variables https://communities.sas.com/t5/SAS-Procedures/Average-Cell-Frequency-Across-Multiple-Variables/m-p/10354#M982 <HTML><HEAD></HEAD><BODY><P>I am in the process of exploring the number of variables needed for a data linkage.</P><P></P><P>Would like to know after stratifying the data, whether there are cells that have frequencies greater than 0 or 1 and the magnitude of these frequencies.</P><P></P><P>What is a quick procedure for calculating 1) the average cell frequency across multiple variables (e.g., Age x Gender x Year of Birth) and the 2) Min and Max Cell count?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 07 Dec 2011 18:46:39 GMT https://communities.sas.com/t5/SAS-Procedures/Average-Cell-Frequency-Across-Multiple-Variables/m-p/10354#M982 Achambers035 2011-12-07T18:46:39Z Average Cell Frequency Across Multiple Variables https://communities.sas.com/t5/SAS-Procedures/Average-Cell-Frequency-Across-Multiple-Variables/m-p/10355#M983 <HTML><HEAD></HEAD><BODY><P>You can use ODS to obtain the crosstabfreqs output table .. which you could then use as the data for doing all of your analyses.&nbsp; Take a look at: <A href="http://www.nesug.org/proceedings/nesug01/cc/cc4025.pdf">http://www.nesug.org/proceedings/nesug01/cc/cc4025.pdf</A></P><P></P><P>It shows how to obtain such tables.&nbsp; You could simply use proc means or proc univariate to analyze the data in such a table.</P></BODY></HTML> Wed, 07 Dec 2011 20:16:24 GMT https://communities.sas.com/t5/SAS-Procedures/Average-Cell-Frequency-Across-Multiple-Variables/m-p/10355#M983 art297 2011-12-07T20:16:24Z