Subset significant confidence intervals

Accepted Solution Solved
Reply
Contributor
Posts: 44
Accepted Solution

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: 18,997

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;

View solution in original post


All Replies
Solution
‎10-22-2014 10:47 PM
Super User
Posts: 18,997

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
  • 226 views
  • 0 likes
  • 2 in conversation