I am trying to convert sas data set to xml output using proc xml. I want the label of a variable form the SAS data set to be displayed as column heading in the xlm output. Can anyone show me the easiy way to do this for a large number of variables in the conversion from SAS data set to xml output.
Thanks,
options label;
I am not sure whether it can be worked.
dat333
I'm not sure where a "column heading in the xlm output" is going, but one example might be the XML generated by the LABEL option of proc print in:
data class ;
set sashelp.class ;
dob = intnx( 'year', "&sysdate"d, -age ) + ranuni( 1)*300 ;
attrib dob label= 'date of birth' format= date11.;
run ;
ods tagsets.excelxp file= 'my_demo.xml' rs=none ;
proc print LABEL data= class ;
run ;
ods tagsets.excelxp close ;
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.