I wrote SAS program and facing some difficulty, SAS code is given below Code description The objective of this SAS program is to obtain correct value of variable count in each iteration of macro final. In macro final there are some macro like %macro Boot_Perzentil1, %boot1, %boot_reml1, %boot_grenze1, together all these macros produce a single variable y and that value of y should be checked either < or > 2.49482 under the macro of %Boot_Perzentil1. I got all macros write but code below is not working correctly, every time I run this program get count is 0 even y < 2.49482 %if y < 2.49482 %then %do; %let count=% eval(&count+1); %Put count is &count; %end; %else %do; %let count=&count; %Put count is &count;  %end Plz help me                                           Complete SAS Code %macro final(sim);                                                                                                                                                                                                                                             %let count=0;                                                                                                                                                                                                                                                   %do rep= 1 %to 2;                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               %let D=&simdata&rep;                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   %macro Boot_Perzentil1(data,pat,b_reps);                                                                                                                                                                                                                                                                                                                                                                                                                 %do b_rep=1 %to &b_reps;                                                                                                                                                                                                                                        %put Boot &b_rep;                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   %boot1(&data,btest_1,9);                                                                                                                                                                                                                                        %boot_reml1(btest_1,outin_1,9,logAUC,logCmax,1);                                                                                                                                                                                                           %end;                                                                                                                                                                                                                                                                                                                                                                                          %boot_grenze1(outin_1,&b_reps);                                                                                                                                                                                                                             run;                                                                                                                                                                                                                                                      %if y < 2.49482 %then %do;                                                                                                                                                                                                                                   %let count=%eval(&count+1);                                                                                                                                                                                                                                     %Put count is &count;                                                                                                                                                                                                                                       %end;                                                                                                                                                                                                                                                           %else %do;                                                                                                                                                                                                                                                      %let count=&count;                                                                                                                                                                                                                                              %Put count is &count;  %end;                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   %mend;                                                                                                                                                                                                                                                         %Boot_Perzentil1(&D,9,1);                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              %end;                                                                                                                                                                                                                                                          %mend;                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          %final(want); ... View more

I have written following sas code it works fine DATA multiply;    answer = 0;    do i = 1 to 4;        answer=answer + 3; output; end; RUN; Proc print data= multiply; run; Output is                                      Obs    answer    i                                          1        3      1                                          2        6      2                                          3        9      3                                          4       12      4 But when i try to do this through macro i didn't work correctly I am using this macro code %macro Power; %let answer=0; %do i = 1 %to 5; %let answer=&answer+3; output; %end; %mend; it is not working and hence did not get same out as above Kindly help me in this regard %Power; ... View more

I wrote a program for bootstrap sample generation It works fine but It has one issue when I run that SAS program twice then newer bootstrap samples are merged with previously generated bootstrap samples in SAS output E.g, First I generated 100 bootstrap sample and calculated 95 percentile from it But when I again run that program then SAS out put show 200 bootstrap samples therefore 95 percentile is misleading in this case Please help me how to resolve this issue ... View more

I have a data set with three variables type x y type   x   y 1 12 13                                                                                                                                 1 14 15                                                                                                                                 1 12 13                                                                                                                                 2 14 25                                                                                                                                 2 15 26                                                                                                                                 2 26 23                                                                                                                                 3 25 26                                                                                                                                 3 26 35                                                                                                                                 3 36 38 if i want to have data set only for type 1 then I could use following code if type ne 1 then delete;                                                                                                                run; Now I want to do this using do loop, I mean that for first iteration I want data set for type 1 only, for second iteration I want data set for type 2 only and for third iteration I want data set for type 3 only so that i can have three separate data sets I am using following code that is not working do j=1 to 3;                                                                                                                            if type ne j then delete ;                                                                                                                 output; end; pls help ... View more