"WHERE" statement into Proc GLM

[jonatan_velarde]

Hi my friends:

I have one question, as always haha:

I have many data to use into Proc GLM, and i need to exclude some data (Discrepant data) from the tail and head, so im trying to use WHERE statement like that:

Proc GLM:

Where Polen_Gr < 250; (meaning that i'm gonna use just data under 250)

And i would like to Add that i want to use data above 100 and i dont know how to do it

Resuming: I JUST NEED the interval "X"

100>X>250

Thanks

[AskoLötjönen]

You can use where clause in data= -clause

Proc Glm data=have(where=(Polen_gr lt 250));

[Astounding]

To apply both boundaries:

where 100 < Polen_Gr < 250;

[Tom · Accepted solution]

Did you try what you posted?

These three different methods should all do the same thing.

where 100 < Polen_Gr < 250 ;

where (100 < Polen_Gr ) and (Polen_Gr < 250) ;

where 100 < Polen_Gr ;

where also Polen_Gr < 250 ;