Good day. I have the following 2 data sets:   The first data set has 1000 variables with their values:   ID    Var1 ... Var1000 1        5             15 2        7             18 . . . 100   3              12   I also have the following data set with a list of variables:   Var_Name Var1 Var5 Var6 Var101 Var159 . . . Var987   Is there a way I can select the variables listed in the second data set from the first data set? ... View more

I have a data set as follows:   Date    Var1 Var2 Var3 Var 4 Var 5 .... Var3000 10/25   5        2       1                8                10/24 10/23 10/22 10/21   2       4        2                6                5 10/20 10/19 10/18 10/17   4       5        1       5       7   I would like to replace the missing values with the previous values across all 3000 variables. But I would like to replace then with the next value if there is no previous value (such as Var4 and Var3000). I have successfully replaced the missing values with the previous values with the following code:     data want; set have; array vars{*} _numeric_; array latest{3000} _temporary_; do i = 1 to dim(vars); if vars{i} > . then latest{i} = vars{i}; else vars{i} = latest{i}; end; run;   How can I also replace missing values with the following values that is not missing? Should I introduce another temporary array?  ... View more

I have a data set as follows:   Date    Var1 Var2 Var3 .... Var3000 10/25   5        2       1             8 10/24 10/23 10/22 10/21   2       4        2             6 10/20 10/19 10/18 10/17   4       5        1             7   I would like to replace the missing values with the previous values across all 3000 variables. I have successfully done it for one variable with the following code:     data want; set have; retain temp; if not missing(Var1) then temp = Var1; else Var1 = temp; drop temp; run;     Can one maybe do this in an array? ... View more