Package: dmhct 1.0.0

dmhct: A Data Model Package for the MLinHCT Project

Extracts, Loads, and Transforms data from the SQL Server containing HCT data to a `dm` object with cleaned tables.

Authors:Jesse Smith [aut, cre]

# Install 'dmhct' in R:

install.packages('dmhct', repos = c('https://jesse-smith.r-universe.dev', 'https://cloud.r-project.org'))

On CRAN:

Last updated 6 months agofrom:e024cd9021. Checks:OK: 1 NOTE: 6. Indexed: yes.

Help page	Topics
Connect to SQL Server Where IRB_MLinHCT Data is Stored	con_irb_mlinhct
Connect to SQL Server Where Data is Stored	con_sql_server
Connect to SQL Server Where EDW Data is Stored	con_stjude_edw
Collect All Tables in a 'dm' Object	dm_collect
Combine Table with Like Information	dm_combine
Compute All Tables in a 'dm' Object	dm_compute
Disconnect a 'dm' Object from the Remote Server	dm_disconnect
Extract, Load, and Transform Remote Tables to Local Source	dm_elt
Extract Remote Tables from SQL Server for MLinHCT	dm_extract
Select and Convert Table + Columns From Remote Source	dm_extract_legacy
Extract, Standardize, and Combine Tables from the MLinHCT Database	dm_hct
Check Whether a 'dm' Object is Connected to a Remote Server	dm_is_remote
Pivot Tables in Entity-Attribute-Value Format	dm_pivot
Create a 'dm' Object of HCT Data from Connection to SQL Server	dm_sql_server
Standardize Column Values in a local 'dm' for MLinHCT	dm_standardize
Transform Tables to Analysis-Friendly Format	dm_transform
Convert Standardized Intervals to Matrix Format	intvl_to_matrix
Common Patterns Representing Missing Data	na_patterns
Extract Values That Cannot Be Converted to 'numeric'	non_numeric
Standardize 'character' Vectors	std_chr
Parse Dates to Standard Format	std_date
Standardize Interval Representations	std_intvl
Standardize 'logical' Representations in Various Formats	std_lgl
Convert and Standardize Numeric Values in Various Forms	std_num