Hi there,
I am a junior sas user and I would like your help to crack some code! I have a dataset of antibiotic use by patients <pt_id> over time in a long data format. The antibiotics (<treatment>) have start and end dates (table “have”).
Table have
pt_id
start_date
end_date
treatment
1
01JAN2019
15MAR2019
cipro,flagy,amoxicillin
1
16MAR2019
15APRIL2019
cipro,flagy,amoxicillin,midazolam
1
17DEC2019
18DEC2019
cipro,flagy,amoxicillin,penicillin
1
22FEB2020
26FEB2020
cipro,flagy,
2
01JAN2018
15MAR2018
cipro,amoxicillin
2
16MAR2018
15APR2018
flagy,amoxicillin
2
17DEC2018
18DEC2018
cipro,flagy,amoxicillin,pethidine
2
22FEB2019
26FEB2019
cipro,flagy,amoxicillin,clopidogrel
2
23JUL2020
29JUL2020
cipro,flagy,amoxicillin,warfarin
2
01SEPT2021
05SEPT2021
cipro,flagy,amoxicillin,tazo
2
06SEPT2021
16SEPT2021
cipro,flagy,amoxicillin,piperacin
3
05DEC2019
18DEC2019
cipro,flagy,amoxicillin
3
22FEB2021
26FEB2021
cipro,flagy,amoxicillin
3
01JAN2022
15MAR2022
cipro,flagy,amoxicillin
I would like to determine if a participant received a specific antibiotic (in this case Flagyl and amoxicillin within six months prior to the start of a given treatment (so the prior end date for that antibiotic falls within six months from the start of a new treatment combination). So, table “want” creates new variables, <expo_flagyl_6m> and <expo_amoxacillin_6m> for prior exposure to flagyl and amoxicillin, respectively, within six months
Data want
pt_id
start_date
end_date
treatment
Expo_flagyl_6m
Expo_amoxacillin_6m
1
01JAN2019
15MAR2019
cipro,flagy,amoxicillin
0
0
1
16MAR2019
15APRIL2019
cipro,flagy,amoxicillin,midazolam
1
1
1
17DEC2019
18DEC2019
cipro,flagy,amoxicillin,penicillin
0
0
1
22FEB2020
26FEB2020
cipro,flagy,
1
1
2
01JAN2018
15MAR2018
cipro,amoxicillin
0
0
2
16MAR2018
15APR2018
flagy,amoxicillin
0
1
2
17DEC2018
18DEC2018
cipro,flagy,amoxicillin,pethidine
0
0
2
22FEB2019
26FEB2019
cipro,flagy,amoxicillin,clopidogrel
1
1
2
23JUL2020
29JUL2020
cipro,flagy,amoxicillin,warfarin
0
0
2
01SEPT2021
05SEPT2021
cipro,flagy,amoxicillin,tazo
0
0
2
06SEPT2021
16SEPT2021
cipro,flagy,amoxicillin,piperacin
1
1
3
05DEC2019
18DEC2019
cipro,flagy,amoxicillin
0
0
3
22FEB2021
26FEB2021
cipro,flagy,amoxicillin
0
0
3
01JAN2022
15MAR2022
cipro,flagy,amoxicillin
0
0
Is it possible to suggest a macro so that I can run other columns for exposure to other antibiotics? Thank you so much for your help.
Dathan Byonanebye
... View more