topic Re: date validation in SAS Procedures

date validation

Sheeba — Tue, 04 Jun 2013 17:09:58 GMT

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,

Re: date validation

Peter_C — Tue, 04 Jun 2013 18:50:03 GMT

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

Re: date validation

Sheeba — Tue, 04 Jun 2013 18:58:07 GMT

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

Re: date validation

Peter_C — Tue, 04 Jun 2013 21:52:17 GMT

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.

Re: date validation

Sheeba — Tue, 04 Jun 2013 23:15:52 GMT

ok...thanks for the details