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
how does sas handle missing values in sort order? : Sas programming
which date functions advances a date time or date/time value by a given interval? : Sas programming
What is the difference between proportion and average?
What does PROC print, and PROC contents do?
what is the effect of the options statement errors=1? : Sas programming
How does the internal authentication work in sas? : sas-grid-administration
Enlist the functions performed by sas.
what is the basic structure sas administrator? : Sas-administrator
How would you identify a macro variable? : sas-macro
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
What are the automatic variables for macro? : sas-macro
Explain the main difference between the sas procedures and functions? : Sas-administrator
how do you debug and test your sas programs? : Sas programming
what is hierarchy flattening? : Sas-di
Explain by-group processing?