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,
Is this about integrity constraints or about the client interface a user would use?
I would like to know if there is any alternate way other than integrity constraints for this functionality
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.
ok...thanks for the details
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.