I have a character field with length 3 in a data set. Some sample values are: 001, 234, 546,1, 25, 025. I am using tabulate to identify valid and invalid values in that field. The problem is that this code is not differentiating between the value 001 and 1 or between 25 and 025. proc format; value $code (notsorted) " " = "blank" "000"-"999" = "3 digits"; run; proc tabulate data=dataset1 missing; format code $code.; class code / preloadformat; table code, n / printmiss; run;
... View more
