Redefining clinical data management with tailored Define.xml solutions
Overview
The customer is a global Biopharmaceutical company and one of the largest Pharmaceuticals companies by both market capitalization and sales with $40 Billion annual turnovers and global footprints in 140 countries. The company is committed to deliver innovative health solutions.
Download Case Study
Challenges
The client envisaged to address the emerging need of service portals for IPTV service providers to select services such as video or music content, Internet services, telephony services, security services & others
Automation Process was not feasible as XML Map software was being used to get all the metadata into SAS datasets in required format
Solution
- Provided a compact solution using SAS to lay out a validation Process that could serve as an in-house model
- Extracted key variables, all variable attributes and Code List into SAS datasets using data steps and PRX functions
- Created a macro to check that the key variables list can identify the unique records in the metadata datasets
Outcomes
- Eliminated extra steps used in XML Map and other external software in Define.xml validation process and the manual steps that followed for formatting the metadata dataset
- Process automation was made possible for an end-to-end solution
- Augmented the ability to extract different parts of Define.xml metadata for selective validation needs
- Built an in-house Define.xml validation process which offers more than what other external software can provide, getting rid of the need to depend on the services of a specialist in Define.xml
