Tom,   Thanks! You pointed me in the right direction and I have it working. The data is pulled from other tables and the two that worked previously had the conversion:   put(input(gw_call_date,mmddyy10.),yymms7.) AS month   The one that didn't work  was coming from a DATETIME16. format and was converted as follows:   datepart(ffup_dttm) format=yymms7. as month   Changing that to the following fixed the problem"   put(datepart(ffup_dttm),yymms7.) as month ... View more