You can use the following format to convert a date to YYMM or YYYYMM. For example: 12-03-2018 to 201803: put(r.MyDate, yymmn6.) as MyDateFormatted See this link for more details: http://support.sas.com/documentation/cdl/en/fedsqlref/67364/HTML/default/viewer.htm#n1d48aw39lluo9n1xdepexkarko1.htm
... View more