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?
- 2 Answers
- 9809 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sas job searcher
data x1y1
x1y0
x0y1;
/* x1y1, x1y0, x0y1 are output data set names */
merge left_most(in=x) right_most(in=y);
by id;
/* write all matches to x1y1: */
if x=1 and y=1 then output x1y1;
/* non-matches from the left-most data set: */
if x=1 and y=0 then output x1y0;
/* non-matches from the right-most data set: */
if x=0 and y=1 then output x0y1;
run;
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / reddy
data both left_only right_only;
merge dataset1(in=a) dataset2(in=b);
by variable;
if a and b then output both;
if a and not b then output left_only;
if b and not a then output right_only;
run;
i think these is the easy way of writing the code,if any
one nows other please specify.thanks!
| Is This Answer Correct ? | 11 Yes | 4 No |
how to extract data from SAP servers? Is like oracle servers or any other methods to extract please reply me.
why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?
how many display types available in sas bi dashboard? : Sas-bi
How the date 04oct1994 is stored in SAS,not only give the answer explain in brief?
What is the difference between Proc tabulate and Proc print
whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?
What are the difficulties u faced while doing vital signs table or dataset?
What are the data types that sas contain?
How would you combine 3 or more tables with different structures?
Approximately what date is represented by the SAS date value of 730?
What are common programming errors committed in sas
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
Teradata 
