I'm having issues where if I try to run PROC SQL or PROC SORT involving a larger medical claims dataset (~15 GB). I work off a VPN and need to write my data to a remote file storage system. My code submits without error in the log, but will not update in my file libraries. For example, the code I have been using is proc sort data = lib.large_data; by ID Admit_date; run; and proc sql; create table lib.merge as select * from lib.small_data x left join lib.large_data y on x.ID = y.ID; quit; a file titled lib.large_data.sas7bdat.lck will be created in my folder, but will not update. What I mean by this is that the file size will initialize at 0-168KB and will not grow any larger, no matter how long I let the code run. I understand that SAS creates .lck files to prevent overwrites, but I'm not sure why this is happening. What is also strange to me is that the code I'm showing has worked previously. I started having this issue in the past week, but I have been using this exact code to do merges for a few months. If I use the PROC SQL statement: create table lib.merge as select * from lib.large data x where x.ID in (select y.ID from lib.small_data y); quit; then that allows me at least select correct records from the large dataset, but it's not ideal and I am still not able to sort the resulting dataset (~300 MB). I can run other PROC statements on these datasets just fine. I.e, PROC CONTENTS, PROC MEANS, PROC FREQ, all work, but I can't sort or merge. Does anyone have any idea why this is happening or how to resolve this issue? Any advice would be appreciated!
... View more