Hello,
I need some help with setting up some SAS code to compare observations. I have over 100,000 observations with 26 variables. I have already read the data file into SAS and now it is stored as a SAS dataset. One particluar thing that I need to do is compare individual observations. I will be comparing these observations based on two variables:
Example of dataset
varibale 1 variable 2
ob1 "US1111112" "US1111224| US1111343 | US5554443"
ob2 "US1111113" "US1111113| US1111113 | US1111112"
ob3 ............ ................................
. . .
. . .
. . .
obsn ................. ................................
So I need check to see of variable 1 is located in variable 2 for obs1 in all 'n-1' observations. Then check obs2 variable 1 to see if it is variable 2 for all 'n-1' observations. Then check obsn ..... and so on. So in this example the variable 1 for obs1 is located in the variable 2 for obs2.
I am familiar with the use of arrays in java,c++, and other languages but SAS seems to be a little different. It is not apparent to me that SAS is capable of doing this in the regular DATA step alone. I greatly appreciate any help on this problem.