SAS^® Clinical Data Integration does not include reporting to compare the number of pre-migration and post-migration objects and permissions. The code included in the download tab is designed to do this comparison.

1. Pre_Migration_Contents.sas - Uses the %MDSECDS macro, this program creates data sets for objects and permissions on the metadata server before migration
2. Post_Migration_Contents.sas - Uses the %MDSECDS macro, this program creates data sets for objects and permissions on the metadata server after migration
3. Post_Migration_Comparison_Reports.sas - Compares objects and permissions data sets from pre-migration to post-migration metadata.

   Here is an example of the object report:

   

   Here is an example of the permission report:

   

If the installation is an upgrade in place, step one must be run prior to installation and configuration of the next version of SAS^® Clinical Data Integration.

The sample was written for SAS^® Clinical Data Integration migration reporting for versions 2.3 and 2.4, but works with any release comparison.

The programs in step one and two rely on the output from the %MDSECDS macro. For more details see this link:

SAS(R) 9.3 Intelligence Platform: Security Administration Guide

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

---

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

Pre-migration and Post-migration Permission and Object Comparison

This is a usage note to download the pre-migration and post-migration comparison programs

Type:

Sample

Date Modified:	2014-10-01 14:45:37
Date Created:	2014-06-16 13:48:40

Operating System and Release Information

Product Family	Product	Host	SAS Release
			Starting	Ending
SAS System	SAS Clinical Data Integration	Linux for x64
		Solaris for x64