helper: Broad use helper functions

In PHSKC-APDE/Medicaid: Query and analyze WA State Medicaid, Medicare, and APCD data

Broad use helper functions

Description

Various functions used to support processing and analysis of Medicaid claims data.

list_var accepts a list of unquoted variable names and returns a list of quosures for passing to any function.

sqlbatch_f prepares and sends batched SQL statements to SQL Server with the final statement returning a result set.

Usage

list_var(...)

sqlbatch_f(server, sqlbatch)

suppress_f(df, suppress_var, lower = 1, upper = 10, col_wise = TRUE)

Arguments

...	Variables that will be passed as a list to another function
server	SQL server connection created using odbc package
sqlbatch	Any number of SQL queries in list format
df	Data frame on which to perform small number suppression
suppress_var	Specifies which variables to base suppression on
lower	Lower cell count for suppression (inclusive), defaults to 1
upper	Upper cell count for suppression (inclusive), defaults to 10

PHSKC-APDE/Medicaid documentation built on May 14, 2024, 2:14 p.m.