Confidence interval

[maonome]

I am work with a large amount of data and am trying to isolate the values that are outside the range of the confidence interval. But I am only getting values that are above the upper "line" and not below the lower "line". Would really appreciate any help.


upper=UCL lower=LCL, logW = log of the weight, logL = log of the length

proc print data=bpout;
by species;
where logW<upper;
where logL>lower;
run;

 

[ChrisW75]

Try this:-

proc print data=bpout;
by species;
where logW<upper AND logL>lower;
run;

I'd think if you do two WHERE statements, only the last one gets evaluated...

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.