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
- 18584 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
what is study design in while working with SAS? what are screening variables in SAS?
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
What is your favorite all time computer book? Why?
What is the difference between match merge and one to one merge?
Name and describe few sas character functions that are used for data cleaning in brief.
How we can create SAS USER DEFINED CODE?
Why double trailing @@ is used in input statement?
How do you connect the desktop application to metadata server? : sas-grid-administration
What are all the problems you faced while validating tables and reports?
What are the implications?
How do dates work in SAS data?
what is sas business intelligence? : Sas-bi
What are types of transport files?
For what purposes have you used sas macros? : sas-macro
