topic Re: "WHERE" statement into Proc GLM in SAS Procedures

"WHERE" statement into Proc GLM

jonatan_velarde — Wed, 27 May 2015 13:46:24 GMT

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

Re: "WHERE" statement into Proc GLM

AskoLötjönen — Wed, 27 May 2015 13:57:00 GMT

You can use where clause in data= -clause

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

Re: "WHERE" statement into Proc GLM

Astounding — Wed, 27 May 2015 14:00:15 GMT

To apply both boundaries:

where 100 < Polen_Gr < 250;

Re: "WHERE" statement into Proc GLM

Tom — Wed, 27 May 2015 14:02:24 GMT

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 ;