topic Distance between two data set in SAS Programming

Distance between two data set

hwangnyc — Thu, 10 Nov 2016 13:45:43 GMT

Let's say I have two datasets. One has 3 variables name 1,2,3 and the other dataset has 6 variables named 1,2,3,4,5,6. Is there a quick way to compare both datasets and determine the variables that are different? In our example it would be 4,5,6.

Thanks!

Re: Distance between two data set

LinusH — Thu, 10 Nov 2016 13:51:31 GMT

Proc compare?

Re: Distance between two data set

PeterClemmensen — Thu, 10 Nov 2016 13:57:31 GMT

data one;
   input one two three;
   datalines;
   1 2 3
;

data other;
   input one two three four five six;
   datalines;
   1 2 3 4 5 6
;

proc compare base = one compare =  other NOVALUES LISTVAR;;
run;

gives you

Re: Distance between two data set

Loko — Thu, 10 Nov 2016 14:48:55 GMT

Hello,

%macro get_dif;
   %let op=%sysfunc(open(have));
   %let allvars=;
   %do i=1 %to  %sysfunc(attrn(&op,nvars));
      %let allvars=&allvars %sysfunc(varname(&op,%eval(&i)));
   %end;

%let op_C=%sysfunc(open(sashelp.class));
   %let not_common=;
   %do i=1 %to %sysfunc(attrn(&op_C,nvars));
      %let var_c=%sysfunc(varname(&op_C,%eval(&i)));
	  %if %sysfunc(find(&allvars,&var_c)) eq 0 %then
			%do;%let not_common=&not_common &var_c;%end;
   %end;
   %put %nrstr(&not_common)=&not_common;
%mend get_dif;
%get_dif