I'm am trying to categorize multiple diagnostic fields (diag1-diag12) across thousands of individuals (id, by row) according to 3 categories (A=always, S=Sometimes, N=Never). The final dataset should have a diagnostic category (dcat1-12) corresponding to each diagnostic field (diag1-12). I've tried to adapt test scoring code found in "Get it together: Combining data with SAS MERGE, UPDATE, and SET" by Mel Widawski with some progress, but not the end result that I'm needing. Here's an abbreviated example of the data I'm working with: Have 1: Main Data data have1 (label='Main'); input id:1. diag1: $7. diag2:$7. diag3:$7. diag4:$7.; datalines; 1 S61131S S320 S32000B S32000B 2 S320 S320 S320 S320 3 S32000B S9702 S320 S61131S 4 S9702 . . . ; run; Have 2: Scoring Data data have2 (label='scoring'); input icd:$7. category:$1.; datalines; S61131S S S320 N S32000B A S9702 N ; run; Want: Scored Data data want (label='scored'); input id:1. diag1: $7. diag2:$7. diag3:$7. diag4:$7. dcat1:$1. dcat2:$1. dcat3:$1. dcat4:$1.; datalines; 1 S61131S S320 S32000B S32000B S N A A 2 S320 S320 S320 S320 N N N N 3 S32000B S9702 S320 S61131S A N N S 4 S9702 . . . N . . . ; run; I'd appreciate any guidance!
... View more