Droping some variables from a data set

[debdippal]

Suppose we have two data sets namely data_set_1 & data_set_2. Now some variables are present in data_set_2 which are not belonging to data_set_1. Now our aim is to remove those variables from data_set_2 which are not belonging to data_set_1.

Now I am giving the description of the data sets.

Data_set_1

Name          val_1     val_2

forum           10            15

quiz                 5            14

assign            14             8

Data_set_2

class      user forum   dq   assign quiz

1              1            5         2 4           1

1              2            6         3        2          5

Some variables like class, user, dq are not belonging to data_set_1. So we have to drop this variable from data_set_2. One more thing we should keep in mind that variables in data_set_1 are in row format where as variables in data_set_2 are in column format. We do not want to use any transpose statement. 

[RichardinOz]

Proc SQL Noprint ;

     select name into :keeplist separated by ' '

     ;

Quit ;

Data Data_Set_2a ;

     Set Data_set_2 ;

     Keep &keeplist ;

Run ;

Richard