I would like to ask if there is an example raw data : A 1 B 2 3 C 4 5 And now the goal is to output each Variable ( A,B,C) contains the last record, such as: A 1 B 3 C 5 How can I compute the data steps to make the missing variable ( e.g. the empty space below "B" ) also followed by the previous "B" and treat them as the same observation? And also how to compare between Variables to make them output different variable names? I have do some research that we can create the two variables for identify (A,B,C) by something call Var1 and Var2, then it can read the raw data record for Var1 and other variables from the same record. However, I feel confused with this method. Is there any ways to achieve the above mentioned goal? Thank you for your help.
... View more
