SAS-L archives -- May 2004, week 2 (#24)

Date:	Mon, 10 May 2004 02:28:24 -0700
Reply-To:	Loi Tan Vo <loi.tan.vo@FNH.NO>
Sender:	"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:	Loi Tan Vo <loi.tan.vo@FNH.NO>
Organization:	http://groups.google.com
Subject:	Insert into MS SQL 2000 by using SAS
Content-Type:	text/plain; charset=ISO-8859-1

Hi all,

I have a odbc connecting to MS SQL server 2000 and want by using SAS data step to insert data into a table in MS SQL. For ex.

Proc sql; INSERT INTO sqllib.Table1(id, Name, Fromdate, tildate) VALUES(2,'statistic_1','01/01/2004'd,'31/01/2004'd); run;

Then I got the followings errors ERROR: Invalid date/time/datetime constant '01/01/2004'd ERROR: Invalid date/time/datetime constant '31/01/2004'd

How to convert datetime so that the ms sql can understand the datetime?

Thanks in advance

- Loi -