topic Re: SAS XML Output in SAS Programming

SAS XML Output

mk131190 — Wed, 26 Oct 2016 13:35:50 GMT

Hello,

I have a SAS dataset I need to export to XML in the following format:

Is this possible?

Thanks,

Mark

Re: SAS XML Output

RW9 — Wed, 26 Oct 2016 13:47:34 GMT

Yes. Many ways to do it. What have you tried? You could do this with a datastep and put each of the values out to a file. Simple. However that snippet you provide doesn't look very XML to me. Either your using some weird properties on your XML, or that is something else, maybe HTML. Clarify your problem - what data do you have - post it as a datastep in the post. Show the full output of what you want. This shows how to output actual XML:

http://www2.sas.com/proceedings/sugi29/119-29.pdf

Re: SAS XML Output

Oligolas — Wed, 26 Oct 2016 13:54:39 GMT

yes,

DATA _NULL_;
   length var $32767;
   file "C:\test.xml";
   set sashelp.class;
   if _N_ eq 1 then put '<t i="Title">';
   else do;
      var='<R name="'||strip(name)||'" height="'||strip(put(height,best.))||'" weight="'||strip(put(weight,best.))||'" age="'||strip(put(age,best.))||'" />';
      put var;
   end;
RUN;

Cheers