Hi All, I am having issue while subsetting a dataset using Macro. here is my code : %macro dt (value); data raw_new; set raw; where index(score, "&value"); %dt(apple_1); %dt(orange_2); run; From Raw data set I want to create raw_new data set. Variable score has 1000 values and I want to keep only those values which contains "apple_1" and "orange_2". Every time I run this code, I get only values with orange_2 in my dataset. apple_1 does not get appended to orange_2. Could you please suggest what I'm doing wrong. Thank You! ... View more