Help using Base SAS procedures

XML output

Reply
Frequent Learner
Posts: 1

XML output

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,

Super User
Posts: 10,035

XML output

options label;

I am not sure whether it can be worked.

Valued Guide
Posts: 2,177

XML output

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 ;

Ask a Question
Discussion stats
  • 2 replies
  • 148 views
  • 0 likes
  • 3 in conversation