Hello, Hope someone can help me out. I have a dataset where someone can complete 2 or 3 forms (e.g., form A, form B & form C). I want a count of someone in Form A only, Form B only and Form C only and those who filled more than 1 form (mult_form). If they complete form A and form B, they should be counted as mult_form. For example, ID 102 & 104 to be counted as multi_form. Here is my dummy data. data dummy; input id$ 1-3 FormA FormB FormC ; infile datalines ; datalines; 101 1 0 . 101 . 0 . 102 1 0 . 102 . 1 . 103 . . 0 103 . . 1 104 1 0 . 104 . . 1 105 . 1 . ; ; run; Thanks in advance.
... View more