| 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
|
