Hi there, I work in models risk development and i my team is having some problems in making a macro code to work properly. For example: In table 1 i have some contracts and their historical interest rates along their lifetime period:         the field: firstvalue    Identifies the first month of life of the contract; lastvalue     Identifies the last month of life of the contract; contador     identified the number of months in which the contract was alive; k                  enumerates each contract; from this table i construct table 2 (tab1 in the code below), which identifies the months in which there were changes in the interest rate of the contracts: From here, our goal is to calculate the median of the duration in months until a new repricing occurs, meaning that we want to obtain table3, in which the fields "contador_1, _2, _3" count the number of months that each contract mantained the same interest rate. The final step will then be the calculation of the median of these fields "contador_1, _2, _3" for each contract. The code we are using to obtain table 3 (tab2 in the code below) from table 2 (tab1 in the code below), is where we are having problems and it is the following: rsubmit; %macro teste1; %global first dif; data median.tab2; set median.tab1 ; %do i=1 %to 10; call symput('first',firstvalue); call symput('dif',dif_&i.); %put &i.; %put &first.; %put &dif.; %if (&i. >= %sysfunc(inputn(&first. ,best31.)) and %sysfunc(inputn(&dif.,best31.)) = 0 ) %then %do; contador_&j. = contador_&j. + 1; %end; %else %if (&i. >= %sysfunc(inputn(&first. ,best31.)) and %sysfunc(inputn(&dif.,best31.)) = 1 ) %then %do; %let j= %eval(&j.+1); %put condicao else if &j. ; contador_&j. = 1 ; %end; %else %do; %put condicao do &j. ; %put condicao do &i.; %end; %end; run; %mend teste1; %teste1; endrsubmit; this code seems right but it is not producing the results we want (there aren't any errors but the results are not correct). We think that the problems has something to do with "call symput" because we are having problems in defining the variables correctly.   Can you please help us understand what we are doing wrong in this code?  Thank you.   ... View more