Droping some variables from a data set

debdippal — Mon, 13 May 2013 07:31:03 GMT

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.

Re: Droping some variables from a data set

RichardinOz — Mon, 13 May 2013 07:57:02 GMT

Proc SQL Noprint ;

select name into :keeplist separated by ' '

;

Quit ;

Data Data_Set_2a ;

Set Data_set_2 ;

Keep &keeplist ;

Run ;

Richard

topic Droping some variables from a data set in SAS Programming

Droping some variables from a data set

Re: Droping some variables from a data set