topic Count the number of occurrences per week in Statistical Procedures

Count the number of occurrences per week

markc — Thu, 13 Sep 2018 23:26:47 GMT

Hello,

How can I easily produce a chart of the number of observations that occurred per week based on a date field on each observation over the previous 3 months from a parameter date?

Specifically, I am wondering if there is a proc which can do most of the work of this, where you give it a dataset with the dates and it then clusters the number of observations by week, going back a specified number of intervals (in this case 3 weeks) and then produces a table or chart.

Kind regards,

Mark

Re: Count the number of occurrences per week

PGStats — Thu, 13 Sep 2018 04:48:25 GMT

If date and parmdate are SAS dates, you can use

weeks = intck("WEEK", date, parmDate, "Continuous")

to get the number of weeks between date and parmDate.

Re: Count the number of occurrences per week

andreas_lds — Thu, 13 Sep 2018 06:23:41 GMT

Please post example data, the expected result and a value the parameter date contains.

It seems that you need a where-statement to get the observations of the 3 month before param_data. Assuming that the parameter contains the string 9Sep2018 (value taken from EG prompt): where data_date >= intnx('month', "&promptDate."d, -3, 's')

To get the number of observations per week, applying a format like weekv5 and using a proc like summary or freq could yield the required result. But without any data shown, this is pure guesswork.

Re: Count the number of occurrences per week

ballardw — Thu, 13 Sep 2018 15:29:05 GMT

@markc wrote:

Hello,

How can I easily produce a chart of the number of observations that occurred per week based on a date field on each observation over the previous 3 months from a parameter date?

Kind regards,

Mark

How does the "parameter date" get involved? Is that used to filter data or indicate the first day of a "week" and calculate weeks based on seven day intervals from the parameter of something else? By previous 3 months do you mean from the first day of the month 3 previous or go back to the same day of the month 3 previous?

And which day of the week starts your week?

How do you want "week" interpreted if your period crosses year boundaries?