Dear all,
I have a data set which contains a string variable specifying ranges of values. Some rows display the first and the last value of the range while others display a list of all possible values from the range, separated by a comma, like this:
Data have:
Var1
010-0100
020-050
010,025,048,061
Line by line, I would need to extract all possible values from the range to a different column, such as:
Data want:
Var1
010
020
030
040
050
060
070
080
090
0100
020
030
040
050
010
025
048
061
For ranges delimited by "-" the sequence increments always with a step of +10, e.g.: 010, 020, 030...
Can this transformation be achieved in SAS?
Many thanks.
... View more