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

How to calculate year <= month

Reply
New Contributor
Posts: 2

How to calculate year <= month

[ Edited ]

I want to create a calculated item which shows Year <= Month


I have field name month which is in date9 format.

Any help how i will calculate this in SAS VA 7.4?

 

Regards\

ASH

Super User
Super User
Posts: 9,855

Re: How to calculate year <= month

Please clarify what you have, you cannot have a "month" in a date9. field.  A date variable holds a number which is reflective of the number of days since the cutoff period.  This then has a format applied to it like date9 which displays the number of days in a readable format.

 

Next up "Year <= Month" - this does not make any sense as only years up to 12ad will be <= month which can only be 1-12.  So please clarify what you want, provide some example data.

Ask a Question
Discussion stats
  • 1 reply
  • 115 views
  • 0 likes
  • 2 in conversation