I have a character column containing comma-separated numbers, and the list of numbers is of varying length. For example, ColumnName 72,748 980 37449,37451,37452,37453,37454 70286,70287,70288,70290,70291,70292,70293 .... I am trying to parse ColumnName by putting each number in a separate column. To illustrate, Parse1 Parse2 Parse3 Parse4 72 748 980 37449 37451 37452 37453 ...... 70286 70287 70288 70290 ...... In a DATA step, I am parsing the comma separated values using the SCAN function. data b; set a; parse1 = scan(ColumnName, 1, ","); parse2 = scan(ColumnName, 2, ","); ... run; However, I do not know the maximum number of values in the list. So I don't know how many parseN variables to define. Is there a function that can read the list of values in each record and return the max number of values for all the records? Thank you. Dhrumil Patel
... View more