topic New User Question re Displaying date range into quarter in SAS Enterprise Guide

New User Question re Displaying date range into quarter

BillB — Fri, 03 May 2013 20:18:57 GMT

I have a data set that has a field that shows dates as (SEE BELOW):

01MAY2012

01JAN2012

01JUL2012

How would I run a summary report and show the dates as quarters?

Q12012

Q22012

Q32012

Q42012

Reeza — Fri, 03 May 2013 21:17:28 GMT

In the report somehow you want to apply a format, yyQ, which would come up as 2012Q1

If you want the Q in front you may have to make your own format.

slchen — Fri, 03 May 2013 22:36:21 GMT

data have;

input date date9.;

format date date9.;

date1=date;

format date1 yyq10.;

date2=catt('Q',qtr(date),year(date));

cards;

01MAY2012

01JAN2012

01JUL2012

;

proc print;

run;