Thank you so much for your help! I really appreciated it!! ... View more

I use the by statement to show the Subject ID on the graph ... View more

That helps to make the graphs the same size and looks much better. Can proc sgplot draw the same graph as proc gplot did in my case, if this is possible, then all the graph setting can only be set once, that is what I meant.  ... View more

"the GPLOT code to SGPLOT and then a single setting with ODS Graphics would set a similar height and width on the page." This would be ideal, if I can make the two graphs consistent, but I can't find the equivalent code of SGPLOT to draw what I did by using GPLOT, and I am new to SAS graphics procedure. ... View more

@Reeza @ballardw @PaigeMiller  Thank you all, I can't express how much I appreciated your help on this! ... View more

I checked the output, the space is not the reason that pushed the 2nd graph onto the next page, the lisitng is only one row, so all of them should fit into one page if there is such a control. Thanks ... View more

I copied and pasted the code in above. The two graphs are all the proper size and can easily fit into one page and the DM listing is only one row. If I don't print them all on one page, then it would defeat the purpose of this report. I used proc GPLOT, because I find an example of code which draw the kind of graph I need. Thanks ... View more

%macro loops; %do i=1 %to &cnt; data _null_; set lst; if _n_ = &i then call symput('sub',subject); run; %put ⊂ ods pdf file="C:\Users\Documents\plot_&sub..pdf" ; goptions reset=all hsize=15cm vsize=10cm; axis2 order=(0 to 6) minor=none; symbol1 interpol=join width=2 color=vligb value=dot height=6; symbol2 interpol=join width=2 color=salmon value=dot height=6; proc gplot data=data1; where subject = "&sub"; by SUBJECT; plot a * b/ overlay vaxis=axis2; run; proc sgplot data=ae; format aestdat date7.; refline 0 / axis=x lineattrs=(color=black); highlow y=aeseq low=aestdy high=aeendy / type=bar group=aesev lineattrs=(color=black pattern=solid) barwidth=0.8 lowlabel=aedecod highcap=highcap attrid=Severity; scatter y=aeseq x=aestdat / x2axis markerattrs=(size=0); xaxis grid display=(nolabel) offsetmax=0.02; x2axis display=(nolabel) offsetmax=0.02 ; yaxis grid display=(noticks novalues nolabel); where subject = "&sub"; by SUBJECT; run; proc print data=dm; where subject = "&sub"; run; ods pdf close; quit; %end; %mend; %loops; ... View more

you asked for: "I don't need to include Visit 1, since Visit 1 is baseline" then why is subject=117962 visit=visit1 score=0  is in the wanted output? and why  subject=117964 visit=visit1 score=0 is in the wanted output?    I am really sorry fo rthe confusion. In the wanted output, I want records by "Subject", which means I want ALL the records of "those Subjects" whose 2 consective visits scores jumped gretaer than 4 points, when I do the comparsion, I don't need to consider the jump between the Visit 1 and Visit 2, I only need to consider the jump (increase) between visit 2 to visit 3, visit 3 to visit 4, and visit 4 to visit 5, when I find that subject, I wnat all his(her) records in the output dataset. I hope it is clear now. ... View more

I want all the records of those subjects who has a jump of more than 4 from the previous visit ... View more

Why did you not include subject_id=117961 visit=visit2 sore=0 in the wanted results where the difference to previous visit is 8-0=8 which is greater then 4 ? [Because the Visit1 is baseline and I only want the jump from Visit 2 and onward.] and why you did include subject_id=117962 visit=visit3 score=4 where the difference to previous visit is -2 which is less then 4 ? [I am only interested in the increase, not the decrease. the difference is more than 4 from the previous one ] ... View more

I want every records of those subject(s) who has a jump of score greater than 4  ... View more