I have a SAS EG assignment that needs me to combine year, 'Q' string, and quarter number in column. I converted a column named 'Date' (date format is 01Jan2019 for example) by using a WHEN Condition to read if the Q will be 1,2,3,or 4 named 'Quarter Ordered' with the Quarter number, shown below.. Date Quarter Sep2018 4 Q1 is January, February, March. Q2 is April, May, June. Q3 is July, August, September. Q4 is October, November, December. I'm stuck on how to format the quarter ordered column to read for example "2018Q4"
... View more