topic Re: SAS matching in SAS Programming

SAS matching

Oluwole — Sat, 01 Apr 2017 16:44:53 GMT

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?

Re: SAS matching

art297 — Sat, 01 Apr 2017 16:48:38 GMT

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

Art, CEO, AnalystFinder.com

Re: SAS matching

Oluwole — Sun, 02 Apr 2017 15:45:18 GMT

Re: SAS matching

Oluwole — Sat, 01 Apr 2017 17:31:37 GMT

I will appreciate the dataset code,

Thanks.

Re: SAS matching

Reeza — Sun, 02 Apr 2017 19:30:06 GMT

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;

Re: SAS matching

ballardw — Mon, 03 Apr 2017 15:41:22 GMT

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.