There are of course several ways of doing, what to chose is based on your detailed requirement.
One way is to import the csv to a SAS data set, and then perform an inner join or WHERE x IN(subquery...) construct.
Another way is to again import the csv file, and then use it as a driver to a loop transformation, where you map you file contents to job parameters (which you can use as macro variables in the "inner" job).
Data never sleeps