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
Are you involved in writing the inferential analysis plan? Tables specifications?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
how to generate the test data in sas without input data? : Sas-administrator
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
Hi, If anyone has base SAS certification dumps, please share.
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
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
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