How would you code a merge that will write the matches of
both to one data set, the non-matches from the left-most
data set to a second data set, and the non-matches of the
right-most data set to a third data set.
Answer Posted / padma
The above proc sql is not working. it is throwing up error.
Please verify. If anybody give proc sql code for the above
question that would be great.
padma
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
I need level 2 to 5 sas using companies in india
where to use sas business intelligence? : Sas-bi
Which statement does not perform automatic conversions in comparisons?
Mention what is PROC in SAS?
how to do user inputs and command line arguments in sas?
what is star schema? : Sas-di
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
what are all the reports you generated in your recent project?
what techniques and/or procs do you use for tables? : Sas programming
What is the difference between match merge and one to one merge?
how does sas handle missing values in a merge? : Sas programming
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
What is the difference between one to one merge and match merge? Give an example.
Name validation tools used in SAS
What is slibref?