How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
Ask LogicPro Your Own Question
LogicPro
LogicPro, Computer Software Engineer
Category: Programming
Satisfied Customers: 5537
Experience:  Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.
29751445
Type Your Programming Question Here...
LogicPro is online now

I have an excel document that has multiple rows of

Customer Question

I have an excel document that has multiple rows of individual records. Part of the data is xml populating multiple cells (each cell apart from the last containing the max 32767 characters). I want to import the xml part into SAS as xml.
JA: What application are you using?
Customer: It would be Enterprise Guide for work but I'm using SAS Studio at the moment.
JA: Have you installed any updates recently?
Customer: It's online software, why would that be a concern?
JA: Anything else you want the Microsoft Office Expert to know before I connect you?
Customer: I've not imported XML into SAS previously either
Submitted: 13 days ago.
Category: Programming
Expert:  Bing replied 13 days ago.

Hello and welcome to JustAnswer, an independent technical support website. My name is ***** ***** it’s my pleasure to be assisting you today.

Are you talking about an Excel spreadsheet? Or Google Sheet?

Customer: replied 13 days ago.
Apologies, it's an Excel spreadsheet
Expert:  Bing replied 13 days ago.

Okay. Can you please upload the Excel workbook for review?

Customer: replied 13 days ago.
Test file sent
Expert:  Bing replied 13 days ago.

Received.

Customer: replied 12 days ago.
Hi there, was there any more info I was meant to supply or should I just wait for an update? Many thanks.
Expert:  Bing replied 12 days ago.

I am in a remote session at the moment. Will follow up shortly.

Customer: replied 11 days ago.
Hey, I managed to create this xml that was used to import several individual xml's but I still need to be able to import the excel spreadsheet, even if it's just the cells with xml across several cells.
Just in case it's any help.
filename mymap temp;
libname mymap xmlv2 '/home/u49154611/Schema_EQCONS.xml' automap=replace xmlmap=mymap;
Customer: replied 9 days ago.
Hi, do you think you'll be able to help with this?