univariate template in excelXP

deleted_user — Thu, 24 Jan 2008 11:53:29 GMT

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 ;
run;
ods _all_ close ;
[/pre]
Without the "contents='yes'" the names of the variables analysed, appear nowhere!

PeterC replacing "index='yes'" with "contents='yes'". Before posting, the code was fixed but not the narrative;-)
PeterC
PeterC

Message was edited by: Peter_c

Re: univariate template in excelXP

Eric_SAS — Fri, 25 Jan 2008 21:27:37 GMT

The variables aren't showing up because the Excel tagset does not display titles generated by the procedure. I've worked at adding them today and haven't quite got it working yet.

Timing is a problem here, so it's getting complicated. I can make it work it's just going to
take a little more time.

Eric

topic Re: univariate template in excelXP in ODS and Base Reporting

univariate template in excelXP

Re: univariate template in excelXP