How to Split Dataset By Number of Observations and Place in Macrovariables?

[novinosrin]

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?