SAS matching

[Oluwole]

I recreated a one to one match using the PROC SURVEYSELECT. I have the final match dataset with only 4 variables inclduing matchID in the dataset.

How do I relate this to the original dataset from where the cases and control were selected so I can work on the matched data?

[art297]

Would help if you provide example have and want datasets in the form of data step code.

Art, CEO, AnalystFinder.com

[Oluwole]

I will appreciate the dataset code,

Thanks.

[Reeza · Accepted solution]

You need to merge/join the two datasets in to the SurveySelect output. 

You'll need to rename the variables so you can identify the match/control records. This assumes you have different datasets with your control and match data. 

Proc sql;

Create table matched as 

Select a.* /*first set of records Control dataset*/
B.id as match_id, b.name as match_name, .... etc, /* Match dataset, rename variables because variables cannot have the same name*/
Ss.index /*Include the variable index from the SurveySelect data*/

From SurveySelect as ss /*Match/Control dataset shown*/

Left join control as a /*Get information from control dataset, match on ID*/
On ss.control_id = a.id

Left join match as b  /*Merge information from the match dataset, match on ID*/
On ss.match_id = b.id;

Quit;

[ballardw]

For future use you can use the option OUTALL on the Proc Surveyselect statement. This will add a variable SELECTED to the output set that will have a 1 for the selected records and 0 for the non-selected.