data_check_standard: Check standard data (cust, sale) formatting rules

In southwick-associates/salicprep: Prepare Agency Data

Description

Produces warnings if any checks fail (stays silent on success). This function is simply a wrapper for several calls to data_check_table and data_foreign_key. Rules are designed to ensure:

• primary keys are unique and non-missing

• all required variables are present

• variables only contain prescribed values

• foreign keys are present in relevant primary key table (e.g., all sale$cust_id can be found in cust$cust_id)

Usage

data_check_standard(cust, lic, sale, sale_year1 = 2009)

Arguments

cust	data frame: customer table (primary key = "cust_id")
lic	data frame: license types table (primary key = "lic_id")
sale	data frame: transactions table (foreign keys = "lic_id", "cust_id")
sale_year1	First allowed year for sale dates

See Also

Other functions to check data format: variable_allowed_dates()

southwick-associates/salicprep documentation built on Oct. 6, 2020, 12:03 p.m.