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.
Proc SQL Noprint ;
select name into :keeplist separated by ' '
;
Quit ;
Data Data_Set_2a ;
Set Data_set_2 ;
Keep &keeplist ;
Run ;
Richard
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.