Hi, I am trying to put a report together showing Country Group, Country, target(on the left hand side) and date (going across @ the top)  and volume in the middle.. at the end of every CountryGroup I am able to show the total of volume: something like this Country Group      Country,      target        Day1     Day2                     NorthAmerica          Canada      200          310          120                               USA          250          10            320                                                                        320          440 I want to modify the above sample report as follows 1) in the ROW, where I am showing sum of the volumes, I want to say total of the Country Group. 2) I want to add the total of the target as well 3) want to highlight volumes that are greater than the target so the above report should look something like this Country Group      Country,      target        Day1     Day2                     NorthAmerica          Canada      200          310          120                               USA          250          10           320          North America Total                  450          320          440 Here is the code that I've used proc report data=reg headline   style(column)={font_face=times font_size=1.4}   style(header)={just=center font_face=arial}; column CountryGroup Country allocated dayNo, Volume; define CountryGroup / group 'Group ' style(column)=[background=gray foreground=white font_weight=bold]; define Country / order=formatted group ' ' style(column)=[background=gray foreground=white font_weight=bold]; define allocated / group 'Allocated ' ORDER=INTERNAL style(column)=[background=gray foreground=white font_weight=bold]; define dayNo / across 'Day ' ORDER=INTERNAL; define Volume / analysis sum format=comma10.  ' '; break after CountryGroup /  ul skip summarize suppress; rbreak after / dol skip summarize; Thanks in advance ... View more

Hi, I am using proc report to create a report with few columns... Report is grouped by year_month. Want to add one more row @ the end of each year_month (grouped by variable) to show calculated filed... calculated filed (let's call it field_A) will be based on the formula as follows Field_A = 1000/VOL_PER_HR may I know how to accomplish it... Here is the sample code that I've used proc report data=WORK.Table_A nowd;   column YEAR_MONTH_DT cv1 VOL_PER_HR, SUM=VOL_PER_HR_SUM;   define YEAR_MONTH_DT / group format=YYMMDD10. missing noprint order=internal;   define cv1 / computed 'YEAR_MONTH_DT' format=YYMMDD10. missing;   compute cv1;   if YEAR_MONTH_DT ne . then hold1=YEAR_MONTH_DT;   cv1=hold1;   endcomp;   define VOL_PER_HR / analysis SUM 'VOL_PER_HR' format=COMMA10. missing;   define VOL_PER_HR_SUM / format=COMMA10.;   run; quit; ... View more

Hi, I am using Proc GCHART to show some data by day for the last 90 days... my only issue is that if the data is not available for a specific date then it doesn't show up, is there a way to show a blank when the data is not available in a particular month.? Here is the code that I've used PROC GCHART DATA=WORK.TABLE_A ;   VBAR   YEAR_MONTH_DAY / discrete   SUMVAR=VOL   SUBGROUP=CITY   CLIPREF FRAME TYPE=SUM   LEGEND=LEGEND1   COUTLINE=BLACK   RAXIS=AXIS1   MAXIS=AXIS2 ; Thanks ... View more

Hi, I am trying to put few graphs in an html format using ods tagsets. my problem is that the back ground (not of the graphs) is grey, how to change it to white Snapshot is attached to this note and here is the code used: /***********************Initializing****************************/ ods listing close; filename odsout '\\Server\folder'; ods tagsets.htmlpanel path = odsout                       body = "Report.html"; /**************Top Graph*************************/ goptions reset=all device=javaimg xpixels=210 ypixels=200 cback=white; ods listing close; ods html style=listing; proc gkpi mode=raised;    speedometer actual=&PERCENT_UTL. bounds=(0 .40 .60 1) /   target=.75    lfont=(f="Albany AMT" height=.6cm) label="Graph"    format="percent8.0"; run; %let panelcolumns = 4; %let panelborder = 1; ods tagsets.htmlpanel event=panel(start); /**************Graph Row 2 - 1************************/ goptions reset=all device=javaimg xpixels=210 ypixels=200 cback=white; ods listing close; ods html style=listing; proc gkpi mode=raised;    speedometer actual=&PERCENT_UTL_A. bounds=(0 .40 .60 1) /   target=.75    lfont=(f="Albany AMT" height=.6cm) label="Graph"    format="percent8.0" TYPE=HALF; run; /**************Graph Row 2 - 2*************************/ goptions reset=all device=javaimg xpixels=210 ypixels=200 cback=white; ods listing close; ods html style=listing; proc gkpi mode=raised;    speedometer actual=&PERCENT_UTL_B. bounds=(0 .40 .60 1) /   target=.75    lfont=(f="Albany AMT" height=.6cm) label="Graph"    format="percent8.0" TYPE=HALF; run; /***************code for other graphs not shown here************/ quit; ods tagsets.htmlpanel event=panel(finish); ods tagsets.htmlpanel close; ods html close; ods listing; ... View more

Hi, I am using ODS HTML to generate a report with multiple graphs. by default when I print out I get the full path of the report @ the bottom of my report... may I know how to get rid of it. Thanks in advance ... View more

Hi, I am using GCHART to show volumes by city... so I've used City to "grouped chart by". On top of every chart I am getting something like this CITY=TORONTO then my chart CITY = NEWYORK then my chart how can I remove CITY= and just show the name of the city...? Thanks ... View more

Hi, I am using GCHART to display some bars... May I know how to show the value for each bar... Thanks in advance ... View more

Hi, In my report I get a SAS Logo (SAS Enterprise guide) at the top... may I know how to remove it Thanks ... View more

Hi, I have a data set with event details as follows Event Name       Location               Start      End ABC                        Loc A                     01Jan2012:10:0:0              01Jan2012:12:0:0 DEF                        Loc B                      02Jan2012:08:0:0              02Jan2012:11:0:0 GHI                        Loc B                      02Jan2012:18:0:0              02Jan2012:20:0:0 … I want to know the time difference b.w end of the event and the start of the next event… something like this Event Name       Location               Start                                      End                                        Next_Event_In_Hrs ABC                        Loc A                     01Jan2012:10:0:0              01Jan2012:12:0:0                   20 DEF                        Loc B                      02Jan2012:08:0:0              02Jan2012:11:0:0                   7 GHI                        Loc B                      02Jan2012:18:0:0              02Jan2012:20:0:0                     - Thanks in advance ... View more

Hi, I am using PROC GCHART to plot a graph... may I know how to identify values on the graph here is the sample code PROC GCHART DATA=WORK.SORTTempTableSorted ;   VBAR   FCLTS_CATEGORY /   SUMVAR=SUM_of_VOL   SUBGROUP=PRODUCT   GROUP=YEAR_MONTH   CLIPREF FRAME TYPE=SUM   LEGEND=LEGEND1   COUTLINE=BLACK   RAXIS=AXIS1   MAXIS=AXIS2 ;   BY DST_CATEGORY; Thanks in advance ... View more