Thank you for the quick reply sorry for not being more clear, I made an error in the example code, it was supposed to look like this: proc print data=Table.1; Where Unique_Identifier EQ "1"; run; proc print data=Table.1; Where Unique_Identifier EQ "2"; run; proc print data=Table.1; Where Unique_Identifier EQ "3"; run; The idea is that the second table contains many unique identifiers and I only want to print a subset of the data. My goal would be for the output table to simply print the contents of the rows in the second table with the Unique_Identifier value of 1,2 and 3. I am hoping to do this on a large data set where I know the values of ~35k unique identifiers and need to extract them from a second table that contains ~5million rows of unique identifiers. Hope that clarifies things
... View more