get_addr_max_dates: get_addr_max_dates

In iancj88/msuopa: Utility Functions for the MSU OPA Team

Description

select only the most recent address of each type for each pidm. The banner table stores each address every entered into the system as a unique record.

Usage

get_addr_max_dates(pidm_vec, opt_banner_connection)

Arguments

pidm_vec	a vector containing pidms of the people who's addresses will be analyzed
opt_banner_connection	an optional active banner connection object typically derived from the get_banner_conn function. Useful for minimizing the number of times that a password needs to be entered.

Value

return a dataframe containing the 'key' comprised of PIDM Address Type and the corresponding max date all address records of that type and person

iancj88/msuopa documentation built on May 17, 2019, 7:07 p.m.