topic Re: dataset constraints in SAS Programming

dataset constraints

kds — Fri, 09 Nov 2012 17:24:56 GMT

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)

Re: dataset constraints

art297 — Fri, 09 Nov 2012 18:20:11 GMT

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'.";

Re: dataset constraints

kds — Fri, 09 Nov 2012 18:36:59 GMT

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