Hey Ballard, I'm not really sure that it worked to be honest. Here is a sample of the dataset that has returned. To talk through my objective so that I'm making more sense. In this scenario, I ran the report for the last 45 days to capture December and January. I only want Decembers numbers to display, however I'm still showing January. Can you help me figure out how to only show the data for December in this case? Going forward, when I run this report, The month that I run it in. Say Feb 1, should only include the data/counts for January. Hope that I am making sense, and let me know if I can clarify better. Im not sure if this will help, but here are my date variables that I have created to work throughout the report. data _null_;
today=today();
call symputx('enddate',quote(put(today,yymmddd10.),"'"));
call symputx('startdate',quote(put(today-45,yymmddd10.),"'"));
run;
data _null_;
today=dhms(today(),0,0,0);
call symputx('end_dt',cats(quote(put(today,datetime16.),"'"),'dt'));
start_dt=intnx('dtday',today,-45,'b');
call symputx('start_dt',cats(quote(put(start_dt,datetime16.),"'"),'dt'));
run;
%put &=enddate;
%put &=startdate; Here is the code that I used which you recommended: data work.ClarityEstimations3;
set work.ClarityEstimations2;
if date >= intnx('day', today(),-30);
run;
... View more