Answer Posted / neel
proc sort data=ds1;
by var1;
proc sort data=ds2;
by var1;
run;
*from both datasets only matching data;
data match_merge;
merge ds1(in=a) ds2(in=b);
by var1;
if a and b;
run;
| Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
What is the difference between input and infile statement?
Which date function advances a date, time or datetime value by a given interval?
I have a dataset concat having variable a b & c. How to rename a b to e & f?
how to generate the test data in sas without input data? : Sas-administrator
Which function is used to count the number of intervals between two sas dates?
Mention what is PROC in SAS?
What is the good sas programming practices for processing large data sets?
What are the new features included in the new version of SAS Programming Language?
why is a stop statement needed for the point=option on a set statement? : Sas programming
Explain the difference between using drop = data set option in set and data statement?
what is the use of proc contents and proc print in sas? : Sas-administrator
What is the use of %include statement?
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?
What are the features of SAS?
which date functions advances a date time or date/time value by a given interval? : Sas programming