morinia
asked on
storing unque values from 15 columns and "x" rows in SAS
Experts,
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.
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.
Could provide examples to help better visualize what you have and trying to achieve?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Worked like a charm.