Re: Any reason to prefer XML (SMDX) to Excel or CSV

Posted by Jon K Peck on Jan 27, 2013; 4:57pm
URL: http://spssx-discussion.165.s1.nabble.com/Any-reason-to-prefer-XML-SMDX-to-Excel-or-CSV-tp5717720p5717740.html

SPSS does have an XML driver in the Data Access Pack, but XML is flexible enough to be almost anything, so coping with an XML format would not be my first choice given other options.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: [phone]




From:        Andy W <[hidden email]>
To:        [hidden email],
Date:        01/27/2013 09:51 AM
Subject:        Re: [SPSSX-L] Any reason to prefer XML (SMDX) to Excel or CSV
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

SPSS does not have any native facility to read in XML data (you should open
up some example XML data to see what it looks like). I suspect to utilize it
one would need to import XML into a real database and then query the data
using SPSS. Either that or perform very tedious text munging to get the data
in the appropriate data matrix format.

Importing the data into a database isn't necessarily a bad thing, but adds
another step to the process that won't be necessary with csv. You could also
build your own database with the csv data, so there aren't any obvious
advantages to working with XML that I can tell. [Note: XML is popular
sometimes because of standardized versions to share sensitive data - so it
would be nice if SPSS in the future had the capability to read such data
given a schema]

I will give the caveat that I wouldn't be surprise if you can wrangle SPSS
'data list' command to read in XML directly how you want it (or you can get
ODBC configurations to query the data directly) - but I'm not familiar with
such situations (so maybe others can comment).

No serious person should ever trade data in xls or any various excel
formats, so that isn't even worth consideration. In addition to what Juan
says about pre-processed xls files being really in a different underlying
text mark-up format, I've had issues with SPSS opening up these pseudo-xls
files produced as regular output from other programs (as SPSS won't
recognize them as xls files - but treats them as plain text).





-----
Andy W
[hidden email]
http://andrewpwheeler.wordpress.com/
--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Any-reason-to-prefer-XML-SMDX-to-Excel-or-CSV-tp5717720p5717739.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD