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
- 18507 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / lakshmi
data data1 data2 data3;
merge left(in-a) right(in=b);
by subjid;
if a and b then output data1;
if a and not b then output data2;
if b and not a then output data3;
run;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
how many types of prompts are there? : Sas-bi
how do you pull data from equifax?tell me the process?
Describe the ways in which you can create a macro variable?
what is the effect of the options statement errors=1? : Sas programming
Mention what are the data types does SAS contain?
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
what is the difference between unique key and primary key? : Sas-di
how does sas handle missing values in functions? : Sas programming
Differences between where and if statement?
What sas features do you use to check errors and data validation?
describe how to adjust the performance of data integrator? : Sas-di
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
What is SAS informats?
what are _numeric_ and _character_ and what do they do? : Sas programming
