BookmarkSubscribeRSS Feed
yabwon
Amethyst | Level 16

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

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 0 replies
  • 250 views
  • 3 likes
  • 1 in conversation