Requested operation denied. Index file WORK.TEMP_PRE.DATA is damaged

qwerty12 — Wed, 23 Aug 2023 12:36:41 GMT

proc sql;
	create table vda_mnr as
		select a.*,
			   b.poa1,
			   b.poa2,
			   b.poa3,
			   b.poa4,
			   b.poa5,
			   b.poa6,
			   b.poa7,
			   b.poa8,
			   b.poa9,
			   b.poa10,
			   b.poa11,
			   b.poa12,
			   b.poa13,
			   b.poa14,
			   b.poa15,
			   b.poa16,
			   b.poa17,
			   b.poa18,
			   b.poa19,
			   b.poa20,
			   c.clm_aud_nbr

			from sep.current_mnr_vardays a
			left join sep.ova_clmshdr_inp b
				on a.case_id=b.case_id
			left join sep.ip_confinement c
				on b.membersystemid=c.mbr_sys_id and
				   b.adm_dt=c.fst_srvc_dt

		where a.Low_Perdiems not in ('Y') and 
			  a.Med_Prime not in ('Y') and 
			  a.MH_BH_Flag in ('N') and 
			  a.Admits=1;
quit;

The file is getting damaged and i'm not able to move to further process, tried to split the above piece of code into 3 parts and ran but again same issue, and 50% of sas workspace is available can anyone suggest how to proceed with this piece of code

Re: Requested operation denied. Index file WORK.TEMP_PRE.DATA is damaged

JosvanderVelden — Wed, 23 Aug 2023 13:59:05 GMT

Can you verify if the issue is with the work location? For instance by using a temporary folder with enough space and run the code using a libname pointing to that temporary location.

topic Re: Requested operation denied. Index file WORK.TEMP_PRE.DATA is damaged in SAS Programming

Requested operation denied. Index file WORK.TEMP_PRE.DATA is damaged

Re: Requested operation denied. Index file WORK.TEMP_PRE.DATA is damaged