Date:         Tue, 11 Dec 2001 13:28:04 +0100
Reply-To:     Jesus Bermudez <jbermudez@SFP.CIFL.CESGA.ES>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jesus Bermudez <jbermudez@SFP.CIFL.CESGA.ES>
Subject:      SQL in SAS and WHERE statements with datatime
Content-Type: text/plain; charset=ISO-8859-1

hello,

    We are working with SAS System V8 and we want to filter the data(into SQL sentence) of a data base, so that we have a table with the following data of the variable "datarecollida":
19nov1999:00:00:00'; '8jun2000:00:00:00'....
We are using WHERE statement, but we do not know the syntax for several data, i.e., we proved with <, >, in, between... but we were not able to filter the data.
The format of the data is '14#apr#1999:00:00:00'dt.
The code that we use (without WHERE statement) is the following:

/*GRAFICAS DE LONG/PARCELA*/
proc sql;
connect to ODBC as granell (dsn='granell' );
create table agullas1 as
    select * from connection to granell
        (select novaclav,datarecollida,idade,posicion,lonxitude,id,especie
from rrodriguez.cont_agullas_lonx);
run;
quit;

Any input will be really welcome. Thanks indeed

Jesus Bermudez Garcia

Lourizán Forestry Investigations Center