BookmarkSubscribeRSS Feed
davdilana
Calcite | Level 5

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?

Thank huy dung support me at vietnam hcm. View more
thay pin iphone 8 plus - ép kính iphone - iPhone mất face id
2 REPLIES 2
jimbarbour
Meteorite | Level 14

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

Ksharp
Super User
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;

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1220 views
  • 2 likes
  • 3 in conversation