Hi all! I need a little help trouble shooting this program. basically, I need the ORD and SORD variables to populate with a number depending on the table name. I am currently getting all null values because the last table has zero obs (its a freq table). So I think I'm missing a loop or something so it's not overwriting?
For example, if table=A then ORD=1 and SORD=1;
If table=P then ORD=4 and SORD=14;
%macro freq (table,ord, sord);
data freqs ;
set allae (in=a) allsae (in=b) alldlt (in=c) anyae (in=d) anyteg3 (in=e) anyrte (in=f) anyg3rte (in=g) anysae (in=h) anyrsae (in=i) anyrsg3s (in=j)
anydlt (in=k) anydisc (in=l) anyinter (in=m) anyreduc (in=n) anyfaed (in=o) anyfrae (in=p);
by tx;
if &table then do;
ord=⩝
sord=&sord;
end;
run;
%mend freq;
%freq (a,1,1);
%freq (b,2,1);
%freq (c,3,1);
%freq (d,4,2);
%freq (e,4,3);
%freq (f,4,4);
%freq (g,4,5);
%freq (h,4,6);
%freq (i,4,7);
%freq (j,4,8);
%freq (k,4,9);
%freq (l,4,10);
%freq (m,4,11);
%freq (n,4,12);
%freq (o,4,13);
%freq (p,4,14);
Help is appreciated!!
... View more