Hi Forum,
I'm using SAS VA 7.1 on Windows & 32 bit & have created a table of data that has weekly counts by State.
So I've added a Crosstab Object to the Report builder & added Weekending (Date) to 'Columns', State to 'Rows' ($) & Counts (Float) as a Measure.
I use the 'Create - Difference from previous Period' & add that new calc to the table.
I'm just getting blanks between the Count rows & can't work out why.
Can anyone advise what's possibly wrong here?
Thanks
Hi Peter,
When you talk about the code, do you mean the syntax in the expression editor?
The parameters are documented here:
This is the 7.3 doc, but I don't believe there is any difference from VA 7.1 if you are using 7.1.
The interval operators can be either _Inferred_, _ByMonth_, _ByQuarter_, or _ByYear_. There is not a way to specify a weekly interval.
My understanding is that the LASR data server is limited in what periodic intervals it can process, in the current implementation. This could possibly be expanded in a future release.
Thanks,
Sam
Hi Again,
I've found that by playing around with the aggregation of the measure that I can get results for 'Difference from Previous period'.
I've changed the measure to Count instead of Sum which shows a result but I do need to Sum my measure for the report.
I find it strange that I can't get this to work as I thoght it would be fairly straightforward.
Has anyone had the same issue??
Thanks
After further playing around, I think I've discovered the answer.
I could be wrong but I don't think VA has the Aggregated measures set up for Weekly periods, just Month/Quarter/Yearly?
I'm using 7.1 so maybe this has changed but I would be interested to know how anyone has created a Week on Week % Change.
Once I converted my Weekly formatted date to Month & Yearly, I used those fields to use in the Aggregated Measures & all is well !!
Can't say I saw any limitations in my search for the answer??
Anyway, in case someone has the same issue, there it is (or is for me anyhow ...)
Cheers : )
Thanks for confirming Sam,
I've created a way to do it by reformatting my data to contain Weekly data Sales Count Fields for the Current Week, Last Week, Last Month & Last Year.
This allowed me to create an Aggregated Measure to calc my Week on Week etc ...
I would find a weekly option useful as a future suggestion to develop.
Btw, I saw the code behind the Aggregated Measure options & wondered if it's possible to alter the code to suit Weekly in the meantime?
ParallelPeriod(_Sum_, 'ProductTotal'n, 'WeekStarting'n, _Inferred_, _Inferred_, 0, _Full_, {Date}) - ParallelPeriod(_Sum_, 'ProductTotal'n, 'WeekStarting'n, _Inferred_, _Inferred_, -1, _Full_, {Date})
I've been trying to find more info about the 'Parallel Period', 'Inferred' & 'Full' terms in the code but can't find anything that helps me understand it & alter it to enable the Weekly option, any suggests??
Cheers Peter , (Oscar(Boots) is my Dogs nickname) : ).
Hi Peter,
When you talk about the code, do you mean the syntax in the expression editor?
The parameters are documented here:
This is the 7.3 doc, but I don't believe there is any difference from VA 7.1 if you are using 7.1.
The interval operators can be either _Inferred_, _ByMonth_, _ByQuarter_, or _ByYear_. There is not a way to specify a weekly interval.
My understanding is that the LASR data server is limited in what periodic intervals it can process, in the current implementation. This could possibly be expanded in a future release.
Thanks,
Sam
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.