topic Re: I have question regarding how many weeks' data maintain the following code for week ending repor in SAS Enterprise Guide

I have question regarding how many weeks' data maintain the following code for week ending report.

Munivan — Thu, 21 Dec 2023 20:21:30 GMT

r.activdate <= intnx('days', "&datepmt."d, -90)

Re: I have question regarding how many weeks' data maintain the following code for week ending repor

ballardw — Thu, 21 Dec 2023 20:31:35 GMT

It is asking for 90 days and nothing related to "weeks".

Week can have multiple definitions as to start day of the week, how the transition across calendar years gets treated and such.

Look at the WEEK function documentation and the U, V and W descriptor options for example.

Without knowing which definition you use can't say. Also I see nothing that bears on a "week ending" to clarify.

Re: I have question regarding how many weeks' data maintain the following code for week ending repor

mkeintz — Thu, 21 Dec 2023 21:02:58 GMT

You could have ANY number of days, given that you restrict activdate to

      and r.activdate <= intnx('days', "&datepmt."d, -90)

This puts a ceiling on acceptable activdate values, but no minimum.

Now, you could find the minimum activdate found in the data, so you would know the number of possible date values. But you would als have to know the maximum date value found to get the RANGE. And do a frequency of activdate to get the actual NUMBER of unique date values.

So what do you actually want?