Loading...
Please wait, while we are loading the content...
The Easy Way to Include XML Data into your SAS reports South Central SAS ® Users Group Educational Forum 2011
| Content Provider | Semantic Scholar |
|---|---|
| Author | Crissey, Mary Grace |
| Copyright Year | 2011 |
| Abstract | Originally designed to meet the challenges of large-scale electronic publishing, XML is playing an increasingly important role in the exchange of a wide variety of data on the Web and elsewhere. Many heterogeneous information systems have chosen XML as their preferred method of data exchange - especially in pharmaceutical and medical environments, with usage growing in the financial and educational domains. This paper illustrates a case study when I was given student test records and school demographic information as an XML file and asked to run standard SAS reports based on those inputs. With the stand alone utility tool , SAS XML Mapper 9.21, I was able to unlock the mystery of the XML “foreign” data and its hidden metadata structure . Interactively running the XML Mapper tool, I am able to visually ensure the hierarchical tree structure conforms to the given schema and thus come up with the syntax necessary to build a map to feed into the SAS Libname engine. Snippets from my SAS code for educational testing assessment reporting project for the State of Wyoming are displayed in my PowerPoint as the SAS XML Mapper enables drag and drop exploration of the tags and Xpaths with XML. Familiarizing myself with data was essential, because I must report on all data be they flat files, MS excel spreadsheets, mainframe files, SAS data, and including those “dreaded” eXtensible Markup Language files. |
| File Format | PDF HTM / HTML |
| Alternate Webpage(s) | http://www.scsug.org/SCSUGProceedings/2011/crissey1/the%20easy%20way%20to%20include%20XML%20data%20into%20your%20SAS%20reports.pdf |
| Language | English |
| Access Restriction | Open |
| Content Type | Text |
| Resource Type | Article |
