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
- 18511 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
Do you need to know if there are any missing values?
explain the key concept of sas? : Sas-administrator
How would you determine the number of missing or nonmissing values in computations?
What is run-group processing?
Explain the special input delimiters used in sas programming.
What are the default statistics for means procedure?
How to create list output for cross-tabulations in proc freq?
how many types of prompts are there? : Sas-bi
for report generation which one you used proc report or data_null_?
Explain by-group processing?
What are symget and symput? : sas-macro
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
How does the internal authentication work in sas? : sas-grid-administration
how to debug and test the sas program? : Sas-administrator
If a variable contains letters or special characters, can it be numeric data type?
