Dear SAS-L-ers,

David Kellerman posted the following:

> I am updating a remote access database using the PROC SQL and EXECUTE > statements below. > > %MACRO SENT(TBNAME); > > EXECUTE (UPDATE %STR(&)TBNAME SET SENT=1 WHERE MRN=999999999 AND DOV= > #03/28/2007 # AND FORM=23 ) BY PATH %STR(;) > > %MEND; > > %MACRO UPD(DBNAME,TBNAME); > > PROC SQL FEEDBACK PRINT; > > CONNECT TO ACCESS AS PATH (PATH="&PATH\&DBNAME") ; > > %SENT(&TBNAME); > > DISCONNECT from PATH; > > %MEND; > > %UPD(Master09.MDB,MED) > > > > The process works but does not appear to complete, actually appears to > hang > upon attempting completion. The SAS session says "PROC SQL running" > and > does so until I cancel executing statements. I have tried the PROC SQL > options FEEDBACK and PRINT but get no listing in the log. > > I know that there is a return code sent for each execute statement (I > only > showed 1, there are several thousand), but I can't seem to get that > trace > working. Ideally I would like to see in the log the execute statement > followed by "RECORD UPDATED" or something of the sort. This might give > me > an idea why the hang at the end. > > Any suggestions will be gratefully attempted. Thanks to all in > advance. > David, in addition to Joe's good advice, you might want to check out the SASTRACE option. That allows you to get information on what the DBMS is actually doing to process SAS-to-DBMS code you submit. You can find a write-up in the online SAS documentation:

http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003072985.htm

...and in other SAS online documentation; if you search.

David, best of luck in all your SAS endeavors!

I hope that this suggestion proves helpful now, and in the future!

Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Michael A. Raithel "The man who wrote the book on performance" E-mail: MichaelRaithel@westat.com

SAS Press Author Page: http://support.sas.com/publishing/authors/raithel.html

Author: Tuning SAS Applications in the MVS Environment

Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=58172

Author: The Complete Guide to SAS Indexes http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ The degree of normality in a database is inversely proportional to that of its DBA. - Anonymous +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++