https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-calculate-year-lt-month/m-p/462301#M10197 <P>I want to create a calculated item which shows Year &lt;= Month</P><P><BR />I have field name month which is in date9 format.</P><P>Any help how i will calculate this in SAS VA 7.4?</P><P>&nbsp;</P><P>Regards\</P><P>ASH</P> Tue, 15 May 2018 10:13:47 GMT ASHLY 2018-05-15T10:13:47Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-calculate-year-lt-month/m-p/462301#M10197 <P>I want to create a calculated item which shows Year &lt;= Month</P><P><BR />I have field name month which is in date9 format.</P><P>Any help how i will calculate this in SAS VA 7.4?</P><P>&nbsp;</P><P>Regards\</P><P>ASH</P> Tue, 15 May 2018 10:13:47 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-calculate-year-lt-month/m-p/462301#M10197 ASHLY 2018-05-15T10:13:47Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-calculate-year-lt-month/m-p/462305#M10198 <P>Please clarify what you have, you cannot have a "month" in a date9. field.&nbsp; A date variable holds a number which is reflective of the number of days since the cutoff period.&nbsp; This then has a format applied to it like date9 which displays the number of days in a readable format.</P> <P>&nbsp;</P> <P>Next up "<SPAN>Year &lt;= Month" - this does not make any sense as only years up to 12ad will be &lt;= month which can only be 1-12.&nbsp; So please clarify what you want, provide some example data.</SPAN></P> Tue, 15 May 2018 10:30:16 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-calculate-year-lt-month/m-p/462305#M10198 RW9 2018-05-15T10:30:16Z