I'm having difficulty with a pretty easy procedure. I'm trying to get the number of records based on groups (O, IV and Combination of O+IV). I have the following data. data have;
infile datalines delimiter=",";
input ID, recordkey, route $;
datalines;
1,1,IV
1,2,IV
1,3,IV
2,4,O
2,5,IV
2,6,IV
3,7,O
3,8,O
; How would I get a count of unique IDs that are O alone, IV alone and combination of O and IV? I want to get the following results: Oral=1 IV=1 Combo=1
... View more