Key concepts: Date vs Datetime and how to convert between them -> DATEPART() Apply Formats to get desired format -> PUT() Format dates -> MONYY7. Extracting components of a date -> MONTH() /YEAR() functions     The Month() will calculate a month, but all January's will be combined. So January 2016 is the same as January 2015.  The month function returns the month a 1-12 where 1 corresponds to January and 12 to December.    Instead of SQL I recommend a proc means as it will accept formats so you don't have to do too much data conversion.   data have1; set have; date=datepart(datetime); run; proc means data=have N; class date; format date monyy7.; var amount; run;   Or modified SQL if you choose to stick with SQL:   proc sql; select put(datepart(datetime), monyy7.) as Year_Char, Count(*) as count From have where year(datepart(datetime))=2016 group by calculated year_Char; quit; ... View more

You could join on the condition:   translate(code1, "1", "x") = code2 OR translate(code1, "2", "x") = code2     ... View more

Thank you ... View more