This is an R script which will take two sets of HMIS 5.1 CSVs and produce a combined set.
A few notes:
- A new ExportID will need to be provided.
- Each files are deduplicated based upon the Primary Key (ProjectEntryID, PersonalID, etc.)
- The Project.csv contains a PITCount which is different based upon the date ranges the two data sets were pulled. However, the script takes the maximum of the two PITCounts.
- It requires HMIS_Functions and dplyr.
library(dplyr)
# hmisFunctions <- "/Users/user//Dropbox/HMIS/HMIS_R_Functions/HMIS_R_Functions.R"
# dataPathOne <- "/Users/user//Dropbox/HMIS/R HMIS CSV Set Merger/HMIS Data ...