topic Re: Create a Due date in SAS Viya in SAS Viya

Create a Due date in SAS Viya

Randy_Morris — Tue, 28 Jan 2025 14:45:19 GMT

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!!

Re: Create a Due date in SAS Viya

SASJedi — Wed, 29 Jan 2025 13:20:04 GMT

Your syntax for INTNX is incorrect. Have you tried:

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

Re: Create a Due date in SAS Viya

Randy_Morris — Wed, 29 Jan 2025 18:21:47 GMT

I get “Unknown function: intnx “

Re: Create a Due date in SAS Viya

SASKiwi — Wed, 29 Jan 2025 20:15:56 GMT

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.

Re: Create a Due date in SAS Viya

Randy_Morris — Fri, 31 Jan 2025 12:01:54 GMT

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))