Hotels near Old State Capitol State Historic Site.Hotels near Lincoln Tomb & War Memorials.Hotels near Lincoln Home National Historic Site.Hotels near Abraham Lincoln Presidential Library and Museum.Hotels with Complimentary Breakfast in Springfield.InterContinental (IHG) Hotels in Springfield.will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the icon or attached as text to show exactly what you have and that we can test code against. You can COMBINE two character values with a concatenation. You are attempting to multiply two CHARACTER values. If you meant to use the value of Count that you show in the PICTURE then perhaps this would work. This is because the variable _n_ counts iterations of the data step, which for many means the row of the data. This code sets all values to 'Other' after line 5. BTW, it appears from the picture that your YY_mm variable is character which is very often sub-optimal because there are many tools to work with actual dates that make things much more flexible (or dynamic) Please provide example data in the form of data step code that includes at least two "months". Such as you have to do whatever analysis by the "dates". If the prod_group VALUES that are to be included change from month to month this not going to be a bit more of an exercise. Please provide a concise definition of what "Other" should be. It needs to be dynamic, since this will be automated and the groups that are the top 5 could change.Īlso, you'll notice there is a grouping of 'Other' already, but that just happened to be the name of the group. Vbar yy_mm / response=count group=prod_group dataskin=gloss Then I could use the sgplot to plot the results: proc sgplot data=term_out Something like this doesn't work: data other Īre there suggestions to group together within my year/month grouping? It's only looking at the prod_group and the top 5 and ignoring the parent group of yy_mm. However, this code only takes into account the prod_group variable, and not the yy_mm variable. I've tried this code to group: %let topN=5 My data is grouped by a year/month variable then by a product variable: I'm having trouble creating the 'Other' category for smaller groups in my data for a stacked bar.
0 kommentar(er)
