Hi SAS Expert!

If I have a variable (var1) with large number of observations(n), how can I get var1(n) when I want to use it in the program?

I have a dataset with the following variables: var1 var2 var3 C A A1 A2 A3 1 1 2 1 99 1 1 2 2 101 1 6 3 2 95 2 3 1 1 80 2 2 4 3 85 2 2 2 1 90 . . . the value for A1 A2 and A3 are all missing and I need to recover the missing value from the information I have about var1 var2 var3 C and A. A1 is related to the value"1" in variable "C" and A2 is related to the value "2" in variable "C" adn A3 is related to the value "3" in variable "C".

if var1(i) =var1(j), var2(i)=var2(j) and var3(i)=var3(j), where i, j are the ith and jth observation of the variables, then A(C)=A, where C is the value of the variable "C" for both i and j observation.

So it would be great if I know how to let the program know when I want the value of var(i).

Thank you very much!

Ying Zhao

Sent via Deja.com http://www.deja.com/ Before you buy.