storing unque values from 15 columns and "x" rows in SAS
Posted on 2014-03-25
I have pieces of this puzzle, but now to put it together.
I have a record that has error codes in colums ERR01 - ERR15 respectively, Each member can have multiple records and the codes can be repeated.
I have the number of records per member in the first column called "n". Does anyone know how in SAS I can loop through the table ERR01 - ERR15 and the respective rows and keep only distinct error codes and omitting blanks.