Hello,
I’m trying to match my ‘treatment’ dataset with two control datasets – control1 and control2. Here are the rules:
In the attachment, I’ve some sample data along with my expected result. I highly appreciate your cooperation.
Hi LinusH,
This is the part I've been struggling with. I do know how to match one treatment with one control but couldn't help myself with this problem - one treatment with two controls, where controls come from two different datasets. I hope someone here could help me out. SIC's and fyears are not necessarily required for the solution, which I think mitigates your concern about business related application.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.