topic Re: How to Combine Year number, string 'Q', and Quarter # in New SAS User

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

CurryThree6 — Thu, 07 Mar 2019 20:41:57 GMT

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"

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

Tommy1 — Thu, 07 Mar 2019 21:56:20 GMT

Look into the different formats that are available for SAS dates

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

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

ballardw — Thu, 07 Mar 2019 22:05:10 GMT

Use the correct format with an actual SAS date value.

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