Hi, The way you have presanted your query, possible solution is as follow...I hope this works... In this example, i have created dataset containing households with sales and units...that is table_A contains hhd,sales and units for one period and table_B contains hhd,sales and units for second period...and compare both period households and assign your mentioned conditions...In my code, HHD is unique key in both the datasets... data table_A;    input hhd $ sales units;    cards; A 10 4 B 20 5 C 30 2 D 40 3 F 60 1 ; data table_B;    input hhd $ sales units;    cards; A 10 4 B 20 5 C 30 2 D 40 3 E 50 4 D 60 . ; proc sort data = table_A;    by hhd; run; proc sort data = table_B;    by hhd; run; %macro compare; proc contents data = table_A out = list_A(keep = name) noprint; run; proc contents data = table_B out = list_B(keep = name) noprint; run; proc sql noprint;   select count(name) into :count_A   from list_A;   select count(name) into :count_B   from list_B;   select name into :name_A separated by " "   from list_A;   select name into :name_B separated by " "   from list_B; quit; proc datasets nolist;    modify table_B;    rename %do i = 1 %to &count_B.;               %scan(&name_B.,&i.) = %scan(&name_B.,&i.)_Y2     %end;; quit; proc datasets nolist;    modify table_A;    rename %do i = 1 %to &count_A.;               %scan(&name_A.,&i.) = %scan(&name_A.,&i.)_Y1     %end;; quit; data both(drop = _temp: in_A in_B);    retain hhd sales_Y1 units_Y1 sales_Y2 units_Y2 item;    length item $10.;    merge table_A(in = a rename = (hhd_Y1 = hhd))          table_B(in = b rename = (hhd_Y2 = hhd));    by hhd;    in_A = a;    in_B = b;    %do i = 2 %to &count_B.;        _temp&i. = %scan(&name_B.,&i.)_Y2 - %scan(&name_A.,&i.)_Y1;     if (in_A = 1 and in_B = 1) and _temp&i. = 0 then item = "Equal";     if in_a = 0 and in_B = 1 then item = "New";     if in_a = 1 and in_B = 0 then item = "Deleted";     if (in_a = 1 and in_B = 1) and (_temp&i. NE 0 or _temp&i. = .) then item = "Updated";    %end; run; %mend; %compare; -Urvish ... View more

Proc Sort data = test;      by measurement_Y exp; run; I think it is simple or i am not to understand your requirement... -Urvish ... View more

Hi, I have prepared one SAS Code for it...It is saved in my laptop...but what i can suggest you ri8 nw is like you can directly see the execution time by using following code... %let o_time = %sysfunc(datetime()); /*--------------------------------------*/ YOUR SAS PROGRAMME /*--------------------------------------*/ %let n_time = %sysfunc(datetime()); /*calculation of Total Execution Time*/ %let diff_T = %sysevalf(&n_time - &o_time); %put "Total Execution Time is:"; %put "Total Execution Time"      %sysfunc(putn(%sysevalf(&n_time - &o_time), time8.)); -Urvish ... View more

Try following macro...I am not sure about your requirement...like you said you whould like to compare all possible pairs of two values...It means that you want to have comparision of all the observations...If it is like that than try following code... %macro test;           %do i = 1 %to 2; /*I take stop value based on your unique ID values*/          data test;            set test;            _diff_var_&i. = dif(var&i.);          run;      %end; %mend; %test This will compare just observations for all the variables... Again it will be good if you can post your output which you want to have... -Urvish ... View more

Can you please post the sample output you want...In your Question you want pairwise differences within each ID... Can you please define pairwise differences ??? ... View more

Try with Proc Logistic as follow... Proc Logistic data = cool descending;        model a1 = a2 / DEVIANCE LACKFIT; quit; If you want to predict the probability of success based on catogrical response variable then i think Proc Logistic is best to use, you dont need to specify BINOMIAL option on MODEL statement... -Urvish ... View more

Try the following code...I have not tested the following code but should meet your requirement... %Macro invoke;               %GetFundData (2,%do i = 1 %to 13;                                           mfFunds&i,VDate&i.,                                   %end;                                          mfFunds14,VDates14); %mend; %invoke; You can create the macro variables in your macro definition itself rather than reference them as parameter... -Urvish ... View more