Utilization of XML Language

1
Utilization of XML Language

• Presented By
• Sandeep (Raj) Juneja, ASG Inc., Cary, NC

2
AGENDA

• XML Introduction
• XML Applications
• Extracting Word Data to SAS
• Transferring Word Data To Excel
• Fetching Data Contents to Excel
• Automating ISS Mapping Document.
• Program Index
• Open Discussion

3
Evolution of File Formats
Microsoft Office 2003 Breakthrough XML
Support WordML, SpreadsheetML Custom-defined
schema
Microsoft Office 2007 New XML Formats XML file
format default XML PowerPoint format
Microsoft Office 2000 Early Innovation XML
document properties
Microsoft Office XP First XML Format Spreadsheet
XML
Microsoft Office 97 Existing binary file formats
designed in 1994, launched in Microsoft Office 97
4
Open XML Formats Architecture
Developer view Modular file
User view Single file
File container
Questionnaire.docx
Document properties

• Document Parts
• Most parts are XML
• Each XML part is a discrete, compressed component
• Can add, extract and modify individual parts
  without using Office programs
• Corruption or absence of any part would not
  prohibit the file from being opened

Comments
WordML/SpreadsheetML, etc.
Custom-defined XML
Images, video, sound
Embedded code/macros
Charts
5
XML Application 1 Extracting Word Data to SAS
6
SNAPSHOT TABLE TITLES DEFINED WITH TTLSTYLE
STYLE.
7
SNAPSHOT XML File with Style(s) Information
8
SNAPSHOT XML Map File
-
-- rg/2001/XMLSchema-instance" name"SAP"
version"1.2" xsinoNamespaceSchemaLocation"htt
p//www.sas.com/xml/schema/sxle12.xsd"
/Document/DocumentBod
y/Paragraph name"StyleName" syntax"XPath"/Document/DocumentBody/Paragraph/_at_S
tyleName character
string
19
syntax"XPath"/Document/DocumentBody/Paragraph/Te
xt character
string
200

9
SNAPSHOT SAS Dataset Containing Titles/Footnotes
10
XML Application 2 Transferring Word Data to Excel
11
SNAPSHOT Excel Spreadsheet Containing
Titles/Footnotes
12
SNAPSHOT Validation Sheet created from
Table/Listing Shells
13
XML Application 3 Metadata to Excel
14
SNAPSHOT INDEX Sheet- List of Datasets and
their properties
15
SNAPSHOT Dataset ECG
16
XML Application 4 Automating ISS Mapping Document
17
SNAPSHOT IMD-INDEX Sheet
18
SNAPSHOT IMD- AE Sheet
19
SNAPSHOT IMD- AE Mapping Info Sheet
20
SNAPSHOT IMD- AE Mapping Info Sheet
21
XML Application 5 Program Index
22
SNAPSHOT Program Index
23
Open 4 Discussion