Help using Base SAS procedures

Finding like records in a table

Accepted Solution Solved
Reply
Contributor
Posts: 25
Accepted Solution

Finding like records in a table

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!                        


Accepted Solutions
Solution
‎02-28-2013 10:21 AM
Super User
Posts: 19,861

Re: Finding like records in a table

Posted in reply to That____Redhead

Google: Mayo clinic sas macro matching

They have macros that do propensity score matching.

View solution in original post


All Replies
Trusted Advisor
Posts: 2,116

Re: Finding like records in a table

Posted in reply to That____Redhead

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

Solution
‎02-28-2013 10:21 AM
Super User
Posts: 19,861

Re: Finding like records in a table

Posted in reply to That____Redhead

Google: Mayo clinic sas macro matching

They have macros that do propensity score matching.

Contributor
Posts: 25

Re: Finding like records in a table

Posted in reply to That____Redhead

Thank you both - awesome!

SAS Macros

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 171 views
  • 3 likes
  • 3 in conversation