05-13-2013 03:31 AM
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.
Name val_1 val_2
forum 10 15
quiz 5 14
assign 14 8
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.