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

Here are some examples that should help. (ANYDTDTM)   http://support.sas.com/documentation/cdl/en/leforinforref/63324/HTML/default/viewer.htm#p1hsn1ji141r4zn0z3xm2dthop6a.htm   ... View more

Hi itshere, I have make a simple try below assuming different type of car purchased per month. If you could provide more information about uniqueness, I may try to refine it further. data test1; format date datetime21.; input type $ date datetime21. ; cards; a 01OCT2015:15:22:22 b 3OCT2015:15:22:22 a 11OCT2015:15:22:22 b 13OCT2015:15:22:22 c 11OCT2015:15:22:22 b 30OCT2015:15:22:22 a 01NOV2015:15:22:22 a 02NOV2015:15:22:22 b 03NOV2015:15:22:22 a 01MAR2015:15:22:22 b 02MAR2015:15:22:22 c 03MAR2015:15:22:22 ; run; data test2; set test1; month=put(datepart(date),worddatx9.); run; proc sql; create table test3 as select month, type,count(type) as num_of_car_per_month from test2 group by month, type ; quit;   ... View more