topic graphs and ods templates in ODS and Base Reporting

graphs and ods templates

BigD — Wed, 29 Oct 2008 14:00:53 GMT

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.

Re: graphs and ods templates

Andre — Wed, 29 Oct 2008 14:33:54 GMT

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

Re: graphs and ods templates

BigD — Wed, 29 Oct 2008 15:04:40 GMT

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;

Re: graphs and ods templates

Andre — Wed, 29 Oct 2008 17:02:23 GMT

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/5ad3125485add9f4?lnk=gst