Just to add, I think what you are trying to achieve is to code your own array processing.  You can do this, per example 2 below, however the use of arrays would be a better idea - example 1: Example 1: data have;   array tot{4} 8.;   array perc{4} 8.;   tot{1}=6;   tot{2}=10;     tot{3}=8;   tot{4}=7;   do i=1 to 4;     if tot{i}=0 then perc{i}=0;     else perc{i}=tot{i} / 45;   end; run; Example 2: data have;   array tot{4} 8.;   array perc{4} 8.;   tot{1}=6;   tot{2}=10;     tot{3}=8;   tot{4}=7; run; %macro Do_Array (Var=, Num=);   %do var_num=1 %to &Num.;     %if &var.&var_num.=0 %then %do;       perc&var_num.=0;     %end;     %else %do;       perc&var_num.=&var.&var_num. / 45;     %end;   %end; %mend Do_Array; data want;   set have;   %do_Array (Var=tot,Num=4); run; ... View more

Hi, Apply a format comma10.; data want;   attrib b format=comma10.;   a=1234567;   b=a; run; ... View more

Thanks Jaap, I couldn't get your example working however.  I am using version 9.3 (not sure if that makes a difference), I copied and pasted and had the first set of errors regarding tmp not being on each row.  So I modified per: data want;   if (_n_=1) then do;tmp=prxparse('/rtf/');end;   set raw_base;   retain tmp;   if prxmatch(tmp,raw_base) then do;     tmp1=prxmatch(tmp,raw_base);     tmp2=prxposn(tmp,1,raw_base);   end; run; With the above, tmp1 is correct, only the first record has tmp1 not null and it is 3, where my string starts.  However tmp2 is always empty. ... View more

Hi, you are mixing SAS syntax and SQL there: case      when     remaining_months <= 1 then 'End'               when     Remaining_months <= 12 then 'End OP'               when     arrs not in '1' then 'Ars'               else       'Rege' end as Red_son The syntax is: case     when  [condition] then [result]                else [fallout response] end ... View more