Date:         Thu, 16 Mar 2006 12:40:16 -0800
Reply-To:     David L Cassell <davidlcassell@MSN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         David L Cassell <davidlcassell@MSN.COM>
Subject:      Re: SAS Append on Server
In-Reply-To:  <200603161805.k2GH9htD013255@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed

faiyazmehadi.momin@PHS.COM wrote:
>        I am trying to append a dataset which is a single row to the base
>dataset using ODBC connection. When I run the append or insert into ( in
>sql) using my test maching or PC it works fine. However when I use the
>same code to insert using SAS installed on the server, the SAS hungs up. I
>am using the ODBC connections to append the table.
>        In the code I first appends the data called task1 into a table
>called tasktable using ODBC connection (out3) as follows ,
>
>proc append base=out3.tblTask data=task1( rename=(last_Sasdate=
>AssignedDate)) force;
>run;
>
>However, when I use the same command to insert task2 SAS just hungup,
>
>proc append base=out3.tblComment data=task2( rename=(Recdate_ylsq=
>CommentDatetime)) force;
>run;
>
>The only thing I see is that I dont have SASUSER profile directory on my
>user folder. Does it have anything to do with the execution

This could be a lot of different things, so you're going to have to spend
some time working at the problem.

Do you have the permissions to change the remote data set?

Can you access the remote data set using ODBC and get, say, a print-out
of the first 50 observations?

Are you sure that the remote data set is set up so that FORCE will work?
FORCE does not make the data set accept any data set for appending.
If the DATA= data set has variables that the BASE= data set lacks, then
the append is not going to work.

Can you access the remote data set using any other method?  If so, can
you perform the append in that way?  If so, then the problem lies in
your ODBC connection and/or the privileges that your connection has been
granted.

What limits has the sysadmin placed on your ODBC access and your packet
sizes?


Okay, that should get you started.  If you cannot narrow down your
problems after going through these steps, then there are probably
another 50 things you can try...

HTH,
David
--
David L. Cassell
mathematical statistician
Design Pathways
3115 NW Norwood Pl.
Corvallis OR 97330

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/