topic Re: MSOFFICE2K template and inherited MSOFFICE2K templated behaving differently in ODS and Base Reporting

MSOFFICE2K template and inherited MSOFFICE2K templated behaving differently

deleted_user — Wed, 29 Aug 2007 12:31:59 GMT

Hi
Does the MSOFFICE2K and a inheritd MSOFFICE2k templatd behave differently for charts.

I tried the follwing first

ODS TAGSETS.MSOFFICE2K FILE = "F:\ct.xls" ;
GOPTIONS xpixels=600 ypixels=400 device=activex;
proc gplot data=sashelp.class ;
plot weight*age height*age;
run;
quit;
ODS TAGSETS.MSOFFICE2K CLOSE;

it gave me nice charts in excel file.

But when I try the following (ofcourse I added extra stuff to the new template. But here I am showing just the basic template with just the inheritence)
PROC TEMPLATE;
DEFINE TAGSET TAGSETS.TEST3;
PARENT=TAGSETS.MSOFFICE2K;
END;
run;
ODS TAGSETS.TEST3 FILE = "F:\ct.xls" ;
GOPTIONS xpixels=600 ypixels=400 device=activex;
proc gplot data=sashelp.class ;
plot weight*age height*age;
run;
quit;
ODS TAGSETS.TEST3 CLOSE;

When I opened the file in excel , I saw 2 very small distored charts.

I was under the impression when we create a new template using the existing template, both should produce the same results except the new features added to the new template. Any Idea why it's behaving like this.

Thanks for the feedback
Suren

Re: MSOFFICE2K template and inherited MSOFFICE2K templated behaving differently

Cynthia_sas — Wed, 29 Aug 2007 15:28:53 GMT

Hi:
When I do this:
[pre]
ods path sashelp.tmplmst(read);

ods tagsets.msoffice2k path='c:\temp' (url=none)
gpath='c:\temp' (url=none)
file='use_original.xls';

title 'The Table';

proc print data=sashelp.class;
run;

title 'The Graph';
goptions device=actximg;

PROC GCHART DATA=sashelp.class;
VBAR3D Sex / SUMVAR=Height TYPE=MEAN;
RUN;
QUIT;

ods tagsets.msoffice2k close;
[/pre]

And then compare it to the output from this code:
[pre]

ods path work.testmso(update)
sashelp.tmplmst(read);

proc template;
define tagset tagsets.test3;
parent=tagsets.msoffice2k;
end;
run;

ods tagsets.test3 path='c:\temp' (url=none)
gpath='c:\temp' (url=none)
file='use_inherit.xls';

title 'The Table';

proc print data=sashelp.class;
run;

title 'The Graph';
goptions device=actximg;

PROC GCHART DATA=sashelp.class;
VBAR3D Sex / SUMVAR=Height TYPE=MEAN;
RUN;
QUIT;

ods tagsets.test3 close;
[/pre]

I get EXACTLY the same output in both output files -- when opened in the Browser or opened in Excel. So my only conclusion is that somehow, something in your tagset code for TAGSETS.TEST3 is broken.

Your best bet for help with tagset syntax and debugging is Tech Support.

cynthia

Re: MSOFFICE2K template and inherited MSOFFICE2K templated behaving differently

deleted_user — Wed, 29 Aug 2007 22:17:58 GMT

Thanks Cynthia.

When I run your code in unix box( I changed the output path to unix )
I got the following error message

18 title 'The Graph';
19 goptions device=actximg;
20 PROC GCHART DATA=sashelp.class;
21 VBAR3D Sex / SUMVAR=Height TYPE=MEAN;
22 RUN;

NOTE: ActiveX Control not available, defaulting to JAVA.
ERROR: Java class generated an exception.
22 ! QUIT;

***********
I know I can create the images with device=activex in unix.. Can the actximg device in unique to windows OS only? This may be a question for Support .. but just checking to see

Thanks again
Suren

Re: MSOFFICE2K template and inherited MSOFFICE2K templated behaving differently

deleted_user — Wed, 29 Aug 2007 22:21:09 GMT

just to add few more line to my previous email , I am running the code in EG4, connected to UNIX

suren

Re: MSOFFICE2K template and inherited MSOFFICE2K templated behaving differently

Cynthia_sas — Wed, 29 Aug 2007 22:39:10 GMT

Suren:
The ACTXIMG driver was new in SAS 9. ActiveX was the only "ActiveX" device driver available in SAS 8. Anyway, if you change the ACTXIMG to ACTIVEX or JAVA you should still be able to test your code. But the fundamental issue, I think, is what's happening inside the changed tagset and not the device driver.

In my opinion, it's still a good idea to contact Tech Support for more help. They have a UNIX system that they can test on and they can help you if it IS a device driver issue AND they can help you if it's a tagset issue.

cynthia

Re: MSOFFICE2K template and inherited MSOFFICE2K templated behaving differently

deleted_user — Wed, 29 Aug 2007 22:59:14 GMT

Thanks Cynthia. I have fired a ticket to Support.

Cheers
Suren