BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
5 REPLIES 5
Cynthia_sas
SAS Super FREQ
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
deleted_user
Not applicable
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
deleted_user
Not applicable
just to add few more line to my previous email , I am running the code in EG4, connected to UNIX

suren
Cynthia_sas
SAS Super FREQ
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
deleted_user
Not applicable
Thanks Cynthia. I have fired a ticket to Support.

Cheers
Suren

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 810 views
  • 0 likes
  • 2 in conversation