All the best @djrisks  ... View more

We then have to convert the character date to numeric date and follow the logic. ... View more

Alternatively you may try    data have; input ID Sex Injury_Type; datalines; 1 1 1 . 1 2 . 1 3 2 2 1 . 2 3 ; run; data want; set have(rename=(id=_id)); by sex Injury_Type notsorted; retain id; if first.sex then id=.; if _id ne . then id=_id; run; ... View more

You may try    XAXIS DISPLAY=(NOLABEL NOTICKS NOVALUES); ... View more

Please try    data have; input account_id PT_DT:date9. MTHLY_PAY MTHLY_PAY_DT_CHANGE:date9.; format PT_DT MTHLY_PAY_DT_CHANGE date9.; cards; 12345 01FEB2017 456.98 25JUL2016 12345 01FEB2017 480.64 12SEP2016 12345 01FEB2017 512.34 12FEB2017 12345 01FEB2017 476.96 23MAY2018 12346 01APR2020 984.76 15JUN2019 12346 01APR2020 887.91 03APR2020 12346 01APR2020 634.33 04MAR2021 ; run; data want; set have; by account_id; MTHLY_PAY_BEFORE_PT=lag(MTHLY_PAY); if first.account_id then MTHLY_PAY_BEFORE_PT=.; if PT_DT<=MTHLY_PAY_DT_CHANGE then flag=1; MTHLY_PAY_AFTER_PT=MTHLY_PAY; keep account_id PT_DT MTHLY_PAY_BEFORE_PT MTHLY_PAY_AFTER_PT flag; run; proc sort data=want; by account_id; where flag=1; run; data want; set want; by account_id; if first.account_id; run; ... View more

Thanks a lot Kris, the use of legenditem statement suggestion is helpful. ... View more

Thank you @Jay54 for your response. I agree with you , the issue when i use var=usubjid is that i get two separate lines as per the expectation but the legend shows two lines for two subjects, however both of the subjects took the same dose , so i want to show the legend with the type pf dose taken in that case i should see only one row in legend. but that is not happening. ... View more

The unending line is the line returning back to the origin again or circling back, its visible for the second subject data, and this is happening when i use the group=rgoup1 from the discreteattrmap. when i don't use it and simply put group=usubjid in seriesplot then the unending lines are not visible and the subject data is properly plotted. I want to use the group=rgroup1 from discreteattrmap, so that i can use it for controlling the legend. I hope i am clear, please check the images of the graphs i posted in the main message. Could you please help with me with it. ... View more

Thank you @DanH_sas for your response ,    I updated the code as below and i get    data full_subset; infile cards missover; input RGROUP$      USUBJID$     AVISITN MONTH CHANGE; cards; dose1 00005 1 0 0 dose1 00005 1 dose1 00005 2 1.3 1.639344262 dose1 00005 2 dose1 00005 3 3.2 10.95081967 dose1 00005 3 dose1 00006 1 0 0 dose1 00006 1 dose1 00006 2 1.3 1.039344262 dose1 00006 2 dose1 00006 3 3.2 16.95081967 dose1 00006 3 ; proc sort data=full_subset; by rgroup usubjid avisitn; run; proc template; define statgraph sgplot; begingraph / collation=binary dataContrastColors=( red orange green violet yellow grey ) dataSymbols=( EOT ); SymbolChar char=delta_u NAME=EOT / scale=1; discreteattrmap name='TGROUPS'; value 'Treatment Ongoing' /markerattrs=(symbol=trianglerightfilled color=black size=12); enddiscreteattrmap; discreteattrvar attrvar=TGROUP1 var=TGROUP attrmap='TGROUPS'; discreteattrmap name='RGROUPS'; value 'dose1' /markerattrs=(symbol=squarefilled color=red size=12) Lineattrs=( Pattern=1 Thickness=2 color=red); enddiscreteattrmap; discreteattrvar attrvar=RGROUP1 var=rgroup attrmap='RGROUPS'; layout overlay / walldisplay=(fill) xaxisopts=( Label="Time since first dose date (months)" type=linear linearopts=(tickvaluesequence=(start=0 end=15 increment=0.5))) y2axisopts=(labelFitPolicy=Split) yaxisopts=( Label="Tumor size (% change from baseline)" labelFitPolicy=Split type=linear ) y2axisopts=(labelFitPolicy=Split); SeriesPlot X=month Y=change /xaxis=x yaxis=y /*Group=usubjid*/ break=true LineColorGroup=RGROUP1 MarkerColorGroup=RGROUP1 markersymbolgroup=rgroup1 display=(markers) LegendLabel="CHANGE" NAME="trt"; Layout Gridded / Border=true autoalign=(topleft topright) valign=top; Layout Gridded; endlayout; endlayout; DiscreteLegend "trt" /*"b"*/ / Location=Inside across=1 type=marker halign=right Title ="Dose Level" ValueAttrs=( Size=5) Opaque=true titleattrs=(family="Arial" size=8pt) titleborder=true sortorder=ascendingformatted autoalign=(TOPRIGHT) order=rowmajor border=false valueattrs=(family="Arial" size=8pt) Opaque=true; endlayout; endgraph; end; run; proc sgrender data=FULL_SUBSET template=sgplot /*sganno=anno*/; run;       ... View more

@Rick_SAS @DanH_sas @Jay54 @ballardw @Ksharp @PGStats    Could you please help.      ... View more