Search bioRxiv⌕ Search
Home/Archive/bioRxiv

bioRxiv · 10.1101/771303

%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

Muthusi, J.·Mwalili, S.·Young, P.
View original source ↗Export metadata ↓

Abstract

IntroductionIn 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.\n\nMethodsWe 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.\n\nResultsWe 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.).\n\nConclusionThe 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.

Explore related subjects

bioinformaticsPreprint

Keep this discovery

Explore connections, maps & timelines

BibTeXRIS

Muthusi, J., Mwalili, S., Young, P.. 2019-09-16. %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. https://doi.org/10.1101/771303

Cite the original work for its findings. Save a collection to share your selection of sources.

KEEP EXPLORING

Related preprints

bioRxiv2026

scRM: A single-cell foundation model trained on scRNA-seq reads

To our knowledge, scRM is the first single-cell foundation model trained on sequencing reads, demonstrating that raw data pretraining is not only feasible but competitive at a fraction of the computational cost. We anticipate that scaling this framework and exploring alternative architectures will unlock biological information inaccessible to count models and extend the dataset-specific pretraining it already makes possible. The source code is available at https://github.com/altos-labs/scRM.

bioinformatics↗
bioRxiv2026

Local fractal dimension as an indicator of functional reorganization in molecular interaction networks

Changes in protein abundance incompletely describe how molecular perturbations reshape cellular organization. Here we introduce DIFFRACT, a framework that integrates quantitative proteomics with protein-protein interaction networks to identify reorganization through changes in local fractal dimension. Molecular associations define effective distances between connected proteins, allowing the geometry of their surrounding network neighborhoods to be compared across conditions. Analyses across four organisms (E. coli, A. thaliana, C. elegans, and H. sapiens) and three interaction resources (STRING, BioGRID, and IntAct) establish heterogeneous local scaling, while controlled perturbations demonstrate sensitivity to regional changes and invariance to uniform distance rescaling. Applied to RAVER1-deficient A549 cells, DIFFRACT identifies components associated with established RNA-regulatory functions and candidate roles in tRNA biology, mitochondrial organization and ciliogenesis. Selected RNA-regulatory and ciliary themes are not significantly enriched by abundance-ranked gene set analysis, supporting complementary information from network geometry. Selected functional annotations also recur in HEK293T cells. Guided by the ciliary predictions, we show that RAVER1 depletion increases the proportion of ciliated A549 cells 2.57-fold and increases cilium length. DIFFRACT thus connects changes in molecular network geometry to experimentally testable biological responses, extending the interpretation of proteomic perturbations beyond differential abundance.

bioinformatics↗
bioRxiv2026

Peripheral Exercise Transcriptomes Do Not Converge on Glutamatergic or Neuroinflammatory Signatures: A Cross-Platform Meta-Analysis

Executive dysfunction following physical overtraining has been linked to glutamatergic dysregulation in the lateral prefrontal cortex (LPFC), but whether this central mechanism is reflected in peripheral gene expression is unknown. This study tested whether peripheral transcriptomic responses to exercise converge on the glutamatergic or neuroinflammatory pathways implicated in LPFC dysfunction. Three publicly available GEO datasets spanning skeletal muscle, whole blood, and circulating neutrophils were analyzed across four exercise groups using limma, with a discovery threshold of nominal p < 0.05 and absolute log2 fold change above 0.5. Differential expression analysis identified 7,311 unique differentially expressed genes (DEGs) across the four contrasts, but overlap between datasets was limited: 7 genes were shared between skeletal muscle and blood, 38 between skeletal muscle and the GSE43856 contrasts, and 90 between blood and the GSE43856 contrasts, with none significant across all three studies. Gene Ontology and KEGG enrichment of the DEG union identified ribonucleoprotein complex biogenesis, ribosome biogenesis, protein folding, and T cell activation as the dominant biological processes; no glutamatergic or neuroinflammatory terms reached significance. Cross-tissue concordance between skeletal muscle and blood was absent (r = 0). Effect sizes among the genes driving the top enriched pathways were dominated by ribosomal proteins, heat shock proteins, and translation initiation factors rather than glutamate receptors or transporters. These findings indicate that peripheral transcriptomic responses to exercise are tissue-specific and dominated by proteostasis, translational, and immune programs rather than glutamatergic signaling. Direct assessment of central nervous system tissue or fluid-based glutamatergic biomarkers may be required to link overtraining-induced fatigue to LPFC dysfunction.

bioinformatics↗