PROC IMSTAT deleterows

strakenobody — Fri, 13 Mar 2020 09:59:37 GMT

Hi,
how to efficiently delete millions of records from the LASR table?

The goal is to load and append the incremental data (few millions of records) into the big table (bilions of records) on the LASR. Before appending (proc imstat with set statement), there is deleting:

proc sql noprint;
	select distinct(id) into :ids separated by ','
	from incremental_table;
quit;
		
PROC IMSTAT data=LASR_LIB.BIG_TABLE
	WHERE ID in (&ids.);
RUN;
	deleterows;
RUN;

But this statement finish with error:

ERROR: The length of the value of the macro variable ids (387453) exceeds the maximum length (65534).

Doing this in a loop does't make sense - the whole procedure takes hours.

What is the best practice to delete records from LASR table? Or generally to append incremental data? Maybe some merge option?

Regards.

Piotr

Re: PROC IMSTAT deleterows

strakenobody — Tue, 17 Mar 2020 07:32:21 GMT

Any advice? I spend several days on it and have no idea. I don't found any option to extend macro variable.

topic Re: PROC IMSTAT deleterows in SAS Programming

PROC IMSTAT deleterows

Re: PROC IMSTAT deleterows