Need to create a column showing whether a set of dates is Quarter 1 or Q2

[Kurt_Bremser]

Use a dataset option:

proc summary data=MYDATA (rename=(eventdate=year_qtr));

and use the new name in the CLASS and FORMAT statements.

Or use a LABEL statement.

[This widget could not be displayed.]

I did this and that worked:

output out= EMpull2 (rename=(sum=QTR_COST real_date=year_qtr) ) ;

[Tom]

What type of variable is EVENTDATE?  Run PROC CONTENTS on the source dataset and check.

Is the TYPE of the variable numeric or character?
If numeric is their any FORMAT attached to it?  What FORMAT is attached?  

If the variable is numeric with a format used for displaying dates (DATE, MMDDYY, YYMMDD, etc) then you have a date variable.  Otherwise you will need to first convert EVENTDATE into date values.

If your variable has a DATE value then the QTR() function will return an integer from 1 to 4.  You will need to check the YEAR of the date if you only want the first two quarters in 2021.