About DanH_sas

SamR

Thank you so much for the responses. Added in lineattrs=GraphData&r. works!

MFraga

Thanks for the information about the show column. I will read more about what are the other atributes that I can integrate in my graph.

Ksharp · ‎08-13-2025

%let label1=XAXIS Label(*ESC*){sub 'L'} ; %let label2=YAXIS Label(*ESC*){sup 'L'} ; data _anno; length label $ 200; drawspace="layoutpercent"; function="text"; textweight="normal"; textsize=12;textcolor="black"; width=200; x1=50; y1=2.5;label="&label1."; output; x1=2.5; y1=50;rotate=90;label="&label2."; output; run; proc sgplot data=sashelp.class sganno=_anno; scatter x=weight y=height; xaxis label=' '; yaxis label=' '; run;

Ksharp · ‎08-08-2025

data a; input category $ group $ v lower upper p $; if group='Ole' then v1=v; if group='Ola' then v2=v; max=max(v,lower,upper,0); cards; Trig Ole -49.3 -52.3 -46.2 p<0.01 Trig Ola -64.3 -68.3 -58.2 p<0.01 APOC Ole -69.3 -75.3 -60.2 p<0.01 APOC Ola -79.3 -85.3 -68.2 p<0.01 VLDL Ole 49.3 42.3 55.2 p<0.01 VLDL Ola 40.3 35.3 48.2 p<0.01 ; proc sgplot data=a; styleattrs datacolors=(yellow gold) ; vbarparm category=category response=v1 /fillattrs=(color=white) groupdisplay=cluster group=group nooutline datalabel=v1 discreteoffset=-0.1; vbarparm category=category response=v2 /fillattrs=(color=white) groupdisplay=cluster group=group nooutline datalabel=v2 discreteoffset=0.1; scatter x=category y=max/group=group groupdisplay=cluster markerattrs=(size=0) datalabel=p datalabelpos=top datalabelattrs=(color=black) labelstrip; vbarparm category=category response=v / groupdisplay=cluster group=group nooutline limitlower=lower limitupper=upper LIMITATTRS=(color=black) name='x' ; keylegend 'x'/location=inside position=top; xaxis display=(nolabel); run; /*************************************/ data b; infile cards truncover; input group day v lower upper text $20.; cards; 1 0 200 180 210 1 1 150 120 160 1 2 120 110 128 1 3 110 102 118 1 6 109 101 112 1 10 105 100 110 2 0 210 190 220 2 1 160 130 170 2 2 110 120 138 2 3 120 112 128 2 6 119 111 122 2 10 115 110 120 . 8 124 . . TreatA|(n=26) . 8 102 . . TreatB|(n=26) ; proc sgplot data=b; series x=day y=v/group=group nomissinggroup; scatter x=day y=v/group=group nomissinggroup yerrorupper=upper yerrorlower=lower markerattrs=(symbol=circlefilled); xaxis type=linear values=(0 to 10 by 1) display=(nolabel noticks) valuesdisplay=('Baseline' 'Day28' 'Day56' 'Day84' '' '' 'Day252' '' '' '' 'Day308'); text x=day y=v text=text/strip contributeoffsets=none splitchar='|' splitpolicy=splitalways; run;

DanH_sas · ‎06-13-2025

How about something like this: /* Two original data sets with different bar counts and value lengths */ data one; do x=1 to 5; y=ranuni(123); group="Group 1"; output; y=ranuni(123); group="Group 2"; output; end; run; data two; do x=1000 to 3000 by 1000; y=ranuni(321); group="Group 1"; output; y=ranuni(321); group="Group 2"; output; end; run; /* Merge the two data datasets with a classifier column */ data one_prime; set one; name = "one"; run; data two_prime; set two; name = "two"; run; data merged; merge one_prime two_prime; by name; run; proc sgpanel data=merged; panelby group name / layout=lattice onepanel proportional uniscale=column novarname; hbar x / response=y; run;

DanH_sas · ‎06-04-2025

What you want is the following: vbar subjid/response = pchg categoryorder=respdesc; This will put the bars in descending response order.

StudentSASLearn · ‎06-03-2025

Perfect. Thank you @Ksharp

Jay_2023 · ‎06-02-2025

Thank you.

_Hopper · ‎05-28-2025

I got it - GROUPMC option. Thanks!

Ksharp · ‎05-26-2025

proc import datafile='C:\Users\xiakeshan\Documents\Downloads\dtr.xlsx' out=have dbms=xlsx replace; run; data one; set have; if strip(Variety)='GEM' then Variety=' GEM'; DTR=input(DTR__days_to_ripe_,best.); run; proc sgpanel data=one ; styleattrs datacolors=(red blue) datacontrastcolors=(red blue) ; where Season in(2021, 2022, 2023) and Harvest__month_ in(1,3,4,5,6,8) and strip(Variety) in ('GEM','Hass'); panelby Season/rows=1 onepanel ; vline Harvest__month_/response=DTR group=Variety grouporder=ascending markers markerattrs=(symbol=circlefilled) TRANSPARENCY=0 stat=mean ; rowaxis values=(0 to 12 by 2) ; run;

Ksharp · ‎05-05-2025

An alternative way is using valuesdisplay= option: proc sgplot data=sashelp.stocks; where year(date) in ( 2001 2002 ); series x=date y=close/group=stock; Xaxis label="Monthly time series data" values=("01JAN2001"d to "01jan2002"d by month) valuesdisplay=('Jan01' ' ' ' ' 'Apr01' ' ' ' ' 'Jul01' ' ' ' ' 'Oct01' ' ' ' ' 'Jan02') type=linear ; run;

Ksharp · ‎04-29-2025

You also could try CURVELABEL= option to make your graph look pretty. proc sgpanel data=sashelp.stocks NOAUTOLEGEND ; panelby stock/onepanel columns=1; series x=date y=close/curvelabel='close' curvelabelpos=max; series x=date y=open/curvelabel='open' curvelabelpos=max; run;

Mscarboncopy · ‎04-24-2025

Thank you! I tried that and it did not work but I might be doing something wrong. I also tried to use format percent8.0 to get rid of the decimals (another option)... but I do not have a Percent variable, I am creating that variable in the graph and I tried several places on my code but it won't let me format the var Percent that is being created for the graph as I showed in my original post. This is my entire code ODS GRAPHICS ON / RESET IMAGENAME="Fig1" IMAGEFMT=png ANTIALIASMAX=10000; GOPTIONS RESET=ALL BORDER CBACK=WHITE HTITLE=12PT HTEXT=25PT ftext='Bold'; OPTIONS CLEANUP; proc Gchart Data=have vbar3d Greetings /TYPE=PERCENT annotate=have inside=PERCENT patternid=midpoint width=20 space=5 maxis=axis1 raxis=axis2 gaxis=axis3; coutline=black; axis logbase=2 logstyle=expand order=(1,2,3); axis2 label=(angle=90 'Percent'); run; quit; ODS GRAPHICS OFF; run;

DanH_sas · ‎04-23-2025

Add the ONEPANEL option to the PANELBY statement.

MFraga · ‎04-08-2025

Thank you both @DanH_sas and @Ksharp for providing solutions! I'll read more about the options DATTRMAP and RATTRMAP.

Online Status	Online
Date Last Visited	2m ago

Re: SGPlot density plot - issues with line colour in rtf output

Re: How to exclude missing values in hbarparam of sgplot

Re: Is it possible to make a barchart showing multiple text values and...

Re: Is it possible to make a barchart showing multiple text values and...

Re: Proc Template panel size

Re: How to order the Bars and display the labels from other var in PRO...

Re: Create Box Plot without Box statement in Proc Template

Re: SGPANEL Spaghetti Plot - Different Colors for all Lines in Each Pa...

Re: Adding significance symbols in all panels in sgpanel

Re: How to Display the Counts in the Discrete Legends for Box Plot in ...

Re: PROC SGPLOT: How to customize boxplot legends

Re: Varied Line Color, How to do it?!

Re: SGPlot density plot - issues with line colour in rtf output

Re: Customize fonts using attribute map

Re: Graph Recreation

Re: How to exclude missing values in hbarparam of sgplot

Re: Is it possible to make a barchart showing multiple text values and...

Re: Proc Template panel size

Re: How to order the Bars and display the labels from other var in PRO...

Re: SGPANEL Spaghetti Plot - Different Colors for all Lines in Each Pa...

Creating Oncology Figures Using ODS Graphics Q&A, Slides, and On-Deman...

How Do I Show Geographical Data Using the SGMAP Procedure?® Q&A, Slide...

Re: SGPlot density plot - issues with line colour in rtf output

Re: How to exclude missing values in hbarparam of sgplot

Re: How to get the subscript and superscript in proc sg plot.

Re: Is it possible to make a barchart showing multiple text values and...

Re: Proc Template panel size

Re: How to order the Bars and display the labels from other var in PRO...

Re: Create Box Plot without Box statement in Proc Template

Re: How to Display the Counts in the Discrete Legends for Box Plot in ...

Re: SGPANEL Spaghetti Plot - Different Colors for all Lines in Each Pa...

Re: Adding significance symbols in all panels in sgpanel

Re: Varying x-axis tick marks in sgplot

Re: Identifying lines in a plot created with SGPanel

Re: Cleaning up a 3D chart

Re: help with plot left Y axis chg and right Y axis Pk Conc and X axis...

Re: Customize colors for specific levels of the variable of interest.

SAS Global Forum 2017

SAS Global Forum 2018

SAS Global Forum 2016