| Date: | Fri, 16 Jul 2004 10:40:06 -0700 |
|---|
| Reply-To: | Xin Zhang <xinzhang90@YAHOO.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Xin Zhang <xinzhang90@YAHOO.COM> |
|---|
| Organization: | http://groups.google.com |
|---|
| Subject: | Proc SQL - date conversion |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
I tried to retrieve data from MS SQL Server 2000 from SAS 8. I got
problems to convert date between SQL Server and SAS. sql_table is a
table in the my SQL Server database. One of columns is act_date with
datetime datatype. The value in the column is today's date
(7/16/2004)
LIBNAME d_live odbc dsn = live uid = xzhang password = xxxx
read_isolation_level=ru ;
proc sql noprint;
create table t_1 as
SELECT * FROM d_live.sql_table
where act_date = today();
quit;
How do I write this PROC SQL. Thanks.
Xin
| 
