topic Re: Finding like records in a table in SAS Procedures

Finding like records in a table

That____Redhead — Thu, 28 Feb 2013 14:13:07 GMT

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!

Re: Finding like records in a table

Doc_Duke — Thu, 28 Feb 2013 14:23:50 GMT

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

Re: Finding like records in a table

Reeza — Thu, 28 Feb 2013 15:21:42 GMT

Google: Mayo clinic sas macro matching

They have macros that do propensity score matching.

Re: Finding like records in a table

That____Redhead — Thu, 28 Feb 2013 16:13:32 GMT

Thank you both - awesome!

SAS Macros