Hi, I have searched far and wide and haven't been able to find an answer to the following: I am curious on whether SAS has the capability to report directly, what format or informat is best suited for a set of values within some categories. For instance: Let's say we have a categorical variable TEST that contains a number of values, e.g. "TEST1" "TEST2" "TEST3". Furthermore, we have a character variable, RESULT, that contains a number of associated values, that can either be character or numeric (float or integer), e.g. TEST | RESULT TEST1 | UNKNOWN TEST2 | 10.411 TEST3 | 1 TEST1 | 10.1 TEST2 | 10.334 TEST3 | 11 For the TESTs I would like to find the best format matching the values in RESULT, is there a way to report that, so that e.g. best format for TEST1 = character with length 7 TEST2 = float with length 6.3 TEST3 = integer ?
... View more