creating a new variable using existing variables

[Dhana18]

I have a data like this
				
PatientId 	Test A 	Test B	Test C 	Test D
1	0	1	1	0
2	0	0	0	1
3	0	1	0	0
4	1	0	0	1
5	1	1	1	0
6	0	0	0	1
7	1	1	0	0
8	0	0	0	1
9	0	1	1	0
10	0	0	0	1
11	0	1	0	0

I would like to know if patient is positive(1) in more than on test. how do i need to code?
Please help
			
          

[Patrick · Accepted solution]

With your data and assuming the Test.. variables are numeric and only have values of missing, 0 or 1 something like below should work.

data sample;
  infile datalines dlm=' ' truncover;
  input PatientId Test_A Test_B Test_C Test_D;
  outcome_flg= sum(of test_:) > 1;
  datalines;
1 0 1 1 0
2 0 0 0 1
3 0 1 0 0
4 1 0 0 1
5 1 1 1 0
6 0 0 0 1
7 1 1 0 0
8 0 0 0 1
9 0 1 1 0
10 0 0 0 1
11 0 1 0 0
;