Help using Base SAS procedures

MS Access query/deletion issues

Regular Contributor
Regular Contributor
Posts: 159

MS Access query/deletion issues

Hi all;

I have a general question regarding MS Access in respects to deletion/update queries-

When I attempt to delete multiple deletions or updates that are grouped (by a medical record number (mrn)  for example)-I cannot make one whole deletion query-

It results in an error that results in a rollback of the data. Instead I must create a macro that cycles through every MRN. When you have 4,000 of them-this becomes a huge timer killer.

Any suggestions on resolving this. Thank you.


Trusted Advisor
Posts: 2,125

Re: MS Access query/deletion issues

Are you using SAS to do the work in MS Access?  Assuming yes, perhaps you could share the code and the error message.  You could also go to the SAS/Access manual for your version of SAS and look at the diagnostics available to you so you can see exactly what SAS is passing to Microsoft Access.

Super User
Posts: 10,263

Re: MS Access query/deletion issues

Seems you violate the integrity rules in the Access database when you do the mass deletion/update. Or you run into too many pending operations before you "commit". I suggest to do the same operation (quasi-)manually in Access to determine when you run into obstacles.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 2 replies
  • 3 in conversation