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;

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 578 views
  • 1 like
  • 3 in conversation