Hi All,   By using below code I am getting the following output.     SAS Code: /*--Adverse Events timeline data--*/ data ae0; retain aestdateMin; retain aeendateMax; attrib aestdate informat=yymmdd10. format=date7.; attrib aeendate informat=yymmdd10. format=date7.; format aestdateMin aeendateMax date7.; drop aestdateMin aeendateMax; input aeseq aedecod $ 5-39 aesev $ aestdate aeendate; aestdateMin=min(aestdate, aestdateMin); aeendateMax=max(aeendate, aeendateMax); call symputx('mindate', aestdateMin); call symputx('maxdate', aeendateMax); y=aeseq; if aedecod=" " then y=-9; cards; . MILD 2013-03-06 2013-03-06 Legend . MODERATE 2013-03-06 2013-03-06 Legend . SEVERE 2013-03-06 2013-03-06 Legend 1 DIZZINESS MODERATE 2013-03-06 2013-03-07 2 COUGH MILD 2013-03-20 . 3 APPLICATION SITE DERMATITIS MILD 2013-03-26 2013-06-18 4 DIZZINESS MILD 2013-03-27 2013-03-27 5 ELECTROCARDIOGRAM T WAVE INVERSION MILD 2013-03-30 . 6 DIZZINESS MILD 2013-04-01 2013-04-11 7 DIZZINESS MILD 2013-04-01 2013-11-11 8 APPLICATION SITE DERMATITIS MODERATE 2013-03-26 2013-06-18 9 HEADACHE MILD 2013-05-17 2013-05-18 10 APPLICATION SITE DERMATITIS MODERATE 2013-03-26 2013-06-18 11 PRURITUS MODERATE 2013-05-27 2013-06-18 ; run; /*proc print;run;*/ /*--Evaluate min and max day and dates--*/ data _null_; set ae0; minday=0; maxday= &maxdate - &mindate; minday10 = -20; mindate10=&mindate - 20; call symputx('minday', minday); call symputx('maxday', maxday); call symputx('minday10', minday10); run; /*--Compute start and end date and bar caps based on event start, end--*/ data ae2; set ae0; aestdy= aestdate-&mindate+0; aeendy= aeendate-&mindate+0; stday=aestdy; enday=aeendy; if aestdy=. then do; stday=&minday; lcap='ARROW'; end; if aeendy=. then do; enday=&maxday; hcap='ARROW'; end; xs=0; run; /*ods escapechar="^";*/ /*--Custom style for severity of events--*/ proc template; define Style AETimelineV93; parent = styles.htmlblue; style GraphColors from graphcolors / "gdata1" = cx5fcf5f "gdata2" = cxdfcf3f "gdata3" = cxbf3f3f; style GraphFonts from GraphFonts / 'GraphDataFont' = ("<sans-serif>, <MTsans-serif>",5pt) 'GraphValueFont' = ("<sans-serif>, <MTsans-serif>",7pt) 'GraphTitleFont' = ("<sans-serif>, <MTsans-serif>",11pt); end; run; /*--Draw the Graph--*/ ods html close; ods graphics / reset width=5in height=3in imagename="Fig12_6_AETimeline_V93"; ods listing style=AETimelineV93 image_dpi=100; title "Adverse Events for Patient Id = xx-xxx-xxxx"; proc sgplot data=ae2 noautolegend nocycleattrs; /*--Draw the events--*/ highlow y=aeseq low=stday high=enday / group=aesev lowlabel=aedecod type=bar barwidth=0.8 lineattrs=(color=black) lowcap=lcap highcap=hcap name='sev'; /*--Assign dummy plot to create independent X2 axis--*/ scatter x=aestdate y=aeseq / markerattrs=(size=0); refline 0 / axis=x lineattrs=(thickness=1 color=black); /*--Assign axis properties data extents and offsets--*/ yaxis display=(nolabel noticks novalues) type=discrete; xaxis grid label='Study Days' offsetmin=0.02 offsetmax=0.02 values=(&minday10 to &maxday by 2); /*--Draw the legend--*/ keylegend 'sev'/ title='Severity :'; run;   Query: In the x axis scale how can we utilize maximum scale between Day -20 to Day 100 by 10 and also display the values 200 and 300 in the scale? I have tried with LOGSTYLE and LOGBASE options None did not work.   Thanks, csa ... View more

Hi All,   I am trying to generate a figure plot using the below code. I am getting the output as in the attached screen shot. proc sgpanel data=have  ; panelby SUBJID / layout=PANEL novarname columns=4 rows=2; series x=x_axis_var y=aval /group=trt01p_  lineattrs=(pattern=mediumdash thickness=2); scatter x=x_axis_var y=aval /group=trt01p_ markerattrs = (symbol=circlefilled size=8); rowaxis integer grid values=(0,50,75,100) label="test"; colaxis integer grid values=(1 to 10 by 1) discreteorder=data label="Day"; run; quit;   My query is how can we change the Blue color plots 'Green', Red color plots to 'Blue' and the bottom Legend with Green and Blue colors?     ... View more

Hi All,   I am trying to generate a figure plot using the below code. I am getting the output as in the attached screen shot. proc sgpanel data=have  ; panelby SUBJID / layout=PANEL novarname columns=4 rows=2; series x=x_axis_var y=aval /group=trt01p_ attrid=myid lineattrs=(pattern=mediumdash thickness=2); scatter x=x_axis_var y=aval /group=trt01p_ attrid=myid markerattrs = (symbol=circlefilled size=8); rowaxis integer grid values=(0,50,75,100) label="test"; colaxis integer grid values=(1 to 10 by 1) discreteorder=data label="Day"; run; quit;   My query is how can we change the Blue color plots 'Green', Red color plots to 'Blue' and the bottom Legend with Green and Blue colors?     Thanks. ... View more

Hi    I am trying to generate following output, I have tried various ways but no luck. Could you please help me out how to move the highlighted table to second page.   Getting: The highlighted in yellow color table should be moved to second page with separate title 'All'   This is my code.   proc template; define style styles.tabstyle; parent=styles.rtf; style table from table / cellpadding = 1pt; style body from body / leftmargin=1in rightmargin=1in topmargin=1.2in bottommargin=1in; style header from header / frame=void rules=groups font_weight=medium bordertopstyle=solid bordertopwidth=0.1px bordertopcolor=black borderbottomstyle=solid borderbottomwidth=0.1px borderbottomcolor=black; end; run; title; footnote; goptions reset=all; options orientation=&lineop_ missing=''; ods noresults; ods listing close; ods rtf file="C:\Local\chk.rtf" notoc_data style=styles.tabstyle startpage=no ; ods escapechar="^"; title1 j=left f=timesnewroman h=10pt "XYX"; title3 j=left "Grades and Sports"; proc print data=a width=full label split='~' style(table)=[vjust=middle just=center] style(header)=[font_size=10pt font_weight=medium just=center] style(column)=[font_size=10pt font_weight=medium just=left] noobs; var Name Science Mathematics History Geography; run; title; footnote; proc print data=b width=full label split='~' style(table)=[vjust=middle just=center] style(header)=[font_size=10pt font_weight=medium just=center] style(column)=[font_size=10pt font_weight=medium just=left] noobs; var Name Tennis Baseball Basketball Hockey Football; run; title3 j=left f=timesnewroman h=10pt "All"; proc print data = c width=full label split='~' style(table)=[vjust=middle just=center] style(header)=[font_size=10pt font_weight=medium just=center] style(column)=[font_size=10pt font_weight=medium just=left] noobs; var Rank Name Tennis Baseball Basketball Hockey Science Mathematics History Geography; run; ods _all_ close; ods listing; ods noresults; ... View more