Hello,
I have a SAS dataset I need to export to XML in the following format:
<t i="Title">
<R var1="11111111111" var2="22" var3="22222" var4="1234.12" />
<R var1="222222222" var2="33" var3="111111" var4="2345.23" />
<R var1="333333333" var2="22" var3="22222" var4="1234.12" />
<R var1="444444444" var2="33" var3="111111" var4="2345.23" />
<R var1="555555555" var2="22" v="22222" var4="1234.12" />
<R var1="666666666" var2="33" var3="111111" var4="2345.23" />
<R var1="777777777" var2="22" var3="22222" var4="1234.12" />
<R var1="888888888" var2="33" var3="111111" var4="2345.23" />
Is this possible?
Thanks,
Mark
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
- Cheers -
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:
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
- Cheers -
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.