dataset constraints

[kds]

Hi,

while defining constraints on dataset columns, like

proc datasets;

     modify datasetname;

     ic create i_reqd = check(where=(reqd in ('YES','NO'))) message = "Valid values for variable REQD are either 'YES' or 'NO'.";

quit;

The above defined constraint allows only YES & NO (uppercase values). how can I make it case insensitive.??.. that is user shd be able to enter (yes , no, YES, NO,Yes,No yEs,nO)

[art297 · Accepted solution]

Can't you just include the upcase function?  e.g.,

    ic create i_reqd = check(where=(upcase(reqd) in ('YES','NO'))) message = "Valid values for variable REQD are either 'YES' or 'NO'.";

[kds]

Yes , upcase is working...  Thanks Arthur  , you are Great!!