Solved
Contributor
Posts: 44

# Subset significant confidence intervals

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.

Accepted Solutions
Solution
‎10-22-2014 10:47 PM
Super User
Posts: 23,776

## Re: Subset significant confidence intervals

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;

All Replies
Solution
‎10-22-2014 10:47 PM
Super User
Posts: 23,776

## Re: Subset significant confidence intervals

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;

Contributor
Posts: 44

## Re: Subset significant confidence intervals

Thank you, Reeza!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
• 2 replies
• 239 views
• 0 likes
• 2 in conversation