HI i have tried to change the below like this but its not giving any outut. Could you please check and suggest.
%macro bucketIT (inds,buckets,outdsFix); data Want; if 0 then set &inds; dcl hash h1(dataset:"&inds(obs=0)",ordered:'y'); h1.defineKey('id'); h1.defineData(all:'y'); h1.defineDone(); _full_buckets=mod(_nobs,&buckets); if _full_buckets=0 then _full_buckets=&buckets; _rows_in_full_buckets=ceil(_nobs/&buckets); _currow=1;
do _bucket =1 to &buckets;
do _point=_currow to (_currow + ifn(_bucket >_full_buckets,_rows_in_full_buckets-2,_rows_in_full_buckets-1,0)); set &inds nobs=_nobs point=_point; h1.add(); put _all_; end;
_currow= _point; Indicator = cats("&outdsFix",put(_bucket,f3.0)) ; /* i have added this indicator */ /* h1.output(dataset:cats("&outdsFix",put(_bucket,f3.0)));*/ h1.clear();
end;
stop;
run; %mend;
%bucketIT(week,5,d) %bucketIT(month,5,m)
... View more