Hello -I am attempting to compare a large number of numeric and character across multiple datasets. I have coded the numeric portion, but am looking for a way to include both character and numeric variables. In my code below, the &list includes only numeric variables. I imagine I could use a compare function for character, but I'm not sure on the best route to take. Here is my code: OPTIONS MPRINT SYMBOLGEN ; %MACRO DO_ALL(dsin1, dsin2, LIST ); %LOCAL i VAR ; %DO i=1 %TO %SYSFUNC(COUNTW(&list,%str( ))); %LET VAR=%SCAN(&LIST,&i,%str( )); PROC SQL; CREATE TABLE COMP_&VAR. AS SELECT DISTINCT A.id, A.&VAR AS &VAR._1, B.&VAR AS &var._2, (A.&VAR. - B.&VAR.) AS &VAR._DIFF FROM &dsin1. A INNER JOIN &dsin2. B ON A.id=B.id; QUIT; PROC SQL; CREATE TABLE CNT_&VAR AS SELECT "&VAR" AS VARIABLE, COUNT(&VAR._DIFF) AS TOTAL FROM COMP_&VAR. where &VAR._DIFF NE 0 ; QUIT; %end; %mend do_all; /**1st datasets for compare **/ %do_all(base,compare, numeric_var1 numeric_var2 numeric_var3 numeric_var4 numeric_var5 ) ; /**2nd datasets for compare **/ %do_all(base2,compare2, numeric_var1 numeric_var2 numeric_var3 numeric_var4 numeric_var5 ) ; I would like to include something like this for the character variables and possibly use a compare(with maybe conditionals to subset the type??) %do_all( base, compare, char1 char2 char3 char4 ) ;
... View more