scholarly journals %svy_freqs: A generic SAS macro for cross-tabulation between a factor and a by-group variable given a third variable and creating publication-quality tables using data from complex surveys

2019 ◽  
Author(s):  
Jacques Muthusi ◽  
Samuel Mwalili ◽  
Peter Young

AbstractIntroductionIn epidemiological studies, cross-tabulations are a simple but important tool for understanding the distribution of socio-demographic characteristics among study participants. They become more useful when comparisons are presented using a by-group variable such as key demographic characteristic or an outcome status; for instance, sex or the presence or absence of a disease status. Most available statistical analysis software can easily perform cross-tabulations, however, output from these must be processed further to make it readily available for review and use in a publication. In addition, performing three-way cross-tabulations of complex survey data such as those required to show the distribution of disease prevalence across multiple factors and a by-group variable is not easily implemented directly using available standard procedures of commonly used statistical software.MethodsWe developed a generic SAS macro, %svy_freqs, to create quality publication-ready tables from cross-tabulations between a factor and a by-group variable given a third variable using survey or non-survey data. The SAS macro also performs classical two-way cross-tabulations and refines output into publication-quality tables. It 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 character variable values into numeric ones and allowing for generalizability.ResultsWe demonstrate the application of the SAS macro in the analysis of data from 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 (U.S.).ConclusionThe SAS code use to develop the macro is simple yet comprehensive, easy to follow, straightforward for the end user and simple for a SAS programmer to extend. The SAS macro has shown to shorten turn-around time for statistical analysis, eliminate errors when preparing output, and support reproducible research.

2019 ◽  
Author(s):  
Jacques Muthusi ◽  
Samuel Mwalili ◽  
Peter Young

AbstractIntroductionReproducible research is increasingly gaining interest in the research community. Automating the production of research manuscript tables from statistical software can help increase the reproducibility of findings. Logistic regression is used in studying disease prevalence and associated factors in epidemiological studies and can be easily performed using widely available software including SAS, SUDAAN, Stata or R. However, output from these software must be processed further to make it readily presentable. There exists a number of procedures developed to organize regression output, though many of them suffer limitations of flexibility, complexity, lack of validation checks for input parameters, as well as inability to incorporate survey design.MethodsWe developed a SAS macro, %svy_logistic_regression, for fitting simple and multiple logistic regression models. The macro also creates quality publication-ready tables using survey or non-survey data which aims to increase transparency of data analyses. It further significantly reduces turn-around time for conducting analysis and preparing output tables while also addressing the limitations of existing procedures.ResultsWe demonstrate the use of the macro in the analysis of 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. The output presented here is directly from the macro and is consistent with how regression results are often presented in the epidemiological and biomedical literature, with unadjusted and adjusted model results presented side by side.ConclusionsThe SAS code presented in this macro is comprehensive, easy to follow, manipulate and to extend to other areas of interest. It can also be incorporated quickly by the statistician for immediate use. It is an especially valuable tool for generating quality, easy to review tables which can be incorporated directly in a publication.


1990 ◽  
Vol 4 (4) ◽  
pp. 41-54 ◽  
Author(s):  
Edward G. Thomas ◽  
S.R. Rao ◽  
Rajshekhar G. Javalgi

Considers the proliferation of products and services in the financial services industry aimed at different market segments. Highlights the affluent and nonaffluent market segments. Employs statistical analysis of survey data to evaluate the financial services needs, attitudes, and information‐seeking behaviour of these segments. Suggests implications for the managers of financial institutions, based on the study findings. Includes appendices on methodology and discriminant analysis used in the study.


2014 ◽  
Vol 1 (1) ◽  
pp. 99-123 ◽  
Author(s):  
Mayumi Nakamura

AbstractIn many countries, the size of a law firm is closely related to the specializations and incomes of the lawyers it employs, and can be considered an index for disparities among lawyers. Gender and school prestige may affect the size of the first firm that lawyers join. Moreover, since the lawyer population has quadrupled over the last 20 years in Japan, mainly due to judicial reform, I hypothesize that this population increase has changed how gender and school prestige affect the size of the first firm law school graduates decide to join. To test this, I conducted a secondary statistical analysis on the effect of gender and school prestige on the size of the first firm that lawyers joined, using survey data collected by the Japan Federation of Bar Associations in 2010. Findings suggest that there were no significant differences in the size of women’s and men’s first employer, but that school prestige was significant. Moreover, the importance of school prestige has increased over the years.


Sign in / Sign up

Export Citation Format

Share Document