Subset significant confidence intervals

[TJ87]

Hello,

My dataset look like this:

VarA       VarB

a     1.50 (1.25, 2.00)

b     0.70 (0.50, 0.90)

c     0.85 (0.70, 1.30)

VarB is a risk ratio estimate and 95% confidence interval. I would like to subset the observations where the confidence interval excludes 1.00 (VarA = a and b in this example). Could someone please suggest a program to parse VarB and subset accordingly? Thank you.  

[Reeza · Accepted solution]

Untested:

data want;

set have;

*convert the lower/upper bounds to numbers;

lower=input(scan(varb, 1, "(),"), 8.2);

upper=input(scan(varb, 2, "(),"), 8.2);

*check if 1 is included;

if lower>1 or upper<1 then significant='Yes';

else significant='No';

run;

[TJ87]

Thank you, Reeza!