Help using Base SAS procedures

Need some help with date fields

Reply
Contributor
Posts: 40

Need some help with date fields

Hi,

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?

It's throwing an error. Please help.

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

thanks!!

PROC Star
Posts: 7,474

Need some help with date fields

SAS sql doesn't have an nvl function like Oracle.  Can you use the coalesce function instead?  Take a look at: http://decipherinfosys.wordpress.com/2007/08/02/coalesce-isnull-nvl/

Super User
Posts: 10,028

Need some help with date fields

Maybe you can use Pass-Through SQL to use all the function of Oracle.

Ask a Question
Discussion stats
  • 2 replies
  • 202 views
  • 0 likes
  • 3 in conversation