Hi, I need some changes in my template for adding colours before 80% and after 125% and change labels from bottom to up.   proc template; define statgraph sgdesign; dynamic _MEAN _PARLB _PAR1A _HIGHT _LOW; begingraph / designwidth=950px designheight=450px backgroundcolor=CXE8E6E8; layout lattice / rowdatarange=data columndatarange=data rowgutter=10 columngutter=10; layout overlay / wallcolor=CXFFFFFF walldisplay=(OUTLINE FILL) xaxisopts=( display=(TICKS TICKVALUES LINE ) griddisplay=on gridattrs=GraphAxisLines(pattern=2 thickness=2 ) linearopts=( tickvaluepriority=TRUE tickvalueformat=BEST6. tickvaluelist=(80.0 100.0 125.0) tickdisplaylist=("80%" "100%" "125%"))) yaxisopts=( reverse=true display=(TICKS LINE TICKVALUES ) griddisplay=off gridattrs=(color=CX848284 pattern=2 thickness=1 ) discreteopts=( tickvaluefitpolicy=none)); scatterplot x=_MEAN y=_PARLB / group=_PAR1A xerrorupper=_HIGHT xerrorlower=_LOW name='scatter' grouporder=ascending markerattrs=(weight=bold ) errorbarattrs=(thickness=2 ); endlayout; endlayout; endgraph; end; run ... View more

 HElP me to drop    "–  from drom dataset I am using SAS 9.4, data came from 9.4UTF  ... View more

Hi All, I need merge two datas, and take right variable from second data.  first one my main data , second one data which have 3 answers for every subject. how we can merge it using sql in sas or sas. Example DATA A                                                              DATA B USUBJID DATE                                         USUBJID     STARTDATE    ENDDATE     EPOCH  1.001        10/10/17                                   1.001           09/10/17             14/10/17        SCREENING                                                                   2.001           15/10/17              15/12/17       TREATMENT                                                                   3.001           20/12/17              10/12/18       FOLLOW-UP   So need to check where is my date and take EPOCh for SCREENING for this example.   THANKS ... View more