topic Date as a quarter with year in SAS Programming

Date as a quarter with year

CharlesFowler72 — Mon, 25 Feb 2019 21:37:45 GMT

Hi guys,

trying to get a date into a quarter format exactly like this..."Q1'19".

I'm pretty close with Quarter = Cat("Q",qtr(month),"'",year(month)) where month is my date variable.

But this gives Q1'2019 which is close but not quite there.

any help would be great. There is lots on the site already about this stuff but none did exactly this.

Re: Date as a quarter with year

Astounding — Mon, 25 Feb 2019 21:44:32 GMT

Well, you could change this:

year(month)

Just use this instead:

year(month) - 2000

Re: Date as a quarter with year

Reeza — Mon, 25 Feb 2019 21:53:01 GMT

SUBSTRN() will allow you to substring a character variable.

SUBSTRN(year(month), 3, 2) will give you the last two digits. You may also want to explore a custom format. That's an easier solution overall.