Is there anyway to create day wise previous data through Periodic function in SAS VA?

[SKG]

Hi Guys,

Is there anyway to create day wise data through Periodic function (like Relative Period, Parallel Period, Cumulative, Parallel, PeriodwithDate...) in SAS Visual Analytics?

An example:

I have dataset like this in LASR Server

Date                          Revenue

24-Sep-2015                 $20

25-sep-2015                 $10

26-sep-2015                 $40

27-sep-2015                 $50

28-sep-2015                 $60

24-Sep-2016                 $70

25-Sep-2016                 $80

26-Sep-2016                 $90

27-Sep-2016                 $16

28-Sep-2016                 $25

and i want day wise comparison current date to previous date...

Date                           Revenue         Previous Revenue

24-Sep-2016                 $70                        $20

25-Sep-2016                 $80                        $10

26-Sep-2016                 $90                        $40

27-Sep-2016                 $16                        $50

28-Sep-2016                 $25                        $60

Regards,

Sunny Kumar Gupta

[LinusH]

Yes, like I mentioned in your other thread the are periodic operators. Not sure if they cover all the scenarios you're mention.
http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#n1lxnqfip132can1hdzue...

[SKG]

Hi Linush,

There are only three specifics interval i.e _ByMonth_, _ByQuarter_, _ByYear_ but there were no any _ByDay_ interval option available.

[LinusH]

For the outer interval you can use _ByYear_. But you are correct, you probably need a _ByDay_ for the inner interval.

[Sam_SAS]

Day-wise interval can be used when your inner interval is set to _Inferred_.

However, as I understand it there are some technical issues calculating day-wise data over time. If your operator has an offset (like your example with RelativePeriod would have) then we return missing values.

I think this is something we are working to improve for the future.

Thanks,

Sam