This worked PERFECTLY. Thank you!!! Another quick question--since my main concern is having to "list" all the variable names of my dataset in the array, is it possible to "index" which variable names to include or to indicate a range (e.g., home to heat, so all the variables between home and heat are included, inclusively)? ... View more

Just saw this. I will definitely try this out soon! Thank you! ... View more

After examining the output more carefully, I see that it's setting all the missing values to 0. How can I fix this?   Desired:   What I'm getting:   Thanks so much for all your help. ... View more

Hi Reeza,   Not sure if I completely understand the usage of whichn despite reading some documentation about it, but this code does not yield the same results as the if-then-else statement.   data work.test2; set work.test; array areverse {9} v1 v2 v3 v4 v5 v6 v7 v8 v9; test_var = whichn(0, of areverse{*}); run; ... View more

Thanks for all the replies, everyone! I can get the desired output if I use if-then-else statements, but my main concern is: What if I have a lot of variables in my dataset? This is my if-then-else statement. How can I do this more efficiently when I have many more variables?   data work.test2; set work.test; if v1 = 0 then test = 1; else if v2 = 0 then test = 2; else if v3 = 0 then test = 3; else if v4 = 0 then test = 4; else if v5 = 0 then test = 5; else if v6 = 0 then test = 6; else if v7 = 0 then test = 7; else if v8 = 0 then test = 8; else if v9 = 0 then test = 9; run; ... View more

Okay, another attempt (my apologies, I'm just trying to find a way to do this in SAS--need to do this for future projects, as the company only uses SAS :-P)   Total of 9 columns: x1 to x9.   Search through all the values of x1, row by row. If the value in row 9 is 0, then test_var in row 9 will be 0 and missing on the previous 8.   Then, search through all the values of x2, x3, etc., row by row, conditioned on the fact that the corresponding row of x1 is NOT 0 AND the value of x2, x3, etc. is 0. Same idea as above, basically.     I think you alluded that you can do this in SAS IML? I have access to that, too. Thanks!   ... View more

Thank you for clarifying that for me. It's hard to switch from R to SAS, haha! Essentially, I have 9 elements of an array. I want to first check if the first element ("variable") of the array is equal 0; if it is, then test_var will get the value 1. Then, I wish to iterate through the other elements of the array ("variables") and check whether the values of each variable is equal to 0. If the condition is met, the test_var gets assigned the number corresponding to the variable's index in the array; otherwise it should be missing. test_var also does not change after each iteration (if the condition has already been met). If test_var = 2, it will stay that way. test_var will basically be missing until the "variable" satisfies the condition. x2 test_var 1 . 2 . 0 2 1 . 2 . x3 test_var 1 . 0 3 2 2 1 . 2 . Repeat for x4, x5, etc. ... View more

Hi Reeza,   Thank you for the reply. So, currently, I've written a do-statement and want to iterate through the elements of the array, comparing the values of, say, the second element in the array, to the first and assign a new variable something if that condition is satisfied. So, for example,   Column 1    Column 2 1                  12 2                  13 3                  14 4                  15     If the first entry of column 2 (12) is equal to the first entry of column 1 (1), then test_var = something. Then, skip to the next entry of column 2 and compare it to the next entry of column 1, etc.    Thanks again! I hope what I'm asking is clear. This is my code (it's wrong): data work.test2; set work.test; array areverse {9} x1 x2 x3 x4 x5 x6 x7 x8 x9; if (areverse[1] = 0) then test_var = 1; do i=1 to 8; if (areverse[1] > 0 and areverse[i+1] = 0) then test_var = i+1; end; run; ... View more