When I do a quick proc univariate analysis of a dataset to an excel work book using ODS tagset.excelXP, most tables of results do not have the name of the variable being analysed.
Am I missing a simple option ?
Do I have to modify templates for proc univariate and /or tagsets.excelXP? I hesitate over the first, and will make a manual work-around rather than get involved with the second.
This code demonstrates my problem: (It expects fileref ODSOUT pointing to a suitable place for the formatted results) [pre]
title 'testing univariate templates in ods through excelxp' ;
ods tagsets.excelxp file= odsout( url= none) rs= none
options( contents='yes' Embedded_Titles='yes' ) ;
proc univariate data= sashelp.class ;
id name ;
ods _all_ close ;
Without the "contents='yes'" the names of the variables analysed, appear nowhere!
replacing "index='yes'" with "contents='yes'". Before posting, the code was fixed but not the narrative;-)