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

YTD SAS VA

Reply
Occasional Contributor
Posts: 7

YTD SAS VA

Hello everyone,

                         Can anybody tell me how to calculate YTD in SAS VA starting from April month till March as per indian fiscal year.

 

Regards,

Harsh Patel

PROC Star
Posts: 624

Re: YTD SAS VA

Did you try using the custom code to get your result. Please provide what you have done so far.

Thanks,
Suryakiran
Super User
Posts: 4,016

Re: YTD SAS VA

According to this post the periodic functions in VA can only handle calendar years - an enhancement is planned but is not yet available. The workaround is to add a column to your data tracking financial year prior to loading into VA. If you want help setting this up please advise.

https://communities.sas.com/t5/SAS-Visual-Analytics/Financial-Calendar/m-p/310901#M5791

SAS Super FREQ
Posts: 586

Re: YTD SAS VA

Release 8.2 offers the ability to create a fiscal year. See Cumulative Period in the user's guide:

 

 

 

 

SAS Super FREQ
Posts: 830

Re: YTD SAS VA

Check the whats new in VA7.4

 

it says:

  • The CumulativePeriod operator for aggregated measures now enables you to customize the starting month for each year (for example, to calculate year-to-date based on the fiscal year for your company).
Ask a Question
Discussion stats
  • 4 replies
  • 309 views
  • 2 likes
  • 5 in conversation