Date: Tue, 10 Jul 2007 11:12:36 -0400
Reply-To: Dianne Rhodes <diannerhodes@COMCAST.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Dianne Rhodes <diannerhodes@COMCAST.NET>
Subject: Re: SAS to SQL Server - Error with Bulkload parameter
I thought I gave you a cogent response last week. Here it is reproduced
I don't know for SQL server, but for Oracle, the Oracle libname does not
support write. I suspect that is what is happening when you try to use
the libname to write from a datastep, as here:
>30 data mcapdb.mcos (dbtype=(label='char(30)'));
>31 set work.mcos;
What works for us is to use PROC APPEND with the BLKLOAD=YES option. Also
make sure that the SQL driver that bulkload uses is in the correct path.
You can also probably do this with PROC SQL.
Dianne @ BLS
I have a paper from SGF 2007 Access to RDBMS. You can find it here.
Also see Lois Levin's paper.