Table

[Thalitacosta]

I have an "X" and "Y" database, in which they were supposed to be the same, but in "X there are more observations than in "Y". To better understand how observations over "X", I want to create a new database wich just those observations. Does anyone know the codes to do this?

[Rick_SAS · Accepted solution]

Are X and Y in different data sets? If so, I suggest you use PROC COMPARE to compare the variables. Here is an example:

data A;
do x = 1 to 10;
   output;
end;
run;

data B;
input x @@;
datalines;
1 2 3 4 6 5 
;

proc compare base=A(keep=x) compare=B(keep=x);
run;