topic Re: Selection of quarters in SAS Procedures

Selection of quarters

SAS_NUBI2015 — Sun, 10 May 2015 11:27:12 GMT

Hello together,

I've a question based on SAS date and time interval about selection of quarters via pattern:

I try to select the the quarters from year 2014 until current quarter (20152). The output is some thing like that:

20142

20143

20144

20151

20152

As I understood the SAS function 'YYQ' the return value is like YYQ or YYYYQ. Because the saved format of quarters is YYYYQ in my table is, I tried the following syntaxs without success:

Attempt 1: WHERE T1.V_quarter_date >= yyq(year(date()))-1,qtr(date()));

Attempt 2: WHERE T1.V_quarter_date >= (yyq(year(date))-1,intnx('Q',today(),0,'S'));

The another possibility was in my opinion as follows:

WHERE T1.V_quarter_date >= (input( ((year(date))-1) || intnx('Q',today(),0,'S')),best5.); //converting char to num

What is wronge in my syntax?

Thank you.

Re: Selection of quarters

Ksharp — Mon, 11 May 2015 14:40:51 GMT

You can not use yyq() in that way if V_quarter_date is a DATE type variable.

WHERE T1.V_quarter_date between '01JAN2014'd and '28FEB2015'd ;

Re: Selection of quarters

Peter_C — Mon, 11 May 2015 14:55:00 GMT

things that might help

yyq function http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000199346.htm

yyqN. format http://support.sas.com/documentation/cdl/en/leforinforref/63324/HTML/default/viewer.htm#p024gsdcagozdnn1se1nqs4rnwjl.htm

INTNX function http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000212700.htm

because I'm not sure I understand the request

Re: Selection of quarters

SAS_NUBI2015 — Mon, 11 May 2015 14:58:17 GMT

Hello together,

the right solution ist:

where

T1.V_quarter_date >= (input( put((intnx('Q',today(),-1,'beginning')),yyqn5.),5.);

Thanx again.