Help using Base SAS procedures

Average Cell Frequency Across Multiple Variables

Reply
N/A
Posts: 1

Average Cell Frequency Across Multiple Variables

I am in the process of exploring the number of variables needed for a data linkage.

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.

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?

Thanks!

PROC Star
Posts: 7,487

Average Cell Frequency Across Multiple Variables

Posted in reply to Achambers035

You can use ODS to obtain the crosstabfreqs output table .. which you could then use as the data for doing all of your analyses.  Take a look at: http://www.nesug.org/proceedings/nesug01/cc/cc4025.pdf

It shows how to obtain such tables.  You could simply use proc means or proc univariate to analyze the data in such a table.

Ask a Question
Discussion stats
  • 1 reply
  • 138 views
  • 0 likes
  • 2 in conversation