topic Re: Grouping dates by bi-monthly groups in SAS Procedures

Grouping dates by bi-monthly groups

PTD_SAS — Tue, 19 Aug 2014 04:59:50 GMT

Would anyone suggest an algorithm to group dates by cponsecutive bi-monthly groups? I.e. similar to quarters but insteaed of 3 to have 2 month groups. For example, Jan-Feb 2014 would be B1 (similar to Q1 for quarters), Mar-Apr 2014 would be B2 etc.

Thanks,

Fethon Naoum

Re: Grouping dates by bi-monthly groups

user24feb — Tue, 19 Aug 2014 06:20:33 GMT

Maybe like this:

Data A;
Do i=1 To 2;
    Do j=1 To 12;
      Date=MDY(j,1,2000+i);
   Value=Round(Normal(1)*20+50);
   Output;
End;
End;
Format Date Date9.;
Keep Date Value;
Run;

Proc Expand Data=A Out=B (Keep=Date B_Value);
Convert Value = B_Value / Method = None Transformout = (Cmovave 2);
Run;

Data B;
Set B;
If Mod(_N_,2) eq 1 Then Do;
B_Value=B_Value*2;
Output;
End;
Run;

Re: Grouping dates by bi-monthly groups

PTD_SAS — Tue, 19 Aug 2014 06:44:14 GMT

Thank you, helpful hints.

Fethon

Re: Grouping dates by bi-monthly groups

Jagadishkatam — Tue, 19 Aug 2014 07:16:26 GMT

hope this is what you were expecting

proc format ;

value mon 1-2='B1'

3-4='B2'

5-6='B3'

7-8='B4'

9-10='B5'

11-12='B6';

run;

data test;

length qtr$10.;

do m=1 to 12;

date=mdy(m,1,2010);

qtr=put(month(date),mon.);

put qtr=;

output;

end;

run;

Thanks,

Jag

Re: Grouping dates by bi-monthly groups

mkeintz — Tue, 19 Aug 2014 12:20:33 GMT

data want;

set have;

bimonth_date=intnx('month2',date,0,'beg');

** or ** ;
bimonth_withinyear= ceil(month(date)/2) ;

** or **

bimonth_overall = intck('month2','31dec1999'd,date);

run;

Re: Grouping dates by bi-monthly groups

PTD_SAS — Tue, 19 Aug 2014 23:12:30 GMT

Thanks, very smart with just one line of code! Exactly what I wanted.

Re: Grouping dates by bi-monthly groups

PTD_SAS — Tue, 19 Aug 2014 23:14:07 GMT

Thanks, good hints.