BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
hwangnyc
Quartz | Level 8

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!

1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20
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

 

COMPARE.PNG

View solution in original post

3 REPLIES 3
LinusH
Tourmaline | Level 20
Proc compare?
Data never sleeps
PeterClemmensen
Tourmaline | Level 20
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

 

COMPARE.PNG

Loko
Barite | Level 11

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1754 views
  • 4 likes
  • 4 in conversation