| Date: | Fri, 31 Oct 2008 16:29:55 -0400 |
| Reply-To: | Rieza Soelaeman <rsoelaeman@GMAIL.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | Rieza Soelaeman <rsoelaeman@GMAIL.COM> |
| Subject: | Re: Using where clause to select for range |
|
| In-Reply-To: | <200810312028.m9VAl549023605@malibu.cc.uga.edu> |
| Content-Type: | text/plain; charset=ISO-8859-1 |
Ok, so THAT was the problem. I was sure it was formatted as a date,
apparently it's not numeric. Thanks, Ya and everyone!
RHS
On Fri, Oct 31, 2008 at 4:28 PM, Ya Huang <ya.huang@amylin.com> wrote:
> It should work. Are you sure your variable year is numeric?
> If it's a character var, you should use:
>
> '1991'<= year <='2001'
>
> On Fri, 31 Oct 2008 16:14:08 -0400, Rieza Soelaeman <rsoelaeman@GMAIL.COM>
> wrote:
>
> >Hello everyone,
> >Just wondering how I can use the where clause to select for a range of
> >years. For example, I want SAS to run the procedure only on observations
> >from 1991-2001. I tried where 1991<= year <=2001; but that doesn't work
> >:(. I really don't want to have to do where year in
> >(1991,1992,1993,1994,1995,etc.); because the just seems tedious.
> >
> >Thanks!
> >RHS
>
|