BookmarkSubscribeRSS Feed
dat333
Fluorite | Level 6

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,

2 REPLIES 2
Ksharp
Super User

options label;

I am not sure whether it can be worked.

Peter_C
Rhodochrosite | Level 12

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 ;

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1305 views
  • 0 likes
  • 3 in conversation