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?
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;
Would help if you provide example have and want datasets in the form of data step code.
Art, CEO, AnalystFinder.com
I will appreciate the dataset code,
Thanks.
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;
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.
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.