topic Re: create a quarter in SAS Programming

create a quarter

France — Thu, 13 Sep 2018 20:19:53 GMT

dear all,

I would like to create a quarter variable based on a date variable.

The FORMAT of the date is YYMMDDD10. (e.g.,1990-09-29). I use the code like

DATA Step1.Appln_newQuarter;
   SET Step1.appln_new;
   IF MONTH(earliest_filing_date)=1 or 2 or 3 THEN quarter=1;
   ELSE IF MONTH(earliest_filing_date)=4 or 5 or 6 THEN quarter=2;
   ELSE IF MONTH(earliest_filing_date)=7 or 8 or 9 THEN quarter=3;
   ELSE IF MONTH(earliest_filing_date)=10 or 11 or 12 THEN quarter=4;   
RUN;

but the result is '1'. could you please give me some suggestions?

thanks in advance.

Re: create a quarter

novinosrin — Thu, 13 Sep 2018 20:26:42 GMT

DATA Step1.Appln_newQuarter;
   SET Step1.appln_new;
    quarter=qtr(earliest_filing_date);
     
RUN;

Use the qtr function -- is all you need i think

Re: create a quarter

ballardw — Thu, 13 Sep 2018 21:42:08 GMT

@France wrote:

dear all,

I would like to create a quarter variable based on a date variable.

The FORMAT of the date is YYMMDDD10. (e.g.,1990-09-29). I use the code like
DATA Step1.Appln_newQuarter;
   SET Step1.appln_new;
   IF MONTH(earliest_filing_date)=1 or 2 or 3 THEN quarter=1;
   ELSE IF MONTH(earliest_filing_date)=4 or 5 or 6 THEN quarter=2;
   ELSE IF MONTH(earliest_filing_date)=7 or 8 or 9 THEN quarter=3;
   ELSE IF MONTH(earliest_filing_date)=10 or 11 or 12 THEN quarter=4;   
RUN;
but the result is '1'. could you please give me some suggestions?

thanks in advance.

For a very large number of purposes you may not even need to create an additional variable at all. SAS provides several formats for date values that will display quarters: QTRw. by default displays 1 to 4, QTRRw. which displays quarter as Roman numerals: I II III and IV, YYQw which will show year and quarter information together depending on width YYQ. default shows YYYYQn such as 2018Q1 or YYQxw. where you choose a charcter for x that controls the separator between the year and quarter numbe allowing such things as 2012/3 or 2017-2.

Analysis procedures will honor the formatted value for grouping purposes.