Dear All,   I'm working with PROC SGPANEL to create side-by-side bar charts for two different metrics (e.g., Response Rate and Adverse Event Rate), each associated with a distinct set of treatment groups: Response Rate: Treatments 1, 2, 3 Adverse Event Rate: Treatments 4, 5, 6 The issue: When using PROC SGPANEL , I get empty categories (Trt4, Trt5, Trt6) displayed in the Response panel, and Trt1–3 in the Adverse panel — even though those combinations do not exist in the data. I've tried using: categoryorder=data layout=columnlattice and onepanel Formatting Treatment with proc format But the empty bars still appear.   Below is my SAS code for you reference. how can this be fixed?   data treatment_data; input Treatment Metric $ Value; datalines; 1 ResponseRate 75 2 ResponseRate 65 3 ResponseRate 80 4 AdverseEventRate 20 5 AdverseEventRate 25 6 AdverseEventRate 15 ; run; /* Create dynamic treatment labels */ data treatment_data_labeled; set treatment_data; length TreatmentLabel $10; TreatmentLabel = "Trt" || strip(put(Treatment, 1.)); run; ods graphics / width=800px height=400px; proc sgpanel data=treatment_data_labeled; panelby Metric / onepanel novarname; vbar TreatmentLabel / response=Value datalabel fillattrs=(color=steelblue) stat=mean; colaxis display=(nolabel); rowaxis label="Percentage"; title "Bar Charts for Treatments by Metric"; run;   Thanks a lot fotr your help ... View more

Hello,   I would like to run a clustered log rank test. I used the following SAS macros from github: https://github.com/mstedman2/logrank-macro?tab=readme-ov-file but I'm getting erros when I run it on sample data in SAS studio. Could you help or guide me to a similar macros? Thanks in advance   Here is my code: data samp_data; do i = 1 to 1000; /* Generate random time */ time_var = floor(rand('Uniform') * 730); /* Generate random number between 0 and 1 */ rand_num = rand('Uniform'); /* Assign 1 if random number > 0.5, else assign 0 */ censor_var = (rand_num > 0.5); /* Generate random group */ if rand_num > 0.6 then group_var="A"; else group_var="B"; /* Generate clusters */ x = rand('Uniform'); y = rand('Uniform'); /* Assign clusters based on conditions */ if i < 150 then cluster_var = 1; else if i <450 then cluster_var = 2; else cluster_var = 3; output; keep time_var cluster_var group_var censor_var; end; run; %clusterlr (datain=samp_data, time=time_var, cluster=cluster_var, group=group_var, censor=censor_var); quit;   Here is an example of errors:   ... View more

I would like to combine 100 rtf files in one rtf file using SAS studio. Thanks for your help. ... View more

Hello,   I have a variable text that contains some parameters like Basophils (10^9/L) and it is displaying correctly when I open the SAS dataset but when I run proc freq or I use proc report it becomes Basophils (10/L).   Could you help? Thanks a lot in advance.   Here is the proc report code I'm using.   proc report data=reportDSN missing nowindows split='@'             style(header)=[rules=group frame=above verticalalign=top background=white font_size=9pt]              style(report)=[outputwidth=100% rules=group frame=hsides background=white font_size=9pt]               style(column)=[rules=group font_size=9pt] spanrows; columns pagebreak param_new text visn ord2 stat ("&trt1.^S={borderbottomcolor=black borderbottomwidth=2} " aval1 chg1)  ("&trt2.^S={borderbottomcolor=black borderbottomwidth=2} " aval2 chg2) ("&trt3.^S={borderbottomcolor=black borderbottomwidth=2} " aval3 chg3); define  pagebreak / order order=data noprint; define  param_new / order order=data noprint; define  text / order order=data noprint; define  ord2 / order order=data noprint; define  visn / order order=data noprint;   define stat / display style(column)=[width= 2.0cm asis=on just=l] style(hdr)=[asis=on just=l] "Parameter (unit)^n ^_^_Time Point^n ^_^_^_^_Statistic";  define aval1   / display style(column)=[width= 1.5cm asis=on just=c] style(hdr)=[asis=on just=c] "Value"; define chg1    / display style(column)=[width= 1.5cm asis=on just=c] style(hdr)=[asis=on just=c] "Change from^nBaseline"; define aval2   / display style(column)=[width= 1.5cm asis=on just=c] style(hdr)=[asis=on just=c] "Value"; define chg2    / display style(column)=[width= 1.5cm asis=on just=c] style(hdr)=[asis=on just=c] "Change from^nBaseline"; define aval3   / display style(column)=[width= 1.5cm asis=on just=c] style(hdr)=[asis=on just=c] "Value"; define chg3    / display style(column)=[width= 1.5cm asis=on just=c] style(hdr)=[asis=on just=c] "Change from^nBaseline"; break after pagebreak /page; compute before text / style=[font_face="Courier New" font_style=Roman]; line @1 text $200.; endcomp; compute before visn / style=[font_face="Courier New" font_style=Roman]; line @1 visn vis.; endcomp; compute after visn; line " "; endcomp; run; ... View more

I would like to make only part of headers ("CTCAE" in my example) justified left and keep "Last Value Assessed" center justified by using PROC REPORT.    Thanks in advance for your help.   PROC REPORT data=reportDSN missing nowindows split='@' style(header)=[just=c] style(report)=[outputwidth=100% rules=group frame=hsides background=white font_size=9pt] style(column)=[rules=group font_size=9pt] spanrows; columns pagebreak grp ("CTCAE" stat1) stat2 ("Last Value Assessed"_1 _2 _3 _4 _5 _99); ... View more