User’s Guide Second Edition - support.sas.com

1 SAS XML LIBNAME Engine user 's Guide Second Edition The correct bibliographic citation for this manual is as follows: SAS Institute Inc. 2010. SAS XML LIBNAME Engine: user 's Guide , Second Edition . Cary, NC: SAS Institute Inc. SAS XML LIBNAME Engine: user 's Guide , Second Edition Copyright 2010, SAS Institute Inc., Cary, NC, USA. ISBN 978-1-60764-447-7. All rights reserved. Produced in the United States of America. For a hard-copy book: No part of this publication can be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, or otherwise, without the prior written permission of the publisher, SAS.

2 Institute Inc. For a Web download or e-book: Your use of this publication shall be governed by the terms established by the vendor at the time you acquire this publication. Government Restricted Rights Notice. Use, duplication, or disclosure of this software and related documentation by the government is subject to the Agreement with SAS Institute and the restrictions set forth in FAR Commercial Computer Software-Restricted Rights (June 1987). SAS Institute Inc., SAS Campus Drive, Cary, North Carolina 27513. 1st electronic book, May2010. 1st printing, May 2010. SAS Publishing provides a complete selection of books and electronic products to help customers use SAS software to its fullest potential.

3 For more information about our e-books, e-learning products, CDs, and hard-copy books, visit the SAS Publishing Web site at or call 1-800-727-3228. SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. indicates USA. registration. Other brand and product names are registered trademarks or trademarks of their respective companies. Contents What's New v Overview v Enhanced LIBNAME Statement v New XMLMap Functionality vi Obsolete Syntax vi PART 1 Usage 1. Chapter 1 4 Getting Started with the XML Engine 3.

4 What Does the XML Engine Do? 3. Understanding How the XML Engine Works 3. SAS Processing Supported by the XML Engine 5. Transferring an XML Document Across Environments 5. Frequently Asked Questions 6. Chapter 2 4 Exporting XML Documents 7. Understanding How to Export an XML Document 7. Exporting an XML Document for Use by Oracle 7. Exporting an XML Document Containing SAS Dates, Times, and Datetimes 9. Exporting Numeric Values 10. Exporting an XML Document with Separate Metadata 15. Exporting an XML Document in CDISC ODM Markup 18. Chapter 3 4 Importing XML Documents 21. Understanding How to Import an XML Document 21.

5 Importing an XML Document Using the GENERIC Markup Type 21. Importing an XML Document with Numeric Values 23. Importing an XML Document with Non-Escaped Character Data 24. Importing an XML Document Created by Microsoft Access 26. Importing Concatenated XML Documents 30. Importing a CDISC ODM Document 32. Importing Web Service Results Using the WSDL Markup Type (Preproduction) 35. Chapter 4 4 Exporting XML Documents Using an XMLMap 41. Why Use an XMLMap when Exporting? 41. Using an XMLMap to Export an XML Document with a Hierarchical Structure 41. Chapter 5 4 Importing XML Documents Using an XMLMap 45.

6 Why Use an XMLMap When Importing? 45. Understanding the Required Physical Structure for an XML Document to Be Imported Using the GENERIC Markup Type 45. Using an XMLMap to Import an XML Document as One SAS Data Set 48. Using an XMLMap to Import an XML Document as Multiple SAS Data Sets 51. iv Importing Hierarchical Data as Related Data Sets 55. Including a Key Field with Generated Numeric Keys 58. Determining the Observation Boundary to Avoid Concatenated Data 62. Determining the Observation Boundary to Select the Best Columns 64. Using ISO 8601 SAS Informats and Formats to Import Dates 67.

7 Using ISO 8601 SAS Informats and Formats to Import Time Values with a Time Zone 68. Referencing a Fileref Using the URL Access Method 70. Specifying a Location Path on the PATH Element 71. Chapter 6 4 Understanding and Using Tagsets for the XML Engine 75. What Is a Tagset? 75. Creating Customized Tagsets 75. Exporting an XML Document Using a Customized Tagset 75. PART 2 Reference 83. Chapter 7 4 LIBNAME Statement for the XML Engine 85. Using the LIBNAME Statement 85. Understanding the XML LIBNAME Engine Versions: XML and XML92 85. LIBNAME Statement Syntax 87. Chapter 8 4 XMLMap Files for the XML Engine 99.

8 Comparing the XMLMap Functionality 99. XMLMap Syntax Version 100. Using SAS XML Mapper to Generate and Update an XMLMap 114. Chapter 9 4 SAS Data Set Options for the XML Engine 117. PART 3 Appendixes 119. Appendix 1 4 Sample XML Document 121. Example CDISC ODM Document 121. Appendix 2 4 Recommended Reading 129. Recommended Reading 129. Glossary 131. Index 133. v What's New Overview SAS provides two versions for XML LIBNAME engine functionality. 3 By specifying the engine nickname XML, you access the SAS XML engine functionality. 3 By specifying the engine nickname XML92, you access the new SAS XML.

9 Engine functionality with enhancements and changes. Note: In the third maintenance release for SAS , XML92 functionality is production, except for the WSDL markup type, which is preproduction. 4. Note: In the z/OS environment, XML92 functionality is preproduction. 4. The XML92 engine nickname provides the following enhancements and changes: 3 an enhanced LIBNAME statement 3 new XMLMap functionality 3 diagnostics of obsolete syntax See Understanding the XML LIBNAME Engine Versions: XML and XML92 on page 85. Enhanced LIBNAME Statement The LIBNAME Statement Syntax on page 87 has the following enhancements for the XML92 engine nickname.

10 Some functionality is for SAS Phase 2 and later, and some functionality is for the third maintenance release for SAS 3 In addition to assigning a libref to a specific XML document, you can assign a libref to the physical location of a SAS library in a directory-based environment. 3 The XMLTYPE= option now supports the XMLMAP markup type. The XMLMAP. markup type specifies that the XML markup is determined by an XMLMap, which tells the XML engine how to interpret an XML document that is being imported or a SAS data set that is being exported. vi What's New 3 For SAS Phase 2 and later, the XMLTYPE= option supports the WSDL.