OK. I am using Proc Compare but I am just not getting the answer that I need. Here is my situation: I have two datasets: Dataset A and dataset B that are different. However, they have a column of data that is the same. There is a site variable that is the same between the two datasets. However, they have different lists of sites so not all of the sites listed in dataset A are listed in dataset B, and vice versa. They also have different variable between the two datasets, but they do share a site variable. We can call the shared site variable "Site X". Site X is listed as a format of $10 in both datasets. Site X is an odd text file composed of both letters and text. An example of Site X is FL0952MB. I want to match site X in both dataset A and B, but in a certain way. I want dataset A to stay the same but I want to know if any of the specific Site X sites from dataset B shows up in dataset A. I know it will for some of the records but I have datasets of over 1,000 records and I don't want to go through them by hand. So I want to generated a column of data in dataset A that is something like a 0 if that specific Site X is NOT in dataset B and a 1 if that specific site IS listed in dataset B. I am hoping to get an output like this for Dataset A where the "matched" column means that that specific site X was listed in dataset B: Site X matched FL0952MB 1 RL0989MG 1 IU0882RF 0 GR1752PO 0 YZ5632UY 1 Any help would be greatly appreciated.
... View more