LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (May 2004, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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>
Subject:      How to insert a date type to SQL server via SAS data step
Content-Type: text/plain; charset=ISO-8859-1


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 -

Back to: Top of message | Previous page | Main SAS-L page