Hello all, I use the SG PANEL procedure including a "BY" statement in the code below to produce the following graphs:   proc sgpanel data=_011; by gcs_group; panelby order/columns=5 novarname; scatter x=o_discharge_fiscal_year y=los_sans_alc_mean / LEGENDLABEL= "All cases"                                                                                              MARKERATTRS=(symbol=circlefilled color=red size=10)                                                                                              TRANSPARENCY=0.3                                                                                              DATALABEL=los_sans_alc_mean                                                                                              DATALABELATTRS=(color=black size=4)                                                                                              DATALABELPOS=top; rowaxis values=(5 to 50 by 10) valueattrs=(size=7) grid; colaxis grid valueattrs=(size=7); title h=12pt justify=left italic 'Figure 7: Average LOS by hospital by ISS'; footnote ' '; format order hosp_order. los_sans_alc_mean 4.1; run;       As you can see, because the the y-axis values that creates those two figures are very different from each other (the first figure values range between 6.3 and 14.1 and the second figure between 1.0 and 45.6) and I use only one "ROWAXIS" statement in the code, the values in the first graph has the illusion of "stability" (i.e. supressed by the values I choose in the ROWAXIS statement).   I was wondering if there is any way to assign different values to each y-axis based on the variable in the "BY" statement? In this case for instance something like, for Figure 1 (GCS:13-15) rowaxis values=(5 to 15 by 5) and for Figure 2 (GCS:3-8) rowaxis values=(5 to 50 by 10). Perhaps the easiest way to write two seperate SG PANEL codes?   Thanks in advance!   Recep ... View more

Hello there, I'm trying to understand how to create a regression analysis code depending on if the intercept and/or slope varies based on some group variables. Below is a hypothetical dataset with 15 students nested in 3 schools. Their passing an exam is correlated with their family income and the school they attend to which is the nesting variable.   Student_ID PASS FAMILY_INCOME SCHOOL 1 1 120000 sch1 2 1 170000 sch1 3 0 90000 sch1 4 0 91500 sch1 5 0 93000 sch1 6 1 180000 sch1 7 1 225000 sch1 8 1 150000 sch1 9 1 90000 sch2 10 1 92000 sch2 11 1 94000 sch2 12 0 78000 sch2 13 1 110000 sch3 14 0 50000 sch3 15 1 140000 sch3   If I want to write a regression analysis with constant intercept and slope for each school:    I would: PROC LOGISTIC DATA = TEST; MODEL PASS = FAMILY_INCOME; RUN;   If I want to write a regression analysis with varying intercept but constant slope for each school:   where   I would: PROC LOGISTIC DATA = TEST; CLASS SCHOOL (ref="sch1"); MODEL PASS = FAMILY_INCOME SCHOOL; RUN;   If I want to write a regression analysis with varying intercept and slope for each school:   where   Now, my questions are:   1. Did I get the varying intercept constant slope model in PROC LOGISTIC right? 2. How would I write the PROC LOGISTIC to accommodate varying intercept and slope for each hospital?   Thanks a lot in advance!   Recep ... View more

Hello there,   I'm trying to create a graph with SGPLOT that shows rates by hospitals in two seperate panels: Level_1_2 and Level_3. With the dataset I'm currently using, the problem is, I cannot divide the panels the way I want it. The final graph is supposed to have the rates for each hospital within their "level". Currently the graph I produce includes Level_3 hospitals in the Level_1_2 panel and Level_1_2 hospitals in the Level_3 panel. Do you think I set up my dataset not "optimally" or am I missing something in the SGPANEL?   Also, if its a possibility I would like to create two seperate REFLINES for each panel.   Thanks a lot for your help in advance!   Here are my dataset, code, and the graph.   hosp_name level cpred_final clower_final cupper_final VGH Level_1_2 27.8587 26.0588 29.7581 VicGH Level_1_2 21.7479 19.824 23.8298 RCH Level_1_2 19.2273 17.5596 21.0323 KGH Level_1_2 19.0601 16.8262 21.5502 RIH Level_1_2 17.7454 15.5962 20.1532 UHNBC Level_3 13.5041 11.1077 16.3623 NRGH Level_3 10.9852 9.0805 13.2551 LGH Level_3 10.9797 9.2928 12.9473 ARH Level_3 10.4652 8.5618 12.757 SPH Level_3 8.8174 6.8647 11.2857   proc sgpanel data=Results noautolegend; panelby level/columns=2 novarname; rowaxis values=(0 to 30 by 5) grid; colaxis grid; scatter x=hosp_name y=cpred_final / markerattrs=(symbol=circle color=red size=8) DATALABEL=cpred_final DATALABELATTRS=(color=black /*weight=bold*/) DATALABELPOS=right yerrorlower=clower_final yerrorupper=cupper_final; refline 21.13 10.95/label=('Level 1&2 average: 21.1%' 'Level 3 average: 11.0%'); title h=12pt justify=left bold italic 'Figure 2: Adjusted predictions at the average risk score by hospital'; format cpred_final 4.1; run;   ... View more

Hello there,   I'm having an issue after I produce a graph, such as via PROC SGPLOT, and try to copy it from SAS and paste it to Mcrosoft Office products. The resoulution of the graph is great when I see it within SAS via output window but when I right-click on the graph in the SAS output window, copy and paste it to Word the picture is way less crispy compared to how I see it in SAS. Is there a better way to copy and paste graphs from SAS to MS Office products?   Thanks a lot in advance,   Recep  ... View more