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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.