That worked! But the graphs for the original data that I have are not fitting on one page, is there a way to specify the size of each graph so it can fit all 18 graphs on each page? Maybe something with the width/height or the text font? ... View more

Thanks for the advice, I'm definitely getting closer to the final product, but I think i'm missing something within the ODS step b/c something is going wrong. It seems to only be making two rows now. I am hoping to have group1/2/3 A values in row 1, group 1/2/3 B values in row two, and group 1/2/3 values in row 3.  Additionally no helpful information in the Log.      Data dummy_code_g1; input time Baseline_A A Baseline_B B Baseline_C C; datalines; 0 1 2 2 7 80 40 3 2 3 1 6 50 40 6 2 4 1 5 50 40 9 2 5 1 4 50 40 12 2 6 1 3 50 40 15 2 7 1 2 50 40 18 2 8 1 3 50 40 21 2 9 1 4 50 40 24 2 8 1 5 50 40 ;run; Data dummy_code_g2; input time Baseline_A A Baseline_B B Baseline_C C; datalines; 0 2 8 6 1 87 42 3 3 7 1 2 50 42 6 3 6 1 3 50 42 9 3 5 1 4 50 42 12 3 4 1 5 50 42 15 3 3 1 4 50 42 18 3 2 1 4 50 42 21 3 1 1 4 50 42 24 3 4 1 4 50 42 ;run; ODS _all_ reset; ODS PDF file="Dummy_graph.pdf" startpage=no columns=3; ODS graphics / height=2in width=2in; Proc sgplot data=work.dummy_code_g1; Title "Group 1 average values vs Baseline A Values"; series x= time y=baseline_A /markers markerattrs=(Symbol=square); series x=time y=A /markers markerattrs=(symbol=circle); refline 3 / axis=x Label="A Line"; xaxis values=(0 3 6 9 12 15 18 21 24) grid Label= "Time of Collection"; yaxis Label="A" grid; Label baseline_A = 'Baseline A' A = 'Group 1 Average'; run; Proc sgplot data=work.dummy_code_g1; Title "Group 1 average values vs Baseline B Values"; series x= time y=baseline_B /markers markerattrs=(Symbol=square); series x=time y=B /markers markerattrs=(symbol=circle); refline 3 / axis=x Label="A Line"; xaxis values=(0 3 6 9 12 15 18 21 24) grid Label= "Time of Collection"; yaxis Label="B" grid; Label baseline_B = 'Baseline B' B = 'Group 1 Average'; run; Proc sgplot data=work.dummy_code_g1; Title "Group 1 average values vs Baseline C Values"; series x= time y=baseline_C /markers markerattrs=(Symbol=square); series x=time y=C /markers markerattrs=(symbol=circle); refline 3 / axis=x Label="A Line"; xaxis values=(0 3 6 9 12 15 18 21 24) grid Label= "Time of Collection"; yaxis Label="C" grid; Label baseline_C = 'Baseline C' C = 'Group 1 Average'; run; *group 2; Proc sgplot data=work.dummy_code_g2; Title "Group 2 average values vs Baseline A Values"; series x= time y=baseline_A /markers markerattrs=(Symbol=square); series x=time y=A /markers markerattrs=(symbol=circle); refline 3 / axis=x Label="A Line"; xaxis values=(0 3 6 9 12 15 18 21 24) grid Label= "Time of Collection"; yaxis Label="A" grid; Label baseline_A = 'Baseline A' A = 'Group 2 Average'; run; Proc sgplot data=work.dummy_code_g2; Title "Group 2 average values vs Baseline B Values"; series x= time y=baseline_B /markers markerattrs=(Symbol=square); series x=time y=B /markers markerattrs=(symbol=circle); refline 3 / axis=x Label="A Line"; xaxis values=(0 3 6 9 12 15 18 21 24) grid Label= "Time of Collection"; yaxis Label="B" grid; Label baseline_B = 'Baseline B' B = 'Group 2 Average'; run; Proc sgplot data=work.dummy_code_g2; Title "Group 2 average values vs Baseline C Values"; series x= time y=baseline_C /markers markerattrs=(Symbol=square); series x=time y=C /markers markerattrs=(symbol=circle); refline 3 / axis=x Label="A Line"; xaxis values=(0 3 6 9 12 15 18 21 24) grid Label= "Time of Collection"; yaxis Label="C" grid; Label baseline_C = 'Baseline C' C = 'Group 2 Average'; run; ods PDF close;     ... View more

This macro did not provide the right output as all the graphs are graphing the same data, additionally there are only three groups, that i want to be displayed in each column downwards, and then each row is a different variable, to get a comparison of the data as you look across the groups.   And the variables are not in a particular order such as A..B..C in the real dataset so I dont think a macro would work easily here.  ... View more

Sorry for the delay. Here is the code i am using with datasets... so in this code im trying to fit 2 columns with 3 rows (6 tables total), but im trying to extrapolate this to the real dataset where there are 3 groups (instead of two) that have 12 variables (i.e. Baseline_A, A, Baseline_B, B,...Baseline_F, F) (18 tables total)  I have also attached the PDF file that it creates.      Data dummy_code_g1; input time Baseline_A A Baseline_B B Baseline_C C; datalines; 0 1 2 2 7 80 40 3 2 3 1 6 50 40 6 2 4 1 5 50 40 9 2 5 1 4 50 40 12 2 6 1 3 50 40 15 2 7 1 2 50 40 18 2 8 1 3 50 40 21 2 9 1 4 50 40 24 2 8 1 5 50 40 ;run; Data dummy_code_g2; input time Baseline_A A Baseline_B B Baseline_C C; datalines; 0 2 8 6 1 87 42 3 3 7 1 2 50 42 6 3 6 1 3 50 42 9 3 5 1 4 50 42 12 3 4 1 5 50 42 15 3 3 1 4 50 42 18 3 2 1 4 50 42 21 3 1 1 4 50 42 24 3 4 1 4 50 42 ;run; ODS graphics / reset=all; ODS PDF file="Dummy_graph.pdf" startpage=no; ODS layout start columns=3 rows=6;* width=10in height=8in column_gutter=.5in row_gutter=.8in row_heights=(3.5in 3.5in);; title; ODS region row=1 column=1; Proc sgplot data=work.dummy_code_g1; Title "Group 1 average values vs Baseline A Values"; series x= time y=baseline_A /markers markerattrs=(Symbol=square); series x=time y=A /markers markerattrs=(symbol=circle); refline 3 / axis=x Label="A Line"; xaxis values=(0 3 6 9 12 15 18 21 24) grid Label= "Time of Collection"; yaxis Label="A" grid; Label baseline_A = 'Baseline A' A = 'Group 1 Average'; run; Proc sgplot data=work.dummy_code_g1; Title "Group 1 average values vs Baseline B Values"; series x= time y=baseline_B /markers markerattrs=(Symbol=square); series x=time y=B /markers markerattrs=(symbol=circle); refline 3 / axis=x Label="A Line"; xaxis values=(0 3 6 9 12 15 18 21 24) grid Label= "Time of Collection"; yaxis Label="B" grid; Label baseline_B = 'Baseline B' B = 'Group 1 Average'; run; Proc sgplot data=work.dummy_code_g1; Title "Group 1 average values vs Baseline C Values"; series x= time y=baseline_C /markers markerattrs=(Symbol=square); series x=time y=C /markers markerattrs=(symbol=circle); refline 3 / axis=x Label="A Line"; xaxis values=(0 3 6 9 12 15 18 21 24) grid Label= "Time of Collection"; yaxis Label="C" grid; Label baseline_C = 'Baseline C' C = 'Group 1 Average'; run; *group 2; Proc sgplot data=work.dummy_code_g2; Title "Group 2 average values vs Baseline A Values"; series x= time y=baseline_A /markers markerattrs=(Symbol=square); series x=time y=A /markers markerattrs=(symbol=circle); refline 3 / axis=x Label="A Line"; xaxis values=(0 3 6 9 12 15 18 21 24) grid Label= "Time of Collection"; yaxis Label="A" grid; Label baseline_A = 'Baseline A' A = 'Group 2 Average'; run; Proc sgplot data=work.dummy_code_g2; Title "Group 2 average values vs Baseline B Values"; series x= time y=baseline_B /markers markerattrs=(Symbol=square); series x=time y=B /markers markerattrs=(symbol=circle); refline 3 / axis=x Label="A Line"; xaxis values=(0 3 6 9 12 15 18 21 24) grid Label= "Time of Collection"; yaxis Label="B" grid; Label baseline_B = 'Baseline B' B = 'Group 2 Average'; run; Proc sgplot data=work.dummy_code_g2; Title "Group 2 average values vs Baseline C Values"; series x= time y=baseline_C /markers markerattrs=(Symbol=square); series x=time y=C /markers markerattrs=(symbol=circle); refline 3 / axis=x Label="A Line"; xaxis values=(0 3 6 9 12 15 18 21 24) grid Label= "Time of Collection"; yaxis Label="C" grid; Label baseline_C = 'Baseline C' C = 'Group 2 Average'; run; ods layout end; ods PDF close;   ... View more

I can't post the PDF as its sensitive information, but Only one Large graph is being posted on each PDF page, versus all graphs (18 of them) being on one page just in much smaller versions... I'm not sure if i need to play around with the height/width of the graphs to make them all fit, but the problem seems like when they are too big they just get pushed to the next page versus being all on one.      ... View more

This is working well so far, but I have groups where there are four participants and many of the plots axis are not properly displaying. Currently have the below code   Data sheep.group3_V_Lactate; set work.venous_long; where Group= 3 and Measurement= 'Lactate'; run; proc summary data=sheep.group3_V_Lactate; class Sheep_name time_point; format time_point time_point_FMT.; var value; output out=work.group3_V_Lactatesum mean=; run; Data Sheep.group3_V_Lactate2; length Sheep_name $ 8; set work.group3_V_Lactatesum; where _type_ in(1,3); if _type_ = 1 then Sheep_name='Average'; run; proc sgplot data=sheep.group3_V_Lactate2; Title "Group 3 Venous Lactate levels"; Series x=time_point y=Value / group=Sheep_name markers; refline 0 / axis=x label= "Surgery"; xaxis min=-1 max=24 minor grid values= (-1 0 1 3 6 9 12 15 18 21 24); xaxis label = "Time of Collection Since Surgrey (hours)"; yaxis values=(0,0.5,1.0,1.5,2.0,2.5,3.0,3.5,4.0,4.5,5.0,5.5,6.0,6.5,7.0,7.5,8.0,8.5,9.0,9.5, 10.0,10.5,11.0,11.5,12.0,12.5,13.0,13.5,14.0,14.5,15.0) grid; yaxis label = "mmol/L"; run;   Producing the attached graph: Any thoughts on trouble shooting the graph?   ... View more