topic Report with 1000 days from now in New SAS User

Report with 1000 days from now

rahulpatil6886 — Fri, 30 Jan 2026 11:22:53 GMT

Generate a report for a 15-day period starting exactly 1,000 days before today. The report title should include the start date (Day 1) and end date (Day 15) of this period.

Expected output:

Re: Problem 1

Kurt_Bremser — Fri, 30 Jan 2026 06:23:29 GMT

Show what you have already tried and where your problems are. Note: SAS date values are counts of days, so the 1000-day and 15-day intervals are simple to build.

Re: Problem 1

Ksharp — Fri, 30 Jan 2026 08:32:33 GMT

Once you get these start and end date like the following, that would be very easy thing.

data start_end;
do start=date()-1000 to date() by 15;
 end=start+14;
 output;
end;
format start end date9.;
run;

Better Subject Line Needed

PaigeMiller — Fri, 30 Jan 2026 11:22:39 GMT

@rahulpatil6886 Please go back to your original post and modify the subject line to briefly describe the problem. When you use a subject line like "Problem 1", no one knows if this is a problem they will be interested in or not.

Re: Report with 1000 days from now

Quentin — Fri, 30 Jan 2026 13:51:54 GMT

Not sure if you're asking about how to generate the title, or the WHERE statement for filtering your data. Can you show an example of the code you have tried?

I would likely use the macro variables to store the start and end of the interval. You could calculate those like:

%let start= %sysfunc(intnx(day,%sysfunc(today()),-1000),date9) ;
%let end=   %sysfunc(intnx(day,%sysfunc(today()),-1000+15),date9) ;
%put &=start &=end ;