I am writing the following code and get the attached result.   proc template; define statgraph regress; begingraph; entrytitle 'Ngal'; layout overlay; barchart x=group y=ngal/stat=mean group=group display=(fillpattern fill outline) grouporder=data; scatterplot x=group y=ngal /group=group yerrorlower=lower_ngal yerrorupper=upper_ngal markerattrs=(size=10) errorbarattrs=(thickness=3 pattern=dot color=black); endlayout; endgraph; end; define style styles.mypatterns; parent=styles.listing; style GraphData1 from GraphData1 / fillpattern = "e1" color=white contrastcolor=white markersymbol='circle'; style GraphData2 from GraphData2 / fillpattern = "R1" color=white contrastcolor=black markersymbol='circle'; style GraphData3 from GraphData3 / fillpattern = "e1" color=black contrastcolor=black markersymbol='circle'; style GraphData4 from GraphData4 / fillpattern = "L1" color=white contrastcolor=black markersymbol='circle'; end; run; ods html style=mypatterns; ods graphics / reset border width=600px height=400px; proc sgrender data=work.data template=regress; run;   I would like to delete the dot lines along with error bars. I have been spending more than a few weeks with this. Actually, I don't understand why this code draws the dot lines beyond the error bar range. Any suggestions or advice will be welcomed. Thank you in advance for your help.       ... View more

I want to let the computer to calculate the estimate and standard error of β4+β5. I think I should use estimate statement but I could not understand by myself.   My current code is as follows,   proc mixed method=reml noclprint=10 covtest;  class id; model logcd4 = week week_16 trt*week trt*week_16 / s chisq; random intercept week week_16 / subject=id type=un g gcorr;  run;   "week" and "week_16" are continuous variables. I don't include the effect of the "trt" at baseline because this study is supposed to be RCT. Also, I assume a different trend before and after week 16, so I include the effect of week_16. What I want to do here is to assess the effect of "trt" is different between "trt=0" and "trt=1".   In my thought, The actual model statement is as follows,   logCD4=β1+β2week+β3week_16+β4trt*week+β5trt*week_16   I have attached xlsx file. I appreciate any kinds of help. Thank you in advance for your help. ... View more

Hello, Thank you in advance for your help. I have the following data set.  ID date bp time 1 10/2/2018 100 0 1 10/2/2018 90 1 1 9/7/2017 89 0 1 9/7/2017 94 1 1 9/72017 89 2 2 4/4/2016 130 0 2/ 4/4/2016 145 1   The expected dataset is as follows,  id date x0 x1 x2 1 10/2/2018 100 90 1 9/7/2017 89 94 89 2 4/4/2016 130 45   My current program is as follows,  proc transpose data=have out=want. prefix=x; var bp; by id date; id time;   I want to transpose bp for each id and date but I could not obtain the expected dataset with this codes. I have spent a lot of time, but I haven't reached the answer. ... View more

I appreciate your help. I have data set shown below. ID time NIBP 1 1 89 1 2 90 1 3 78 1 4 87 1 5 88 1 6 89 1 7 90 2 1 77 2 2 88 2 3 90 3 1 99 3 2 100   I would like to count point  where NIBP=<88 for individual ID. I would like to acquire an output like,   ID count 1 3 2 1 3 0   In my actual data set, the number of ID is 18 thousands and the length of the time is different for each ID.  Thank you very much for your kindness in advance. ... View more