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
- 18518 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / vinod swarna
proc sql;
create table both_match as
select *
from one
intersect
select *
from two;
create table left_non as
select *
from one
except
select *
from two;
create table right_non as
select *
from two
except
select *
from one;
quit;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how do you test for missing values? : Sas programming
What is SAS?
What do the put and input function do?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
what do the pad and dim functions do? : Sas programming
I need level 2 to 5 sas using companies in india
Difference between nodup and nodupkey options?
what is the difference between infile and input? : Sas-administrator
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
Describe the ways in which you can create macro variables?
How would you identify a macro variable?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
What are the applications primarily used by business analyst? : Sas-bi
what can you learn from the sas log when debugging? : Sas programming
What are the features of SAS?
