Get the values from another dataset column values

[sathya66]

Hi All,

Need to run query based on another dataset column values.

Like

data a;

set b;

if column_1= 'm' then delete ;

if column_1= 'nn' then clumn_1=plus ;

so  values(m,nn,etc) are in another X data set

[PaigeMiller]

Please show us examples of the datasets involved. A small portion of each data set ought to be sufficient. Please provide the data sets as DATA step code, as explained in these instructions. Do not provide the data as screen captures or attachments.

Also please explain how we know what these steps should be, given the two data sets, especially the part of the code after THEN

if column_1= 'm' then delete ;
if column_1= 'nn' then clumn_1=plus ;