Hello,
I have an odd situation I am trying to figure out. I have two tables containing summarized data at a dealer level, treatment versus control.
Let's say I have Dealer_Num, Net_Revenue, and Customer_Count for a time period summarized by dealer. I have 127 dealers in my treatment group and 380 dealers in my control group.
Since not all the Control dealers have similar volume to the Treatment dealers, I want to select those most alike.
I currently have this running in Excel Solver, using SUMPRODUCT and a binary flag to "turn on or off" a dealer, and minimize the difference between the two groups. Is there a way (presumably quicker) to run this in SAS?
Thanks!
Google: Mayo clinic sas macro matching
They have macros that do propensity score matching.
This is a common problem in epidemiology for case-control matching. A typical problem there might be matching by nearest age within 5 years. It is also called proximity matching. A generalization to multiple variables is often done by propensity score matching.
If you search for those terms on sas.com, you will find a number of examples to choose from.
Doc Muhlbaier
Duke
Google: Mayo clinic sas macro matching
They have macros that do propensity score matching.
Thank you both - awesome!
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.