proc sql; select * from may_nomatch_2 a inner join march2018_3_9char b on a.Loan_9 = b.LOAN and a.PropZIP = b.Property_Zip; quit; data; merge may_nomatch_2(rename=(Loan_9=LOAN PropZIP=Property_Zip)) march2018_3_9char; by Loan_9 PropZIP; run; I have above code. proc sql shows how I would do the join using sql. But I want to perform the join using merge and not sure how to do it   it is an inner join using 2 columns those 2 columns don't have same name in both tables ... View more

i have proc means procedure as below. I want to modify it to show count of 0 values for each column.    or   is there any other proc that i could use that will provide me below for selected numeric columns in my dataset? MEAN STD MIN MAX N NMISS 0count       data work.staff; infile datalines dlm='#'; input Name & $16. IdNumber $ Salary Site $ HireDate date7.; format hiredate date7.; datalines; Capalleti, Jimmy# 2355# 21163# BR1# 30JAN09 Chen, Len# 5889# 20976# BR1# 18JUN06 Davis, Brad# 3878# 19571# BR2# 20MAR84 Leung, Brenda# 4409# 34321# BR2# 18SEP94 Martinez, Maria# 3985# 0# US2# 10JAN93 Orfali, Philip# 0740# 50092# US2# 16FEB03 Patel, Mary# 2398# 35182# BR3# 02FEB90 Smith, Robert# 5162# 40100# BR5# 15APR66 Sorrell, Joseph# 4421# 38760# US1# 19JUN11 Zook, Carla# 7385# 22988# BR3# 18DEC10 run; PROC MEANS DATA=WORK.staff FW=12 PRINTALLTYPES CHARTYPE VARDEF=DF MEAN STD MIN MAX N NMISS ; VAR Salary HireDate; RUN;     ... View more