Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 10 Answers
- 18583 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / vipin choudhary
Assume the common variable in both of the old datasets
is "name".
Data One two three;
merge old(in = in1) old1(in = in2);
by name;
if in1 and in2 then output one;
if in1 then output two;
if in1 = 0 and in2 = 1 then output three;
run
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How long can a macro variable be? A token? : sas-macro
for whom is sas data integration studio designed? : Sas-di
How does the internal authentication work in sas? : sas-grid-administration
what is the primary data source for the wrs? : Sas-bi
What is the command used to find missing values?
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
What are the table names in oracle database...?
What is the difference between order and group variable in proc report?
Which date function advances a date, time or datetime value by a given interval?
What are the difference between the sas data step and sas procs?
How we can call macros with in data step? : sas-macro
How is character variable converted into numeric variable and vice versa?
What is a put statement?
Explain how you can debug and test your SAS program?
