topic Re: Subset significant confidence intervals in SAS Programming

Subset significant confidence intervals

TJ87 — Thu, 23 Oct 2014 01:22:19 GMT

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.

Re: Subset significant confidence intervals

Reeza — Thu, 23 Oct 2014 02:47:33 GMT

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;

Re: Subset significant confidence intervals

TJ87 — Thu, 23 Oct 2014 15:50:48 GMT

Thank you, Reeza!