topic For iPhone Xs how to read exported iphone health data XML? in SAS Programming

For iPhone Xs how to read exported iphone health data XML?

davdilana — Wed, 23 Jun 2021 19:54:22 GMT

The iphone Xs (iOS14.2) Health Data app can export its data into to XML files that are zipped. The files are called export.zip, export.xml and export_cda.xml. I've tied using SAS XML Mapper which complains that there data is too large (45meg).

How do I import this data into SAS?

Re: For iPhone Xs how to read exported iphone health data XML?

jimbarbour — Wed, 23 Jun 2021 22:36:01 GMT

That's not good that XML mapper cannot be used. I've found XML mapper to be extremely useful.

Is there any way you can export a smaller subset of the data on the iPhone? If you can export a dataset that is smaller overall but has the same XML structure as the large dataset, then you should be able to use XML mapper.

If you can't do that, you can create an XML map by hand, but that is a royal pain in the neck.

Those are my ideas. More ideas here:

https://www.lexjansen.com/pharmasug/2009/tu/TU10.pdf

There are tons of SAS papers on LexJansen.com. Check it out.

Jim

Re: For iPhone Xs how to read exported iphone health data XML?

Ksharp — Thu, 24 Jun 2021 12:14:50 GMT

The most powerful way is writing Data Step code to import this xml file.
or do you try xmlv2 engine ?

filename x temp;

libname xml xmlv2 'c:\temp\temp.xml' automap=replace xmlmap=x ;

proc copy in=xml out=work;
run;