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 ;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.