Hi SAS-C,
Just FYI, the macroArray package [ver. 1.3.0] is available in SASPAC now.
Changes:
- Four new parameters in the
%do_over() macro: check, rephrase, trigger, and unq. See "Details" section below.
- Minor updates in the
%array() macro.
- Documentation updated and refreshed.
For detailed description of changes see releases notes.
A "sneak-peak" example:
/*
%loadPackage(macroArray)
*/
/* macro array V with variables names list */
%array(V[4] ("a" "b" "c" "d"), macarray=Y)
/* test data sets*/
data test;
array x{*} %do_over(V) (1:&VN.);
run;
/* use %do_over for quick rename */
proc datasets nolist noprint lib=work;
modify test12;
rename
%do_over(V,rephrase = ?=new_?) /* e.g., a=a_new */
;
run;
quit;
data _null_;
set test;
put _ALL_;
run;
All the best
Bart