I am in the process of recreating the graph below, which was originally created in Excel, using SAS. The graph appears as follows: In SAS Studio, I am encountering the following error: "ERROR: The same group variable must be used for summarized plots." Any assistance in resolving this issue would be greatly appreciated. Code and data are as follows:   /* Sample Data */ data incidence;     input Group $ Subgroup $ CumulativeIncidence;     datalines; A 1-34A 0.54 A 1-34B 0.42 A 1-34C 0.46 A 1-34D 0.42 A 1-34E 0.37 B 3-34B 0.39 B 3-34C 0.35 B 3-34D 0.43 B 3-34E 0.48 C 3-39A 0.45 C 3-39B 0.44 C 3-39C 0.50 C 3-39D 0.41 C 3-39E 0.35 D 4-39A 0.20 D 4-39B 0.28 D 4-39C 0.29 D 4-39D 0.24 ; run; /* Extract subgroup suffix for consistent coloring */ data incidence;     set incidence;     SubgroupSuffix = scan(Subgroup, -1, '-'); /* Extract last part (e.g., A, B, C) */ run; /* Compute Group and Overall Averages */ proc means data=incidence noprint;     by Group;     var CumulativeIncidence;     output out=group_avg mean=GroupAvg; run; proc means data=incidence noprint;     var CumulativeIncidence;     output out=overall_avg mean=OverallAvg; run; /* Add Overall Average to Each Row */ data overall_avg;     if _n_ = 1 then set overall_avg;     set incidence; run; /* Merge Group Average with the Data */ proc sort data=incidence; by Group; run; proc sort data=group_avg; by Group; run; data incidence_plot;     merge incidence group_avg overall_avg;     by Group;     format GroupAvg 10.2 OverallAvg 10.2; run; /* Create the Plot */ proc sgplot data=incidence_plot;     vbar Group / response=CumulativeIncidence                 group=SubgroupSuffix /* Color by subgroup suffix */                 groupdisplay=cluster                 datalabel /* Show values above bars */                 datalabelattrs=(size=10);                     vline Group / response=GroupAvg                 group=Group /* Use Group to plot the average correctly */                 lineattrs=(thickness=2 color=red)                 markers;         refline OverallAvg / axis=y lineattrs=(thickness=2 color=blue pattern=shortdash);         xaxis discreteorder=data label="Groups";     yaxis label="Cumulative Incidence";         keylegend / title="Subgroup (Color Key)" noborder;         title "Cumulative Incidence by Group with Averages"; run; ... View more

 I am having a hard time finding out how to drop the zeros after round. For example, i have data like 842855. After using the round function, the  data is like this 843000. however, I would like the data to show 843. ... View more

I have a very large dataset which contains a string a number formatted as characters and I would like to  add additional characters to the beginning of each number. Is there a way to accomplish this without  having to write conditional statements?   Below is an example of the dataset: string  grp 1 150,160,252,582,360 2 225,587,331,452,589   And this is what I am trying to achieve: string  grp 1 AX150, AX160, AX252, AX582, AX360 2 YL225, YL587, YL331, YL452, YL589 ... View more