I have a list of 20-30 factors which I would like to create 4 graphs each for. Ideally I would like them in an excel file, each on a separate sheet (four graphs per sheet) but I know that's next too impossible. Exporting to powerpoint and pdf are sufficient alternatives. What I like about Excel is that you can separate each factor into its own workbook. I have started the process off using robslink.com as a reference.
My code is below (which I took from http://www.robslink.com/SAS/democd7/clin1_info.htm)
Couple of points:
- I am trying to get one factor right so I have just created a dataset with one factor and dummy values.
- I want 4 graphs but using the same graph here 4 times for illustrative purposes
- In the reference above, the first few lines of code where he defines htmlvar, I'm not sure what this does.
My main challenges are:
- In the link above he creates a bar chart with a line chart on a secondary graph and retains with a "MS excel look". I can reproduce a single graph but I need guidance on how to create 4 on a single page, that are the same size. I'm not sure what the code highlighted in red does.
- I want the code to be flexible so that it can handle loads of different factors with different ranges of levels, some numeric (age) and some character (occupation).
- The code highlighted in pink is not from the above link. I took it from a different source about exporting 4 graphs to a pdf. it doesn't work properly for me (graphs appear on a pdf but they don't have the format created by robslink code and they are not fitted correctly on the page.
data my_data;
INFILE DATALINES DLM=',';
format factor level $16.;
input factor $ level $ exposure lossratio ;
datalines ;
occupation,professional,500,.44
occupation,student,1000,.55
occupation,retired,2000,.75
;
run;
data my_data; set my_data;
length htmlvar $500;
htmlvar=
'title='||quote(
'Level: '|| trim(left(level)) ||'0D'x||
'Vehicle Exposure Years: '|| trim(left(v01_veh_exp_years))||
'Loss Ratio: '|| trim(left(all_LR)))||
' href="clin1_info.htm"';
run;
goptions device=png;
goptions xpixels=750 ypixels=500;
goptions noborder;
ODS LISTING CLOSE;
ODS HTML path=odsout body="&name..htm"
(title="SAS/Graph gbarline Line & Column Chart") style=sasweb;
goptions gunit=pct htitle=6 ftitle="albany amt/bold" htext=4.25 ftext="albany amt/bold";
title1 ls=1.5 "&name. - LR";
/*title2 "Classic Combination Chart";*/
pattern1 v=solid color=cx993366;
symbol1 interpol=join width=3 value=dot height=4 color=navy;
axis1 label=(a=90 'Exposure Years') offset=(0,2) order=(0 to 30000 by 5000) major=(h=-1) minor=none;
axis2 label=(a=90 'Loss Ratio') offset=(0,2) order=(0 to 2 by .5) major=(h=-1) minor=none;
axis3 label = none value=(angle=90) offset=(13,13) ;
device=pdfc
ftext="swissb";
ods pdf file="H:\Commercial\Fleet\Presentations\four in one.pdf" startpage=never;
ods proclabel "Four graphs on one page" ;
goptions hsize=5.20 in vsize=3.75 in;
title1;
proc gbarline data=my_data2;
goptions horigin=0in vorigin=3.99 in;
bar level / discrete
type=sum sumvar=v01_veh_exp_years
axis=axis1 maxis=axis3
space=5 width=6
html=htmlvar
des='' name="&name" ;
plot /
type=sum sumvar=all_LR
axis=axis2
html=htmlvar;
run;
quit;
proc gbarline data=my_data2;
goptions horigin=5.25;
bar level / discrete
type=sum sumvar=v01_veh_exp_years
axis=axis1 maxis=axis3
space=5 width=6
html=htmlvar
des='' name="&name" ;
plot /
type=sum sumvar=all_LR
axis=axis2
html=htmlvar;
run;
quit;
proc gbarline data=my_data2;
goptions hsize= 5.20in vsize= 3.75in device=pdfc ftext="swissb"
bar level / discrete
type=sum sumvar=v01_veh_exp_years
axis=axis1 maxis=axis3
space=5 width=6
html=htmlvar
des='' name="&name" ;
plot /
type=sum sumvar=all_LR
axis=axis2
html=htmlvar;
run;
quit;
proc gbarline data=my_data2;
goptions horigin=5.25 in;
bar level / discrete
type=sum sumvar=v01_veh_exp_years
axis=axis1 maxis=axis3
space=5 width=6
html=htmlvar
des='' name="&name" ;
plot /
type=sum sumvar=all_LR
axis=axis2
html=htmlvar;
run;
quit;
ods pdf close;
Click image to register for webinar
