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
- 18863 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / proc sql
proc sql:
proc sql;
create table sqln1 as select one.id,name,age,sex from one
inner join two on one.id=two.id;
create table sqln2 as select one.id,name,age,sex from one
left join two on one.id=two.id where two.id is null;
create table sqln3 as select two.id,name,age,sex from one
right join two on one.id=two.id where one.id is null;
quit;
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
how do you test for missing values? : Sas programming
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
Describe the function and untility of the most difficult SAS macro that you have written.
what is sas data set?
Explain the use of proc gplot? : sas-grid-administration
What is by-group processing?
do you need to know if there are any missing values? : Sas programming
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
what r the job openings SAS for fresher graduates !
How do you connect the desktop application to metadata server? : sas-grid-administration
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
what has been your most common programming mistake? : Sas programming
what is null hypothesis? why do you consider that?
What does the trace option do?
what are the scrubbing procedures in sas? : Sas programming
