Good morning @JackoNewbie Yes and clear.
1
data PM1 PM2 PM3;
if _n_ le 10000 then output PM1;
else if _n_ le 20000 then output PM2;
else if _n_ le 30000 then output PM3;
run;
A very simple automation with a hash solution. But rather than split , can you have PM1-PM3 appended has one stack dataset?
Then instead of
proc sql;
create table getextrainfo as
select *
from tableheldwithextrainfo
where product_number in (&PM1, &PM2, &PM3)
;quit;
You could have a direct look up from tableheldwithextrainfo <-->PM1-PM3( one stack dataset) and result in matches. Is this idea ok?