How to Combine Year number, string 'Q', and Quarter #

[CurryThree6]

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"

[Tommy1]

Look into the different formats that are available for SAS dates

http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#p1wj0wt2ebe2a0n1lv4l...

[ballardw]

Use the correct format with an actual SAS date value.

data example;
   date = '01Jan2019'd;
   format date yyq6.;
run;