Hi, I want to create 4 charts in a single row, then below that i need to display the data used . My requirement is to get in Excel as well in pdf. when i create using ods lay out and regions, i am getting in html report output but in the excel sheet the charts are not displayed only data is available. As well the pdf output is not matching with my requirement. I am getting all the charts in different pages. please look into the below code and suggest me if any changes. ods listing close; ods pdf  file="/myfolder/&cmpy&yymm..pdf"; ods html file="/ myfolder /&cmpy&yymm..xls"; goptions reset=global gunit=pct border colors=(blue blue blue yellow) ctext=black cback=cxCCFFFF hsize=3in vsize=3in ftitle=zapfb ftext=swiss htitle=6 htext=4 device=gif transparency; Axis1 STYLE=2 WIDTH=2 MINOR= (NUMBER=2); Axis2 STYLE=5 WIDTH=5; ods layout start width=10in height=8in columns=4 rows=2                  column_gutter=.5in row_gutter=.8in row_heights=(3.5in 3.5in); ods region row=1 column=1; PROC GCHART DATA=final1;       VBAR3D        MONTH/ descending       SUMVAR=avg_speed_to_answer       SHAPE=BLOCK FRAME TYPE=SUM       LEGEND=LEGEND1       COUTLINE=BLACK       RAXIS=AXIS1       MAXIS=AXIS2 PATTERNID=MIDPOINT width=15 inside=sum coutline=black cframe=white ; RUN; QUIT; ods region row=1 column=2; PROC GCHART DATA=final2;       VBAR3D        MONTH/ descending       SUMVAR=avg_talk_time       SHAPE=BLOCK FRAME TYPE=SUM       LEGEND=LEGEND1       COUTLINE=BLACK       RAXIS=AXIS1       MAXIS=AXIS2 PATTERNID=MIDPOINT width=15 inside=sum coutline=black cframe=white ; RUN; QUIT; ods region row=1 column=3; PROC GCHART DATA=final3;       VBAR3D        MONTH/ descending       SUMVAR=answered_cnt       SHAPE=BLOCK FRAME TYPE=SUM       LEGEND=LEGEND1       COUTLINE=BLACK       RAXIS=AXIS1       MAXIS=AXIS2 PATTERNID=MIDPOINT width=15 inside=sum coutline=black cframe=white ; RUN; QUIT; ods region row=1 column=4; PROC GCHART DATA=final4;       VBAR3D        MONTH/ descending       SUMVAR=answered_cnt       group=abondoned_cnt       SHAPE=BLOCK FRAME TYPE=SUM       LEGEND=LEGEND1       COUTLINE=BLACK          RAXIS=AXIS1       MAXIS=AXIS2 PATTERNID=MIDPOINT width=15 inside=sum coutline=black cframe=white ; RUN; QUIT; ods region row=2 column=2; proc report data=all style(header)=[BACKGROUND =blue BORDERRIGHTCOLOR=blue BORDERTOPCOLOR=white foreground=white BORDERCOLOR=blue font = (Arial,10pt) font_weight = bold]; run; ods layout end; ods pdf close; ods _all_ close; ... View more

Hi, I have a dataset like as below. Description type count Desc1 type1 3 Desc1 type2 4 Desc1 type3 5 Desc2 type1 6 Desc2 type2 7 Desc2 type3 8 I want to create a report using this dataset as below . new Desc count Desc1   type1 3   type2 4   type3 5 Desc2   type1 6   type2 7   type3 8 As shown above i need to get the two variables Description and type in a sigle column with spacings. It's not a cross tabulation report so i didn't use proc tabulate. I tried with Proc Report but i am getting as different variables. proc report data=have ; column description type count; define description /group "new Desc"; define type / display " "; define count / display; break after description/skip;    compute after description;      line " ";    endcomp; run; The above code is giving as separate colums instead of what i want.  Can any one suggest on this. Thanks, Vish ... View more

Hi ALL, I want to create coverpage with the titles and images with bar lines and colors included in it. Can u please look into the sample excel provided and suggest me ..using ODS ... View more

Hi, I want to create Excel pivot table from EG 4.2, which will consists of autofilters. I tried with ODS tagsets.tableeditor, but its not working in EG. Can anyone suggest on this. Thanks, Vishnu ... View more

Hi ALL, I want to know are there any schedulers which will be used to schedule a SAS job, that can be run in any platform. There are some schedulers for UNIX (Cron), WIndows, but my intention is to creating scheduled Sas job that will run in any OS with out any issues. Any suggestions pls. Thanks, -Vish ... View more

Hi All, I want to know are there anyways to send the reports as an email which exceeds size limits. It should be delivered with out any interruptions. Any help would be appriciated. Thanks, vish ... View more