load_license: Load license data (cust, lic, sale) into a list

Description Usage Arguments See Also

View source: R/history.R

Description

All columns for the lic table will be included. Columns to include for sale and cust are specified by arguments. Note that the cust table likely isn't needed for producing a license history, but is included for the call to data_check.

Usage

1
2
3
4
5
6
load_license(
  db_license,
  yrs,
  sale_cols = c("cust_id", "lic_id", "year", "res", "month"),
  cust_cols = c("cust_id", "sex", "birth_year", "county_fips")
)

Arguments

db_license

file path to license.sqlite3

yrs

years to include in license history

sale_cols

character vector of sale column names to include

cust_cols

character vector of cust column names to include

See Also

Other functions for producing license history: data_check_sa(), drop_na_custid(), remove_table(), write_history()


southwick-associates/sadash documentation built on Jan. 6, 2022, 5:17 p.m.