I have a table of appointments (including appointment date) and a table of diagnoses(including diagnosis date)
Is it possible in load script to flag the answer to the question "Did you have xx Diagnosis within xx Months of your appointment?" for every appointment - without Cartesian joining the data together and subtracting dates?
You can add the end date of the time periods to your appointment table (read the table in, for each appointment record, add xx months to the appointment date creating a new field).
Then use intervalmatch (the extended version to use patient ID as additional key) to map your diagnosis to the created intervals.
