This article discusses how data from TrialKit can be used in SAS applications.
SAS XML files are text formatted data that gives an XML standard layout for reading into a SAS environment or other programming application. Read more here about the XML format.
Since all the data in XML only exists as text, some applications will need to know the type of data for each variable, since it cannot be assumed. For example a date in text can be assumed as either text or a true date variable. This is where the XML Mapping file comes in useful. The mapping file gives all the information about the variables that exist in the study’s data dictionary. When combined within an XML mapper tool, a SAS formatted file can be easily created.
Mapping an XML file for using in SAS
To do this, you will need two applications (available for Windows only)
A SAS viewer. This can be a licensed application or the free SAS Universal viewer
Follow these steps:
Open the SAS XML Mapper application
Click on File, Open XML Map, choose the XML Map file downloaded from TrialKit
Now click File, open XML, choose the XML file downloaded from TrialKit
Tap on the tables option to view the data. Be sure a dataset is selected from the right side panel where all the datasets are listed.