adspace


What is the difference between one to one merge and match merge? Give an example.

Answer Posted / Subhas Chandra Srivastava

One-to-one merge, also known as a data merge, combines two datasets with identical variables but possibly different observations. The resulting dataset contains all unique combinations of observations from both input datasets.

Match merge uses the BY statement to specify one or more key variables in each dataset and compares them for equality. If there is a match, it merges the corresponding rows from both datasets. If not, it creates either an unmatched observation or skips the observation based on the MERGE option used (F=FILL, U=UPDATE, NEW=CREATE).

Example:

DATA merged;
MERGE dataset1 dataset2 ON key_var;
RUN;

In this example, dataset1 and dataset2 are being merged on a common key variable 'key_var'. This is an example of one-to-one merge.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Are you involved in writing the inferential analysis plan? Tables specifications?

4029


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3676


how to generate the test data in sas without input data? : Sas-administrator

1214


hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2132


Hi, If anyone has base SAS certification dumps, please share.

1951


Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2324


how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2186


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2161