Prev: lag calculation macro
Next: This is how I do adverse events summaries,
From: Aldi Kraja on 3 Feb 2010 13:34
Hi,

Before, I had been using for sometime with SAS XML MAPPER to create SAS
map files and read XML files with no problem.
I had tested such conversion from XML to SAS tables with small data (in
fact small chunks of XML reads, but many of them ) and the conversion
had been successful for many times.

Now I have been working for sometime with SAS9.2
In this particular case I am using an "xsd" mapping file from a reliable
source, which has a header like this (see partial part 1 below). With
SAS XML MAPPER created SAS map file (see partial part 2)

When I use sas92 in Linux or sas92 in Windows to read large files as the
following one (see partial part 3)
with a size 4.3 GB or larger, sas reports there are no observation (it
creates the names of the variables though) in any of the tables created
(see partial part 4), which is wrong as can be seen in partial raw xml.
Only one of several tables has one observation!!!
Any suggestions what might be happening? If you think that the program
and data might help to debug, let me know and I can share them too,
because these data are publicly available.

Thank you in advance,
Aldi


partial part 1: ("xsd" mapping file)
=======================
<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- edited with XMLSPY v5 rel. 4 U (http://www.xmlspy.com) by Michael
Kholodov (National Library of Medicine) -->
<!-- edited with XMLSpy v2005 rel. 3 U (http://www.altova.com) by
Michael Feolo (NCBI/NLM/NIH) -->
<xs:schema targetNamespace="http://www.ncbi.nlm.nih.gov/SNP/geno"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns="http://www.ncbi.nlm.nih.gov
/SNP/geno" elementFormDefault="qualified"
attributeFormDefault="unqualified">
<xs:element name="Population">
<xs:annotation>
<xs:documentation>A Population contained in this
GenoExchange</xs:documentation>
</xs:annotation>
.......

partial part2: (SAS XML MAPPER map file)
===============================
<?xml version="1.0" encoding="windows-1252"?>

<!-- ############################################################ -->
<!-- 2010-02-02T12:59:47 -->
<!-- SAS XML Libname Engine Map -->
<!-- Generated by XML Mapper, 902000.3.6.20090116170000_v920 -->
<!-- ############################################################ -->
<!-- ### Validation report ### -->
<!-- ############################################################ -->
<!-- XMLMap validation completed successfully. -->
<!-- ############################################################ -->
<SXLEMAP description="population diversity" name="SXLEMAPSfreq"
version="1.2">

<!-- ############################################################ -->
<TABLE name="Individual">
<TABLE-PATH syntax="XPath">/Individual</TABLE-PATH>

<COLUMN name="indId">
<PATH syntax="XPath">/Individual/@indId</PATH>
<TYPE>character</TYPE>
<DATATYPE>string</DATATYPE>
<LENGTH>32</LENGTH>
</COLUMN>
......
partial part3: (raw xml file)
==================
<?xml version="1.0" encoding="UTF-8"?>
<GenoExchange xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://www.ncbi.nlm.nih.gov/SNP/geno" xsi:schemaLocation="http://www.
ncbi.nlm.nih.gov/SNP/geno
ftp://ftp.ncbi.nlm.nih.gov/snp/specs/genoex_1_4.xsd" dbSNPBuildNo="129"
reportId="9" reportType="chromosome">
<Population popId="3" handle="KWOK" locPopId="C">
<popClass self="NORTH AMERICA"/>
</Population>
.......
partial part 4: (SAS reports no data in the output table):
=====================================

The CONTENTS Procedure

Data Set Name SXLELIB.GENOEXCHANGE
Observations .
Member Type DATA
Variables 53
Engine XML
Indexes 0
Created . Observation
Length 0
Last Modified . Deleted
Observations 0
Protection
Compressed NO
Data Set Type
Sorted NO
Label
Data Representation Default
Encoding Default



--
 | 
Pages: 1
Prev: lag calculation macro
Next: This is how I do adverse events summaries,