>I have my macro to change variables, and i want to do one data set which include this changed variables,
How about something like this:
data _null_;
set ZM_: (obs=1) indsname=INDS; * get all the table names;
if INDS ne lag(INDS) ; * one process by table ;
VAR=substr(INDS,8); * remove WORK.ZM_ to find the variable name; * extract the analysis variable nane;
call execute(' proc means data='||INDS||' nway; id INDS ; out=SUM q1=q1 q2=q2 q3=q3; var ' || VAR
||';proc append data=SUM base=WANT; run;'); * run statistics;
run;
I suspect the 1000 tables are created from a process that could easily create less of a messy output.
... View more