topic XML output in SAS Procedures

XML output

dat333 — Tue, 22 Nov 2011 05:18:55 GMT

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,

XML output

Ksharp — Tue, 22 Nov 2011 10:00:45 GMT

options label;

I am not sure whether it can be worked.

XML output

Peter_C — Tue, 22 Nov 2011 10:49:50 GMT

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 ;