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
Any advice? I spend several days on it and have no idea. I don't found any option to extend macro variable.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: