About Author

Leonid Batkhan

Leonid Batkhan is a long-time SAS consultant and blogger. Currently, he is a Lead Applications Developer at F.N.B. Corporation. He holds a Ph.D. in Computer Science and Automatic Control Systems and has been a SAS user for more than 25 years. From 1995 to 2021 he worked as a Data Management and Business Intelligence consultant at SAS Institute. During his career, Leonid has successfully implemented dozens of SAS applications and projects in various industries. All posts by Leonid Batkhan >>>


  1. Hi,
    macro works like a charm. Maybe it'd be useful to add some lines to check, whether child and parent user, respectively, exist at all in metadate.
    Right now, the code runs without errors / warnings / notes, etc. even, if one of the two necessary users do not even exist!


  2. This is such a great solution to a common problem that many of us are familiar with. It's great to see that there is a way to automate this process and make it much easier for SAS administrators. Do you think this process could be used for other tasks as well?

  3. Hi Leonid,

    Another great programmatic SAS metadata post!

    If SAS admins are looking for a visual way to duplicate users, groups or roles, Metacoda software has this capability as Paul describes in his blog posts:
    Duplicating or Copying SAS users - https://platformadmin.com/blogs/paul/2020/03/duplicating-copying-sas-users/
    Duplicating or Copying SAS groups and roles - https://platformadmin.com/blogs/paul/2020/03/duplicating-copying-sas-groups-roles/


    • Leonid Batkhan

      Thank you, Michelle, for your feedback and sharing additional resources. Metacoda is a great tool for SAS administrators. By the way, I also referenced in the Additional Resources section Paul Homes' blog post Duplicating or Copying SAS Users which is somewhat similar to the functionality described in this blog post - replicating/cloning metadata users' group/roles memberships from one user to another.

Leave A Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back to Top