https://communities.sas.com/t5/SAS-Programming/Looking-for-equivalent-function-in-SAS/m-p/825935#M326230 <P>I am working on conversion of SQL Server queries into SAS code. Add_Days has been used to add no of days in date column. For example- add_days(date_column,15). Please suggest alternate for this function which can be used in SAS with PROC SQL.</P> Thu, 28 Jul 2022 14:26:43 GMT dewanganrahul 2022-07-28T14:26:43Z https://communities.sas.com/t5/SAS-Programming/Looking-for-equivalent-function-in-SAS/m-p/825935#M326230 <P>I am working on conversion of SQL Server queries into SAS code. Add_Days has been used to add no of days in date column. For example- add_days(date_column,15). Please suggest alternate for this function which can be used in SAS with PROC SQL.</P> Thu, 28 Jul 2022 14:26:43 GMT https://communities.sas.com/t5/SAS-Programming/Looking-for-equivalent-function-in-SAS/m-p/825935#M326230 dewanganrahul 2022-07-28T14:26:43Z https://communities.sas.com/t5/SAS-Programming/Looking-for-equivalent-function-in-SAS/m-p/825938#M326232 <P>SAS date values are counts of days, so you simply add 15 to get a date 15 days after.</P> <P>&nbsp;</P> <P>For more complex interval calculations, look at the <A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/lefunctionsref/p10v3sa3i4kfxfn1sovhi5xzxh8n.htm" target="_blank" rel="noopener">INTNX Function</A>.</P> Thu, 28 Jul 2022 14:32:22 GMT https://communities.sas.com/t5/SAS-Programming/Looking-for-equivalent-function-in-SAS/m-p/825938#M326232 Kurt_Bremser 2022-07-28T14:32:22Z