Date:         Wed, 12 May 2004 04:14:58 -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:      How to insert a date type to SQL server via SAS data step
Content-Type: text/plain; charset=ISO-8859-1

Hi,

Some body can help me to insert a data into MS SQl server 2000 by
using SAS data step

The following codes:

 proc sql;
        connect to odbc (dsn = fund);
        INSERT INTO sqlLib.Statistic(Statid, Statname, Fromdate, tildate)
VALUES(28,'Monthly Statistic january 2004','01jan2004'd,'31Jan2004'd);
        run;

Then I get error message on the log:

ERROR: Invalid date/time/datetime constant '31jan2004'd.

Any helps or hints would be appriciated.

Thanks in advance

- Loi -