topic Re: SAS VA: How to compare data for all date to data from the same day of the previous year? in SAS Visual Analytics

SAS VA: How to compare data for all date to data from the same day of the previous year?

SKG — Fri, 26 Aug 2016 07:14:01 GMT

Hi Guys,

How to compare data for all date to data from the same day of the previous year? Actually i'm facing an issue from last 3 months.

I got some solution from blogs.sas, there's Bobbie Wagoner lady, she given a solution "how to compare data for a selected date to data from the same day of the previous year". Please refer this link

http://blogs.sas.com/content/sgf/2016/08/22/working-with-dates-in-sas-visual-analytics-comparing-to-the-previous-year/#comment-212624

But i want to compare data for all date not a single date comparison from the same day of the previous year (current - 364) for all date.

Regards,

Sunny Kumar Gupta

Re: SAS VA: How to compare data for all date to data from the same day of the previous year?

Pamela_JSRCC — Sat, 27 Aug 2016 03:59:16 GMT

Please provide a sample dataset and desired results.

Re: SAS VA: How to compare data for all date to data from the same day of the previous year?

SKG — Mon, 29 Aug 2016 04:49:48 GMT

Sample data is called a Database

and

Format data means i need in this format through SAS VA.

I'm attaching .RAR file.

Re: SAS VA: How to compare data for all date to data from the same day of the previous year?

SKG — Mon, 29 Aug 2016 04:51:00 GMT

Re: SAS VA: How to compare data for all date to data from the same day of the previous year?

SKG — Mon, 29 Aug 2016 04:51:19 GMT

Re: SAS VA: How to compare data for all date to data from the same day of the previous year?

maverickkub — Tue, 30 Aug 2016 06:53:50 GMT

Sunny.

are you trying to compare last year's year to date revenue to this year's year to dae revenue for the same dates?

fro e.g revenue till 11august2015 was 1040000 and revnue for this year's same date that is 11august2016 is 9800000.

Is this what you are trying to compare?

Re: SAS VA: How to compare data for all date to data from the same day of the previous year?

SKG — Tue, 30 Aug 2016 07:45:53 GMT

Hi Bro,

Not compare date from the pervious year date. That's called Previous date (Date - 365 days) comprasion

Actually my requirement to compare a single with previous year (Same Day). That's called Previous Date (Date - 364 days) comprasion. An ex.: Date : 30-Aug-2016 then Previous Date : 29-Aug-2015 Comprasion.

Please refer this link for actuall requirement mine.

https://communities.sas.com/t5/SAS-Visual-Analytics/Is-it-possible-in-VA-parallel-period/td-p/212983

Re: SAS VA: How to compare data for all date to data from the same day of the previous year?

SKG — Fri, 16 Sep 2016 08:44:47 GMT

Hi Guys,

Is there anyone to give me a solution on the same query?

I'm facing problem still.

Regards,

Sunny Kumar Gupta