Hi All, I am using PROC GCHART and want to ganerate the graph in date Vs time , i googled it but i did nt get any solution , please suggest if any ideas. can we give it in Axis statement  as below. AXIS1 Order=(mm:ss to mm:ss) Please find the attachment and suggest on this. Thanks, Vish ... View more

   Hi All, I have an issue with titles in the report getting truncated when using ODS Tagsets.ExcelXP . when i reduce the table column width the titles are getting overrided to this width, but i want to display the titles irrespective of the report column width. can anyone suggest on this and even the data color is getting overrided to blue color which i have not given. Please look into the sample code below and suggest on this title; footnote; ods listing close; ods escapechar="^"; ods tagsets.excelxp file="/location/myfile.xls" style=BarrettsBlue OPTIONS ( Sheet_Name = 'Program' Sheet_Interval = 'proc' Orientation = 'portrait' FitToPage = 'yes' Pages_FitWidth = '1' Pages_FitHeight = '100' Center_Horizontal = 'yes' Embedded_Titles = 'yes' Embedded_Footnotes = 'yes' Absolute_Column_Width = '30,25' ); /*  title1*/   title1 j=left bold font=arial bc=cxffffff color=cx685c53 h=18pt "XYZ Corporation INDIA Pvt ltd (Monthly Standard report)";   title2 j=left bold  font=arial bc=cxffffff  color=cx685c53 h=10pt "Monthly Program  Report";   title3 j=left font=arial bc=cxffffff  color=cx685c53 h=10pt "Activity From: &startDatePrvYr through &endDatePrvYr"; proc report data=final style(report) = [just=left backgroundcolor=cxffffff BORDERRIGHTCOLOR=white BORDERTOPCOLOR=white BORDERCOLOR=white  font = (Arial,10pt)] split= "*" style(header)=[just=left BACKGROUND =cx685c53 BORDERRIGHTCOLOR=white BORDERTOPCOLOR=white foreground=white BORDERCOLOR=white font = (Arial,10pt) font_weight = bold] style(column)=[BORDERRIGHTCOLOR=white foreground=cx685c53 BORDERTOPCOLOR=white BORDERCOLOR=white font = (Arial,10pt)];   column program Count ;   define program / display  "Program" style(column)=[ indent=4 tagattr="format:@" just=center background=cxffffff foreground=cx685c53]                         style(header)=[just=left indent=2 ];   define Count      / analysis "Count"  style(column)=[ just=center background=cxffffff foreground=cx685c53]                       style(header)=[just=left indent=2 ];   rbreak after      / summarize ;   compute after;    program='Total';    call define(_row_,'style',"style=[font_weight=bold]");   endcomp; run; ods tagsets.excelxp close; ods _all_ close; ods listing; here title1 is getting truncated to the column width 15  as given in absolute column width, but i want to remain the same width for column and titles should display as they are. And the color for data i given as "cx685c53", but its getting overrided by blue color. Thanks, Vish ... View more

Hi all, I am trying to create a graph with gchart , i need to get Jan-12,Feb-12.....Dec-12 in X-axis ,but i am getting like Apr-12,Aug-12,Feb-12..so on(which is by default giving in ascending order). I want to change this order and i tried with proc gchart NOTSORTED option but it didn't work out. I have month variable which is having values like (january, February,....December) and i have created a format with  labels for month values as (Jan-12, Feb-12....Dec-12). sample code; proc gchart data=chart1; by notsorted month; format month $month_name.; vbar month/sumvar=sales                 midpoints=('01JAN2012'd to '31DEC2012'd) ; run; it doesn't yield the result  Please find the attached image for the sample output that i am getting. Thanks, Vish ... View more

Hi, I have an excel sheet with calculations which needs to be implemented through SAS to automate the report. Please find the attchment for the sample excel sheet. I want to get the field2 values as shown in the excel template using sas code. For example field2 first value is getting generated by calculating column values i.e. (C10+D11+E12+F13+G14+H15+I16+J17+K18+L19+M20+N21). So i want to implement these calculations using sas. Can anyone suggest on this. Thanks. ... View more