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
- 18142 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 techniques and/or procs do you use for tables? : Sas programming
How we can call macros with in data step? : sas-macro
What system options would you use to help debug a macro? : sas-macro
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
How to test the debugging in sas?
how does sas handle missing values in formats? : Sas programming
How do you debug and test your SAS programs?
Are you involved in writing the inferential analysis plan? Tables specfications?
How substr function works in sas?
describe the interaction table in sas di? : Sas-di
What is maximum storage capability of SAS?
what do you mean by data staging area? : Sas-di
Give an example where SAS fails to convert character value to numeric value automatically?
Explain the special input delimiters used in sas programming.
What is maximum number of rows and cols can be handled in SAS?
