looking for help for a simple macro code

shiyiming

%macro pct;
%do i=0 %to 1 %by 0.1 ;
data diff;
  pp=&i.;
run;
%end;
%mend;
%pct

I am trying to get a dataset diff with a row value of pp , however, it gave me error message as displayed below, and  wonder anyone could help.

ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was:
       0.1
ERROR: The %BY value of the %DO I loop is invalid.

thx a lot!!!!

shiyiming

[code:13qs2m3k]%macro pct;
    %let i=0;
    %let i=%sysevalf(&i+0.1);
    %do %until(&i gt 1);
        data diff;
            pp=&i.;
        run;
        %let i=%sysevalf(&i+0.1);
    %end;
%mend;
%pct[/code:13qs2m3k]

shiyiming

nice.
but still confused, why SAS treats &i as a character value(pp=&i) in the %do loop?
when we use do loop i.e. i=0 to 10, i was treated as a numeric value.

thx!

shiyiming

语法要求----%by 后面必须是整数。而你用的是小数，所以报错。
解决方法：将等差数列标准化成整数后，方可用%do %to %by。