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.
... View more