Hi Tom, thanks so much! The SUBNUM list isn't very long (less than 15 unique), it's the dataset list that's long. There's 85 datasets and I'm concerned that having this code for 85 datasets would be a strain. Also, it took me a bit but I figured out that my data thinks the SUBNUM are char (oops). Thanks for your continued support! data XL.dataset1 ;
set ABC.dataset1 ;
where subnum in (123 456);
run; Jenn PS I loved the idea for the let subnum_list, it worked like a charm! %let subnum_list=123 456 ;
... View more