Open Access<i>%svy_freqs</i>: A Generic SAS Macro for Creating Publication-Quality Three-Way Cross-Tabulations
Author(s) -
Jacques Muthusi,
Peter W. Young,
Samuel Mwalili
Publication year - 2021
Publication title -
journal of open research software
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.385
H-Index - 6
ISSN - 2049-9647
DOI - 10.5334/jors.318
Subject(s) - generalizability theory , disk formatting , macro , computer science , variance (accounting) , national health and nutrition examination survey , variable (mathematics) , statistics , replication (statistics) , econometrics , data mining , mathematics , medicine , environmental health , mathematical analysis , population , accounting , business , programming language , operating system
Cross-tabulations are a simple but important tool for understanding the distribution of socio-demographic characteristics among participants in epidemiological studies. We developed a generic SAS macro, %svy_freqs, to create publication-quality tables from cross-tabulations between a factor and a by-group variable given a third variable using survey or non-survey data. The macro also performs two-way cross-tabulations and provides extra features not available in existing procedures such as ability to incorporate parameters for survey design and replication-based variance estimation methods, performing validation checks for input parameters, transparently formatting variable values from character into numeric and allowing for generalizability. We demonstrate the macro using the 2013-2014 National Health and Nutrition Examination Survey (NHANES), a complex survey designed to assess the health and nutritional status of adults and children in the United States.