BookmarkSubscribeRSS Feed
Sheeba
Lapis Lazuli | Level 10

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,

4 REPLIES 4
Peter_C
Rhodochrosite | Level 12

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

Sheeba
Lapis Lazuli | Level 10

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

Peter_C
Rhodochrosite | Level 12

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
Lapis Lazuli | Level 10

ok...thanks for the details

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 858 views
  • 0 likes
  • 2 in conversation