Attached are XML transformation files (and powershell command scripts) for converting OpenClinica extracts into CSV, R (dataframes) and SAS (XML library; i.e. a SAS xml data file with a SAS mapping file). Code list lookups are also included for R (column duplicated as a factor with the lookup value) and SAS (using FORMAT commands after copying the XML library into the WORK library).
The transformations work by creating a “table” per itemgroup. Prior to performing the transformations we dynamically create a lookup xsl template specific for the study that is used to map itemgroup IDs into more friendly table names (the code for this is not attached; an example of the output is, see xml_convert_dynamic_lookup.xsl).
This email (including any attachments or links) may contain
confidential and/or legally privileged information and is
intended only to be read or used by the addressee. If you
are not the intended addressee, any use, distribution,
disclosure or copying of this email is strictly
Confidentiality and legal privilege attached to this email
(including any attachments) are not waived or lost by
reason of its mistaken delivery to you.
If you have received this email in error, please delete it
and notify us immediately by telephone or email. Peter
MacCallum Cancer Centre provides no guarantee that this
transmission is free of virus or that it has not been
intercepted or altered and will not be liable for any delay
in its receipt.
OC_XML_to_SAS_R_CSV.zip 9.6 KB