BookmarkSubscribeRSS Feed
BigD
Calcite | Level 5
Greetings,

I have been trying to get my activeX graphs/charts to enter a template. A 2X2 template would be nice. I'm not married to activex, I just find that it produces the best results. I can only seem to get the gseg charts into a template. I'm not fussy if I report in html or pdf.

I've tried several examples on this site, but the results don't seem to work with my gchart ouputs.

Some general and specific help would be appreciated.

Best,

D.
3 REPLIES 3
Andre
Obsidian | Level 7
Without code and environment specification, it is difficult to guess why.

Do you know that activex is only working with Microsoft products (IE and Office)?

Andre
BigD
Calcite | Level 5
I don't know if activeX is working with other products. I would be happy to produce html pages or rtf pages.

Using ver 9.3.1 service pack 4 on wXP.

Here's the code: Its from the sas web and modified by substituting my graph procedures. A problem is that it seems to double up the html output. And of course the pdf uses the gseg members.


options orientation=portrait;
goptions reset=all dev=activex ftext="Courier/oblique";
ods listing close;
ods pdf file="FourVbars.pdf" startpage=never;

goptions hsize=0 vsize=0;
*proc gslide;

*title1 'YOUR HOSPITAL ED Stats 2007/08' lspace=.5in;
*run;*quit;
goptions horigin=0 vorigin=5 hsize=4 vsize=4;
*axis1 order=(0 to 10);
title1 'Spring';

proc gchart data=one;
where hospital = "YOUR HOSPITAL" ;
hbar REG_WEEKDAY
/ AXIS=AXIS1 midpoints= (1 2 3 4 5 6 7)
freqlabel=''
PERCENT
noframe
patternid=midpoint
SUMVAR=VISITS
width=20
space=0
RAXIS=AXIS3
;
run;
run;quit;
goptions horigin=4 vorigin=5;
title1 'Summer';
pattern1 value=solid color=cxffcc33;
proc gchart data=ONE;
format reg_time time_fmt.;
where hospital = "YOUR HOSPITAL" ;
hbar TIME_OF_DAY

/ AXIS=AXIS1
/*midpoints= (1 2 3 4 5 6 7)*/
freqlabel=''
noframe
patternid=midpoint
SUMVAR=VISITS
PERCENT
width=100
space=0
RAXIS=AXIS3
;
run;
run;quit;

goptions horigin=0 vorigin=0;
title1 'Fall';
pattern1 value=solid color=cxaa3311;
proc gchart data=one;
FORMAT TRIAGE_LEVEL CTAS.;
where hospital = "YOUR HOSPITAL" ;
hbar TRIAGE_LEVEL
/ AXIS=AXIS1 MIDPOINTS = (1 2 3 4 5)
freqlabel=''
noframe
patternid=midpoint
PERCENT
SUMVAR=VISITS
width=50
space=0
RAXIS=AXIS3
;
run;quit;
goptions horigin=4 vorigin=0;
title1 'Winter';
pattern1 value=solid color=cx99ccff;
proc gchart data=one;
where hospital = "YOUR HOSPITAL" ;
FORMAT DISPOSITION_STATUS $DISPOSITION.;
hbar DISPOSITION_STATUS
/ AXIS=AXIS1 midpoints= (1 2 3 4 5 6 7)
freqlabel=''
noframe
patternid=midpoint
PERCENT
SUMVAR=VISITS

width=5
space=0
RAXIS=AXIS3
;
run;
ods html close;
ods pdf close;
goptions reset=all;
ods listing;
Andre
Obsidian | Level 7
Bigd,

I have already make perfect pdf with the goptions method
but in your code the last quit; is missing to close the last proc
and i don't see the opening of your html destination.

now in pdf destination i never use activex!


i have an long example on sas-l
Re: Multiple bar charts sent to same output page
posted on 8 Feb 2008
presenting an rtf production
and a rtf production

you were speaking about one more : html

i agree with you that you have the gseg already
so for the html destination
you could try the greplay only but separated from the other destination you
may choice.

In my example of course there are some french and european touches
as we are using herer a4 paper and not legal and using cm and not inches.

HTH
Andre




see the code at
http://groups.google.com/group/comp.soft-sys.sas/browse_thread/thread/d44873e40e527f34/5ad3125485add...

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 3 replies
  • 757 views
  • 0 likes
  • 2 in conversation