BookmarkSubscribeRSS Feed
hoatuoi9x
Calcite | Level 5

Hi everyone !

The Health Data app on iphone Xs (iOS14.2) can export its data into compressed XML files. The files are called export.zip, export.xml, and export_cda.xml. I used SAS XML Mapper and complained that the data was too big (45meg).

How do I import this data into SAS?

Thanks you so much !

2 REPLIES 2
Ksharp
Super User
1) write some data step code by yourself.

2) try xmlv2 engine.


filename tmp temp;
libname x xmlv2 'c:\temp\temp.xml' xmlmap=tmp automap=replace;
proc copy in=x out=work;
run;
Oligolas
Barite | Level 11

Hi,

I think there must be a lot of similar/repetitive data in your XML. For every day/activity?

You may be able to analyze and reduce the source data to feed the XML mapper, see #3 

________________________

- Cheers -

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
  • 1796 views
  • 0 likes
  • 3 in conversation