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
- 18855 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
Mention what are the data types does SAS contain?
Given an unsorted data set, how to read the last observation to a new data set?
how to generate the test data in sas without input data? : Sas-administrator
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
Which are the statements whose placement in the data step is critical?
Describe 5 ways to do a “table lookup” in SAS?
What are the five ways to do a table lookup in sas? : sas-grid-administration
What do the put and input function do?
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
Describe the ways in which you can create macro variables? : sas-macro
Do you need to rearrange the order of the data for the report?
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
Define run-group processing?
What is the role of sas grid administrator? : sas-grid-administration
What is a put statement?
