DATA Step, Macro, Functions and more

Limiting data to contain only 24 months

Reply
New Contributor
Posts: 2

Limiting data to contain only 24 months

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?

Respected Advisor
Posts: 3,799

Re: Limiting data to contain only 24 months

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

New Contributor
Posts: 2

Re: Limiting data to contain only 24 months

Posted in reply to data_null__

Months are variables in the data

Respected Advisor
Posts: 3,799

Re: Limiting data to contain only 24 months

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;

9-10-2014 3-01-00 PM.pngproc contents varnum;
  
run;
Regular Contributor
Posts: 233

Re: Limiting data to contain only 24 months

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;

Capture.JPG

Ask a Question
Discussion stats
  • 4 replies
  • 237 views
  • 0 likes
  • 3 in conversation