NEED HELP - graph with values and valuesdisplay option LOOKS GOOD - graph without values and valuesdisplayoption ... View more

  NEED HELP - With values & values displayoptions LOOKS GOOD -Without values & valuesdisplay options/*SAS Code below*/ proc format; picture fmt low-high='9'(prefix="Q"); run; data have; call streaminit(123); do year = 2017 to 2020; do month= 1 to 12; qtr= ceil(month/3); value=rand('integer', 1, 100); output; end; end; format qtr fmt2.; run; data have; set have; if year=2017 and month eq 1 then delete; if year=2020 and month in (2:12) then delete; run; **Graph w/o values & valuesdisplay options - looks as expected**; **Graph w values & valuesdisplay options - NEED HELP - includes all quarters**; ods graphics/reset attrpriority=none width=13in height=8in ; proc sgpanel data = have; panelby year/layout=columnlattice onepanel spacing=0 noborder colheaderpos=bottom novarname uniscale=row proportional; block x=month block=qtr/nooutline novalues filltype=alternate fillattrs=(color=white) altfillattrs=(color=white); vbarparm category=month response=value ; colaxis label= ' ' valuesrotate=diagonal ; /*values=( 2 3 4 5 6 7 8 9 10 11 12 /*2017*/*/ /* 1 2 3 4 5 6 7 8 9 10 11 12 /*2018*/*/ /* 1 2 3 4 5 6 7 8 9 10 11 12 /*2019*/*/ /* 1 /*2020*/*/ /*valuesdisplay= ("Q1" "" "" "Q2" "" "" "Q3" "" "" "Q4" "" "" /*2017*/*/ /* "Q1" "" "" "Q2" "" "" "Q3" "" "" "Q4" "" "" /*2018*/*/ /* "Q1" "" "" "Q2" "" "" "Q3" "" "" "Q4" "" "" /*2019*/*/ /* "Q1"/*2020*/*/ ; rowaxis label= ' '; run;   ... View more

Thank you. When I add the uniscale and proportional options, it works fine till I add 'values' and 'valuesdisplay' options. The graph reverts back to showing data for all months for 2022.  ... View more

Thank you so much, this worked well! I had 2 follow-up questions: My data only has values till 1/2022, why does the graph display all months for 2022? Is there a way to correct this? Eventually I want to use the values & valuesdisplay options so I can specify what the values should be. I want to remove the block values, but when I add novalues option to the block statement, it reverts back to default options with a warning 'Too many display features were removed from the BLOCK plot. Defaulting to standard options'. Is there any workaround for this? Here's my code & output: proc sgpanel data=have ; panelby year/layout=columnlattice onepanel spacing=0 noborder colheaderpos=bottom novarname; block x=month block=qtr/nooutline nofill; vbarparm category=month response=value/group=arm groupdisplay=cluster; colaxis label=' ' valuesrotate=diagonal; rowaxis label=' ' min=0 max=50; run;  Output:   ... View more

Thank you, this extremely helpful. I am able to plot the graph with panels for each year from 2017-2022 by quarter, also adding a grouping variable. I have one follow-up question: The code currently creates these graphs by quarter. I need to plot the data by month, but display Q1, Q2, Q3, Q4 with the panels for each year. Is that possible to do? Here's what I have so far:       ... View more