what is syntax of proc merge ?

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


Please Help Members By Posting Answers For Below Questions

How long can a macro variable be? A token? : sas-macro

931


do you need to know if there are any missing values? : Sas programming

764


what is sas and what are the functions? : Sas-administrator

742


how does sas handle missing values in functions? : Sas programming

828


How do you delete duplicate observations in sas?

803


what is the Population you used in your project, is it ITT or PP?

2459


Explain the difference between nodup and nodupkey options?

792


What is SAS? What are the functions does it performs?

945


which date functions advances a date time or date/time value by a given interval? : Sas programming

733


How would you define the end of a macro?

879


Give e an example of..

1834


What areas of SAS are you most interested in?

1259


Give e an example of..

2106


What would be the value of month at the end of data step execution and how many observations would be there?

792


This entry was posted in General. Bookmark the permalink. Post a comment or leave

4330