Create a Due date in SAS Viya

[Randy_Morris]

How do I create a simple Due Date as a calculated Item in SAS VIYA.

I have a date:  'File_Sent_Date'
I need to add 300 days to the 'File_Sent_Date'

I need the result to be in date format.

I really thought it would be simple like Due_Date=intnx('File_Sent_Date',270), But I guess I can't use Intnx in SAS Viya.

Thank you!!

[SASJedi]

Your syntax for INTNX is incorrect. Have you tried:

Due_Date=intnx('day',File_Sent_Date,300)

[Randy_Morris]

I get “Unknown function: intnx “

[SASKiwi]

I suspect you are trying to add a formula to SAS Viya Visual Analytics. Is that correct? VA formulas have their own language and it is not the same as traditional SAS language like INTNX. 

[Randy_Morris · Accepted solution]

I found a way to achieve my due date.  There might be a better way to do it, but it works for me.  Thanks for everyone's replies!

TreatAs(_Date_, ( TreatAs(_Number_, 'FILE_SENT_DATE'n) +
300))