topic Need some help with date fields in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Need-some-help-with-date-fields/m-p/55401#M15416 <HTML><HEAD></HEAD><BODY><P>SAS sql doesn't have an nvl function like Oracle.&nbsp; Can you use the coalesce function instead?&nbsp; Take a look at: <A href="http://decipherinfosys.wordpress.com/2007/08/02/coalesce-isnull-nvl/">http://decipherinfosys.wordpress.com/2007/08/02/coalesce-isnull-nvl/</A></P></BODY></HTML> Mon, 28 Nov 2011 18:22:20 GMT art297 2011-11-28T18:22:20Z Need some help with date fields https://communities.sas.com/t5/SAS-Procedures/Need-some-help-with-date-fields/m-p/55400#M15415 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If I wanted to check in a proc sql for a null date values and convert to a furture date if null and then compare that date using current date, can't I use nvl function? </P><P></P><P>It's throwing an error. Please help.</P><P></P><P>For example, I may have null date value in a date field and when I wanted to compare this null date value after converting to a furture date agains current date ....</P><P></P><P>thanks!! </P></BODY></HTML> Mon, 28 Nov 2011 18:08:17 GMT https://communities.sas.com/t5/SAS-Procedures/Need-some-help-with-date-fields/m-p/55400#M15415 sasbasls 2011-11-28T18:08:17Z Need some help with date fields https://communities.sas.com/t5/SAS-Procedures/Need-some-help-with-date-fields/m-p/55401#M15416 <HTML><HEAD></HEAD><BODY><P>SAS sql doesn't have an nvl function like Oracle.&nbsp; Can you use the coalesce function instead?&nbsp; Take a look at: <A href="http://decipherinfosys.wordpress.com/2007/08/02/coalesce-isnull-nvl/">http://decipherinfosys.wordpress.com/2007/08/02/coalesce-isnull-nvl/</A></P></BODY></HTML> Mon, 28 Nov 2011 18:22:20 GMT https://communities.sas.com/t5/SAS-Procedures/Need-some-help-with-date-fields/m-p/55401#M15416 art297 2011-11-28T18:22:20Z Need some help with date fields https://communities.sas.com/t5/SAS-Procedures/Need-some-help-with-date-fields/m-p/55402#M15417 <HTML><HEAD></HEAD><BODY><P>Maybe you can use Pass-Through SQL to use all the function of Oracle.</P></BODY></HTML> Tue, 29 Nov 2011 02:20:45 GMT https://communities.sas.com/t5/SAS-Procedures/Need-some-help-with-date-fields/m-p/55402#M15417 Ksharp 2011-11-29T02:20:45Z