topic Re: Merging two datasets (including dates) in SAS Programming

Merging two datasets (including dates)

alotaibifm — Mon, 01 Oct 2018 17:01:31 GMT

Hi Everyone,

I am working on a medical records data and I'm getting three separate files (Demographic file, Medication file, Diagnosis file). In each file, there is a specific date for a specific procedure. For instance, in the demographic file has a date for the time the patient visits the Emergency room, and in the diagnosis file there are dates for each diagnosis, and finally, the medication file has dates for each medication.

I want to merge all the three file in ONE dataset based on the date in the demographic file. So, I want to see if there is MATCHED date between the three files and merge them based on that. Is it possible? I have a full format date like this (28MAY2016).

Thanks,

Re: Merging two datasets (including dates)

Kurt_Bremser — Mon, 01 Oct 2018 17:25:50 GMT

You can match on dates. Note that all dates need to be SAS date values (numeric with a date format assigned).

Re: Merging two datasets (including dates)

Astounding — Mon, 01 Oct 2018 17:35:42 GMT

MERGE works as long as you want exact matches only.

If diagnosis date might be the day after the ER date, (or if a medication date might be a few days after the ER date), MERGE would not be the best tool for the job.

Re: Merging two datasets (including dates)

alotaibifm — Mon, 01 Oct 2018 18:33:39 GMT

Sometimes the record shows exact dates and some other observations have one or two days different. Any suggestions?

Re: Merging two datasets (including dates)

ballardw — Mon, 01 Oct 2018 19:56:14 GMT

Can you provide any example data in the form of a data step?

Don't post any sensitive data but the data should be similar to yours, such as replacing patientid information with values like 1111 2222 3333 or such.

Re: Merging two datasets (including dates)

alotaibifm — Mon, 01 Oct 2018 20:18:23 GMT

I have uploaded the sample of the data elements on a PDF. I just created a hypothetical number. I want to merge the demographic file with the medical condition file when (Visit_Date) in the demographic file matching with (BEG_EFFECTIVE_DT_TM) in the medical condition file.

Thanks,