topic Re: Limiting data to contain only 24 months in SAS Programming

Limiting data to contain only 24 months

SeanG008 — Wed, 10 Sep 2014 19:07:04 GMT

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?

Re: Limiting data to contain only 24 months

data_null__ — Wed, 10 Sep 2014 19:15:51 GMT

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

Re: Limiting data to contain only 24 months

SeanG008 — Wed, 10 Sep 2014 19:20:26 GMT

Months are variables in the data

Re: Limiting data to contain only 24 months

Hima — Wed, 10 Sep 2014 19:47:35 GMT

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;

Re: Limiting data to contain only 24 months

data_null__ — Wed, 10 Sep 2014 20:02:24 GMT

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;