Hi Juli4, Your code does match the solution, and to double check I copied your code, ran it and I did get the correct results.  There could be an issue with the input table.   Did you see the following NOTE in your log? NOTE: There were 384 observations read from the data set PG2.NP_MONTHLYTRAFFIC. WHERE ParkName='Cuyahoga Valley NP'; Thank you Mary ... View more

Hi SASAna, The below program looks for the values  1234,2345,4567,8903 in the column Code.  The first Data Step creates the test data set. Let me know if I have misunderstood your question.   Thanks Mary   data new; input code $; datalines; 1234 2345 4567 5464 8903 2090 1234 1234 ; run; %let procs=1234,2345,4567,8903;   data find;  set new;  do i= 1 to 4;    if code=trim(scan("&procs",i,',')) then output;  end; run; ... View more