SAS Helpful Hints

Range Checks

Here is a quick method to detect values out of range within a dataset using arrays:

Data work.errors;
    * variables to be checked;
    Array checking age weight height;
    * lowest allowable values;
    Array low{3} (21 90 48);
    * highest allowable values;
    Array high{3} (95 300 84);
    Array erred{3} $6 ('Age' 'Weight' 'Height');
    Set work.A;
    Length flag $ 30;
    flag=' ';
    Do i=1 To Dim(checking);
        If .Z<checking{i}<low{i} or checking{i}>high{i} Then
            flag=Compress(flag||'+'||erred{i});
    End;
    If flag^=' ' then output work.errors;
Run;

Results

Please send your comments and suggestions about this web page to A. Watts (watts@bst.rochester.edu)