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
In the report somehow you want to apply a format, yyQ, which would come up as 2012Q1
SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition
If you want the Q in front you may have to make your own format.
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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.