BookmarkSubscribeRSS Feed
ASHLY
Fluorite | Level 6

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

1 REPLY 1
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1077 views
  • 0 likes
  • 2 in conversation