Hi,

The data set data1 has 6 observations and 1 variable. The data set data2 has 50 observations and 3 variables.

I want to check how many observations in data1 are present also in columns of data2.

Example Data1 var1 1 2 3 4 5 6

data2 var2 1 2 8 9 33 ...

var3 0 7 16 78 301 ...

var4 3 5 6 66 134 ...

Result of the data step that I'm trying to get:

var2 contains 2 values of var1 var3 contains 0 values of var1 var4 contains 3 values of var1

Many thanks p.