cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ethan1
‎09-23-2021
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

How should I use a mapper file to import an xml file into a sas datase...

by Fluorite | Level 6 in SAS Programming
‎06-16-2020 03:25 AM
‎06-16-2020 03:25 AM
This xml file comes from 'Title.xlsx'. In order to import this xml file, I have created a mapper file(test.map). SAS code: filename xlsx2xml '~\xml-sas\Titles222.xml'; filename SXLEMAP '~\xml-sas\test.map'; libname xlsx2xml xmlv2 xmlmap=SXLEMAP access=READONLY; data sheet; set xlsx2xml.final; run; The dataset I got is shown as data.png. I did some simple data processing to get what I want in the end like data1.png. My question is, is there a way to add some code to the mapper file(test.map), so that I do not need these data processing in sas and can directly get the dataset I want (data1.png)?    ... View more

Re: How do I create a xml file, which can be imported by SAS and can a...

by Fluorite | Level 6 in SAS Programming
‎05-25-2020 08:59 PM
‎05-25-2020 08:59 PM
Thanks Tom!    The question is that, in this requirement, we cannot use xlsx/xls file.    We need to meet the following requirements at the same time 1. This file can be edited and saved by OFFICE-WORD/EXCEL and the file type cannot be xls/xlsx(It's really weird！) 2. This file can be imported into sas dataset. ... View more

Re: How do I create a xml file, which can be imported by SAS and can a...

by Fluorite | Level 6 in SAS Programming
‎05-25-2020 08:53 PM
‎05-25-2020 08:53 PM
Thank you for your reply！   1. open the XLSX file with excel software 2. save it as XML spreadsheet 2003(*.xml) 3. SAS CODE: libname xxx xml ".../xxx.xml";   If I open this xml file with Notpad, it's not a 'GENERIC' structure XML. So I can't import it directly with sas without using a map file.  <Row> <Cell><Data ss:Type="String">TSIDEM01_IA</Data><NamedCell ss:Name="_FilterDatabase"/></Cell> <Cell><Data ss:Type="String">TITLE</Data><NamedCell ss:Name="_FilterDatabase"/></Cell> <Cell><Data ss:Type="String">Summary of Demographics and Baseline Characteristics – Open Session; Safety Analysis Set </Data><NamedCell ss:Name="_FilterDatabase"/></Cell> </Row> Finally, the method I used is to directly transfer the above plain text into a sas data set by regular expressions .    ... View more

How do I create a xml file, which can be imported by SAS and can also ...

by Fluorite | Level 6 in SAS Programming
‎05-25-2020 12:09 PM
‎05-25-2020 12:09 PM
Dear,   Is there a way to create an xml file, which can be imported by sas  (without a map file) and can also be edited and saved using excel software?   I tried to use excel to save as xml file, but it can not be imported into sas due to the lack of map file(In fact, map files cannot be used in this requirement).   At present, the solution I think of is to save a xls/xlsx file as an xml file through excel software, and then create a macro to translate the xml file to a sas dataset. In this way, I can open this xml for editing and saving, and also import it into SAS dataset with my macro.   Is there a better solution?         ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-23-2021 10:53 PM
Quick links