Hi
if I have a data set like this:
data have;
infile datalines dlm=",";
length Test_place $100 Method $20;
input Test_place $ method $ capacity;
datalines;
Test place Toronto,Normal,599
Test place Toronto,Close contact,23
Test place Copenhagen,Normal,699
Test place Copenhagen,Close contact,23
Test Place Thisted,Normal,159
Test Place Thisted,Close contact,15
;
run;
Test center
Method
Capacity
Test center Toronto
Normal
599
Test center Toronto
close contact
23
Test Center Copenhagen
Normal
699
Test Center Copenhagen
close contact
23
Test Center Thisted
Normal
159
Test Center Thisted
close contact
500
I want to make two new datasets out of this dataset (I have more observations in the real one)
The first dataset should contain all test center who has capacity over 400, but the matching "close contact" center should follow with, even though it can have below 400.
The second dataset should only contain test centers below 400 and the matching close contact center should follow with IF the matching close contact is below 400.
How can I do these statements?
... View more