date validation

[Sheeba]

Hi,

I need to do a date validation to check if the date value entered into a data set is greater than or equal to sysdate.

User would be opening the data set to enter the value. If he is enters  a date value less than sysdate, error should pop up.

I am planning to use IC create statements.

Is there any alternate way?

Thanks in advance,

[Peter_C]

Is this about integrity constraints or about the client interface a user would use?

[Sheeba]

I would like to know if there is any alternate way  other than integrity constraints for this functionality

[Peter_C]

if SAS informats are being applied, you could create one which treats future-dated entries as invalid.

However, although an informat can apply in a data step reading values with INPUT statements and report to the sasLog, and SAS/AF and SAS/FSP windows provide immediate message feedback, in SAS Enterprise Guide, I don't see how it responds to your user.

[Sheeba]

ok...thanks for the details