Dear all, I currently have a huge dataset which looks like this: Value 1 value 2 Value 3 Value 4 Value 5 OK OK NAME1 . OK OK OK NAME2 Value2 OK OK OK Value1 OK OK OK NAME2 . OK OK OK NAME3 Value3 OK OK OK NAME3 Value3 OK OK OK NAME1 Value1 OK OK OK NAME2 . OK ... ... ... ... ... OK OK NAME3 Value3 OK In the end I would like to have something like this: Value 1 value 2 Value 3 Value 4 Value 5 OK OK NAME1 Value1 OK OK OK NAME2 Value2 OK OK OK Value1 OK OK OK NAME2 Value2 OK OK OK NAME3 Value3 OK OK OK NAME3 Value3 OK OK OK NAME1 Value1 OK OK OK NAME2 Value2 OK ... ... ... ... ... OK OK NAME3 Value3 OK I'm currently struggling with the code for this: I have already the following datastep: data &outlib..&outdsn.; Set &outlib..&outdsn; if missing (value_4) and not missing (value_3) then do i=1 %to &vars_N.; do until (not missing(value_4)); but then nothing works further. Can anyone help me out? Thanks a lot in advance. Frederik
... View more