cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Lupo
‎07-18-2019
  • 3 Posts
  • 0 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: SAS VA: How to subtract months from a date to calculate a new date

by Calcite | Level 5 in SAS Visual Analytics
‎07-18-2019 03:53 AM
‎07-18-2019 03:53 AM
Hello SurajSaini,   Thank you for the reply. It is indeed the challenge that the date is variable. There fore i have implemented a simple solution. With the "treat as" function i have changed to date into a number. Dan subtract 180 days from it.    The goal to warn the user that a depreciation date was coming within 6 months. This information can be used for business purposes.   I will close this issue.   Regards, Lucien ... View more

SAS VA: How to subtract months from a date to calculate a new date

by Calcite | Level 5 in SAS Visual Analytics
‎07-09-2019 04:49 AM
‎07-09-2019 04:49 AM
Dear SAS Community member,   I am now dealing with a challenge that surprised me. Because i thought there was a simple solution for it 🙂   This is the case.   In SAS VA i like to caculate a new date by subtracting 6 months.   Date - 6months = new date.   Steps: First i like to use treatas function to make the date numeric. Then find a formula to subtract 6 months. This formula must take the diffrent numbers of days in the months into account.   Question: Is there a formula which i can use in SAS VA which can calculate 6 months?   Remarks: I do not use SAS Base.   Regards, Lucien ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-18-2019 08:57 AM
Quick links