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
- 18522 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / m.sivakumar
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 coalesce(one.id,two.id)as
id,name,age,sex from one right join two on one.id=two.id
where one.id is null;
quit;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you execute a macro within a macro? Describe. : sas-macro
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
what are all the reports you generated in your recent project?
what is function of retain statment
how do you pull data from equifax?tell me the process?
how will you location sas platform applications available from web browser? : Sas-bi
why a stop statement is needed for the point= option on a set statement?
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
What is the maximum length of the macro variable? : sas-macro
Have you used macros? For what purpose you have used? : sas-macro
describe about physical data integration? : Sas-di
what is ae onset date n what is RDS
What would be the value of month at the end of data step execution and how many observations would be there?
for report generation which one you used proc report or data_null_?
Describe a time when you were really stuck on a problem and how you solved it?
