Hi,
I have a dataset with cases and potential controls. I would like to select controls by matching age, race, sex and birth weight in 1:10. I used to select controls by creating index, for example, concatenate age|race|sex , and then use proc surveyselect. However, this method cannot satisfy my need since I need to matching birth weight in certain range, such as +/- 50 g. How can I select controls by matching exact variables and variables in a range? Thanks.
please show some input and output data, so that someone cal help you
Try a Google search for
SAS marching macro
There are a number of macros out there that will do tolerance matching on continuous variables.
Alternatively, you might consider propensity score matching. That often performs better than the simple case-control approach you posited.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.