Reply To: Using SAS with NAACCR XML

July 9, 2018 at 3:02 pm #7311

Spectator

Yes overall the fix is working for CDATA sections! Just one minor additional fix, when there are pairs of [] within the text, the second ] onward is consistently not read. It’s cut off in the temp csv and sas dataset.
Example xml:
<Item naaccrId=”rxTextChemo” naaccrNum=”2640″><![CDATA[1/10/2016 DrugB (Part1, Part2, & Part3) @ Facility w/ Dr. Name. [DrugA started in 1/2015, but DrugB regimen planned] 1/15/2017 Drugc @ Facility w/ Dr Name2]]></Item>

The resulting variable only contains:
1/10/2016 DrugB (Part1, Part2, & Part3) @ Facility w/ Dr. Name. [DrugA started in 1/2015, but DrugB regimen planned

I think this is likely because CDATA uses [], I didn’t have problems with any other special characters in the data I tested.

Funding for this web site content was made possible in part by a contract with Federal funds from the National Cancer Institute, National Institutes of Health and Department of Health & Human Services under Contract number 75N91021D00018 / 75N91021F00001. Additionally, funding for this web site content was made possible in part by a cooperative agreement with Federal funds from the Centers for Disease Control and Prevention Cooperative Agreement number 5NU58DP006458. Its contents are solely the responsibility of the authors and do not necessarily represent the official views of the NCI and CDC.

Reply To: Using SAS with NAACCR XML

Reply To: Using SAS with NAACCR XML

Recent Topics

Forums