Posted 09-04-2023 05:51 PM (3182 views) | In reply to twildone
This error is typically caused by another SAS tool or process having the SAS dataset open. Do you by any chance have this table open in a view-type window in SAS EG, SAS Studio or SAS Windowing System. If so you need to close it.
Pyrite | Level 9
Re: re: Error Message
Posted 09-04-2023 06:40 PM (3172 views) | In reply to SASKiwi
Hi SASKiwi. I run the code in SAS Enterprise and have been running the same code many times before. When I reboot it seems that dataset where a lock is not available for WORK changes. From the log, this error occurs during the process of deleting the datasets. Thanks
2748 proc datasets nolist; 2749 delete PostalCodesCorrections AddressList AddressList1 AddressList2 AddressList3 AddressList4 AddressList5 AddressList6 2749 ! AddressList7 AddressList8 CoRequisite AddressList9 AddressList10 ; NOTE: Deleting WORK.POSTALCODESCORRECTIONS (memtype=DATA). NOTE: Deleting WORK.ADDRESSLIST (memtype=DATA). NOTE: Deleting WORK.ADDRESSLIST1 (memtype=DATA). NOTE: Deleting WORK.ADDRESSLIST2 (memtype=DATA). NOTE: Deleting WORK.ADDRESSLIST3 (memtype=DATA). NOTE: Deleting WORK.ADDRESSLIST4 (memtype=DATA). NOTE: Deleting WORK.ADDRESSLIST5 (memtype=DATA). NOTE: Deleting WORK.ADDRESSLIST6 (memtype=DATA). NOTE: Deleting WORK.ADDRESSLIST7 (memtype=DATA). NOTE: Deleting WORK.ADDRESSLIST8 (memtype=DATA). NOTE: Deleting WORK.COREQUISITE (memtype=DATA). NOTE: Deleting WORK.ADDRESSLIST9 (memtype=DATA). NOTE: Deleting WORK.ADDRESSLIST10 (memtype=DATA). ERROR: A lock is not available for WORK.ADDRESSLIST10.DATA.