I'm creating a new variable test_result_all based on test_result_1, test_result_2, and test_result_3. Each variable contains 4 categories: positive, negative, indeterminate, and Not Done. For any positive result in the 3 variables, test_result_all='positive'. For any test result with negative but not positive, the result is negative. For all results with Not Done=Not Done. For all results with indeterminate=indeterminate. Otherwise (mixed between indeterminate and Not Done, or missing), it's missing. How should I code that? I was thinking of doing an if-then but it seems complicated to do it. I started the following but couldn't figure out what's next: if test_result_1='P' or test_result_2='P' or test_result_3='P' then test_result_all='P'; else if...
... View more