Limiting data to contain only 24 months

[SeanG008]

Hi,

I am new to SAS and I need to know how to limit the number of months to 24.

Every month I upload new data and would like the oldest month to be dropped off.

Any advice?

[data_null__]

Are you talking about data sets, variables, or observations?  Show some example data.

[SeanG008]

Months are variables in the data

[data_null__]

Depends on how the month variables are named.  Here is an example that might be helpful.

data new;
   m1=1;
   label m1='New m1';
   run;
data m24;
   array m[24] (1:24);
   run;

data m24u;
   merge new m24(drop=m24 rename=(m1-m23=x2-x24 x2-x24=m2-m24));
   run;

proc contents varnum;
   run;

[Hima]

data have;
input id date;
format date mmddyy10.;
informat date mmddyy10.;
cards;
1 01/01/2014
2 01/01/2013
3 01/01/2012
;
run;

data want;
set have;
var1=INTCK('Month',date,today());
if INTCK('Month',date,today()) ge 24 then delete;
else output;
run;

proc print; run;