cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
t75wez1
‎04-16-2025
  • 120 Posts
  • 22 Likes Given
  • 2 Solutions
  • 9 Likes Received

Re: How to create nested bars within a bar in base SAS?

by Pyrite | Level 9 in Graphics Programming
‎05-22-2022 11:57 PM
‎05-22-2022 11:57 PM
Here is the result. ... View more

Re: How to create nested bars within a bar in base SAS?

by Pyrite | Level 9 in Graphics Programming
‎05-20-2022 05:58 PM
‎05-20-2022 05:58 PM
Thanks so much  for your help. Below is my code based on your suggestion. It's not perfect. For instance, the edge of colors on nested bars doesn't match the colors of bars ifself. Also don't know how to customized legend to match the the example of graph.  I'm appreciative of any help you may provide. Ethan   %let name=Nested_bars; filename odsout '.'; ODS LISTING CLOSE; ODS HTML path=odsout body="&name..htm" (title="&name.") style=htmlblue; ods graphics / noscale /* if you don't use this option, the text will be resized */ imagemap tipmax=2500 imagefmt=png imagename="&name" width=800px height=600px noborder; title1 h=13pt color=purple "Retail Sales"; proc sgplot data=sashelp.retail noborder; where year < 1985; styleattrs backcolor=white wallcolor=white datacolors=(cxe6eef7 cxc7e3ff cx89cbf2 cx1d94da cx377eb8 ); vbarbasic year/ response=sales barwidth=0.95 fillattrs=(color=aliceblue) transparency=0.4 datalabel DATALABELATTRS=(Color=grey55 Family="Arial" Size=8 Style=normal Weight=Bold) ; vbarbasic year/ response= sales group= date BARWIDTH=0.85 transparency=0.4 groupdisplay=cluster clusterwidth=0.97 datalabel DATALABELATTRS=(Color=black Family="Arial" Size=6 Style=normal Weight=Bold); xaxis display=(noline nolabel) valueattrs=(color=black size=8.0pt Weight=Bold) ; yaxis display=(noline noticks) labelattrs=(color=gray33 size=8pt Weight=Bold) labelpos=top values=(0 to 1600 by 400) valueattrs=(color=gray33 size=8pt Weight=Bold) offsetmin=0 offsetmax=0 ; refline 400 800 1200 1600 /axis=y lineattrs=(color=lightgray thickness=1.2 pattern=shortDash); *keylegend / noborder position=bottom ; format date qtr.; label date= 'Quarter' ; run; quit; ODS HTML CLOSE; ODS LISTING;     ... View more

Re: How to create nested bars within a bar in base SAS?

by Pyrite | Level 9 in Graphics Programming
‎05-20-2022 12:06 PM
‎05-20-2022 12:06 PM
Cynthia, Thanks for the response.  The input SAS data set named "SASHELP.RETAIL" is not same as the data set used for building the graph in SAS Viya from the link below. https://communities.sas.com/t5/Graphics-Programming/How-to-create-nested-bars-within-a-bar-in-base-SAS/m-p/814365#M22836       ... View more

How to create nested bars within a bar in base SAS?

by Pyrite | Level 9 in Graphics Programming
‎05-19-2022 04:35 PM
‎05-19-2022 04:35 PM
Hi,  I would be grateful if anyone could show how to create the nested bar within a bar graph looks like below in base SAS 9.4 M7.   The input SAS data set can be used here data retail; set sashelp.retail; run;   Thanks, Ethan   ... View more

Re: How to randomly select responses with replacement, but evenly dist...

by Pyrite | Level 9 in Statistical Procedures
‎05-02-2022 10:47 AM
‎05-02-2022 10:47 AM
Hello FreelanceRehard, I got the email stated that "Great job! You marked your answer to a question as an accepted solution!" and I don't see "Not the solution" option from "Show option menu" you indicated. Thank you.     ... View more

Re: How to randomly select responses with replacement, but evenly dist...

by Pyrite | Level 9 in Statistical Procedures
‎05-01-2022 11:08 PM
‎05-01-2022 11:08 PM
Hi PGStats, It works perfectly. Thanks a ton for the sublime solution you provided. ... View more

Re: How to randomly select responses with replacement, but evenly dist...

by Pyrite | Level 9 in Statistical Procedures
‎04-30-2022 07:50 PM
‎04-30-2022 07:50 PM
Thanks PGStats, What if I want to have the sample size greater than 20 in "proc surveyselect". so some of responses could be re-selected for certain age groups. How to make a change in your code below?   ... View more

How to randomly select responses with replacement, but evenly distribu...

by Pyrite | Level 9 in Statistical Procedures
‎04-30-2022 03:43 PM
‎04-30-2022 03:43 PM
Hi, I am looking at a survey data set of 694 responses who are in 12 different age groups but the distribution of responses heavily skew to younger age groups.   My question is how to randomly select those 694 responses with replacement, but evenly distributed across 12 age groups?   Many thanks, Ethan     ... View more

Re: How to fit my data to Gamma,  Weibull and Lognomal distributions?

by Pyrite | Level 9 in Statistical Procedures
‎11-21-2021 05:21 PM
‎11-21-2021 05:21 PM
Many thanks for your helps. You made my day!   ... View more

Re: How to fit my data to Gamma,  Weibull and Lognomal distributions?

by Pyrite | Level 9 in Statistical Procedures
‎11-21-2021 05:02 PM
‎11-21-2021 05:02 PM
For the sake of simplicity, I just made another data set and append them together with 62 observations. By using the code below, I get 62 predicted values with duplication by day. Is that right?     data customer2;set customers; count=round(count+rand("weibull", 7,3.5),1.); run; data customers;set customers customer2; run; proc sort;by day; run; proc gampl data=customers; model count=spline(day) / dist=POISSON; ******Final Pick***************; id _all_; output out=preds pred=predicted; run; ... View more

Re: How to fit my data to Gamma,  Weibull and Lognomal distributions?

by Pyrite | Level 9 in Statistical Procedures
‎11-21-2021 02:24 PM
‎11-21-2021 02:24 PM
After concatenating the data from the other four months to the original data and run the same code to fit and plot the model, I'll get five different models. If I assume that the counts on a given day, regardless of the month, all come from the same distribution, should I 'average' the predicted results of five models as final outcome?       ... View more

Re: How to fit my data to Gamma,  Weibull and Lognomal distributions?

by Pyrite | Level 9 in Statistical Procedures
‎11-19-2021 02:22 PM
‎11-19-2021 02:22 PM
Truly appreciative of your guidance. The count data fits better than my previous result by adopting your code below with minor change by replacing POISSON distribution.   The data set named "customers" is just for one particular month. I do have 5 different data sets for 5 different months with DAY as a categorical predictor(e.g .=1,2,3..., 30).   But I don't know how to "avoid saturating the model resulting in perfect prediction" by leveraging those 5 different data sets.   Could you shed some lights here?     proc gampl data=customers; model count=spline(day) / dist=POISSON; id _all_; output out=preds pred=predicted; run; proc sgplot data=preds; vbarparm category=day response=count / barwidth=0.7 baselineattrs=(thickness=0); series y=predicted x=day /markers markerattrs=(size=8pt color=red); run;     ... View more

Re: How to fit my data to Gamma,  Weibull and Lognomal distributions?

by Pyrite | Level 9 in Statistical Procedures
‎11-18-2021 08:59 PM
‎11-18-2021 08:59 PM
Hi StatDave_SAS, Thanks so much for your great help. But my goal is to identify a probability model for the distribution of counts of random events that dictates the type of distributions I should expect to see something similar like below. If a regression model for count data fits well, I should be able to say that the # of customers at day 1,2,.. and 31 equals to the predicated values from Generalized Poisson respectively. I don't see I can accomplish my goal with the result created by your code.   Could you enlighten me here? Thanks,        ... View more

Re: How to fit my data to Gamma,  Weibull and Lognomal distributions?

by Pyrite | Level 9 in Statistical Procedures
‎11-08-2021 09:59 AM
‎11-08-2021 09:59 AM
Hi Steve, Many thanks. It makes sense to me. But I don't know exactly how to implement it into SAS code.   Could you give the example to enlighten me? Ethan ... View more

Re: How to fit my data to Gamma,  Weibull and Lognomal distributions?

by Pyrite | Level 9 in Statistical Procedures
‎11-03-2021 05:22 PM
‎11-03-2021 05:22 PM
Thank you! Very helpful.   In stead of fitting COUNT variable for discrete distribution, I can transform it to "percent_count" as continuous variable to fit continuous distribution. below is the code I define "percent_count" variable.  Then I can use it in PROC SEVERITY.   Ethan proc sql noprint; select sum(count) into :total from customers ; quit; %put &total.; data customers; set customers; percent_count=round(100*count/&total.,0.01); run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-16-2025 08:22 AM
Likes given to
Quick links