I am running into some issues using a macro code-I want to count/summing the number of variables in a list for an entire dataset. Say for instance my dataset looks like the following: ID Factors 123 A3, A4, A5 233 A3 451 A4, A5, F5 567 F5 112 A1 344 A3, A5 557 A4 My goal is to create one large variable list (A3, A4, A5, A3, A4, A5, F5, F5, A1, A3, A5, A4) to then count the frequency of each factor (I know it will not total 100% since more than one attribute can be reported per ID) to get this: Factor Value A1 1 A3 3 A4 3 A5 3 F5 2 Any help would be greatly appreciated.
... View more