Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS VA between date ranges

Reply
Occasional Contributor
Posts: 17

SAS VA between date ranges

Dear All,

I would like to seek help inside VA report, how to create a measure or aggregated measure with date ranges.

I have a categories between 2 date ranges such as

Categories      Date start          Date end

A                    01JAN2015        31JAN2015

B                    01JAN2015        31DEC2015

C                    02FEB2015        28FEB2015

D                    02FEB2015        31DEC2015

next to create a new aggregated measure in report graph to show something like the image

so B will count/sum/ etc in each month of 2015 the bar chart.

http://s53.photobucket.com/user/elenatec/media/Bar%20Chart.png.html

I have tried to use VA text calculated item

( Month('Trading_date'n) BetweenInclusive(Month('Transaction Start Date'n), Month('Transaction End Date'n)) )

but i would like to have something like VA Agre.png

http://s53.photobucket.com/user/elenatec/media/VA%20Agre.png.html



Regards,

Ong

SAS Super FREQ
Posts: 275

Re: SAS VA between date ranges

Hello Ong,

I'm not completely sure I understand what you want to do.

Unfortunately, you cannot use date operators such as Month() in an aggregated measure expression.

We do have Periodic operators in aggregated expressions, which can make calculations such as the year-to-date monthly sum. I'm not sure if that would be helpful to you with your date ranges however. Possibly some combination of filters on the date ranges (or on your "Categories" variable) plus a year-to-date periodic operator (CumulativePeriod) might help.

Thanks,

Sam

Post a Question
Discussion Stats
  • 1 reply
  • 242 views
  • 0 likes
  • 2 in conversation