Link to home
Start Free TrialLog in
Avatar of morinia
moriniaFlag for United States of America

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.
Avatar of Aloysius Low
Aloysius Low
Flag of Singapore image

Could provide examples to help better visualize what you have and trying to achieve?
ASKER CERTIFIED SOLUTION
Avatar of theartfuldazzler
theartfuldazzler
Flag of South Africa image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of morinia

ASKER

Worked like a charm.