Thanks so much for this Kurt. Although i dont have a solution just yet, I have finally understood what you actually meant by that.   The maxims are great btw.   Thanks again, appreciate your replies.       ... View more

No, my problem has more to do with the XML Editor that waspresent in IMS 3.1 and then "disappeared" in 4.2 - officially because developers could do more harm than good to their Information Maps and 😛 Has anyone had any experience trying to version control an Information Map(s)? ... View more

My experiment arranged in Split Plot design. How to make a Charts/ Boxplots for Proportions of a Binary Variable ? data Survival;   input A $ B $ Block Y;  if Y=1 then 1='Survive'; else 0='Died'; datalines; A1     B1     1      0 A1     B1     2      1 A1     B1     3      0 A1     B1     4      0 A1     B1     5      0 A1     B2     1      1 A1     B2     2      1 A1     B2     3      1 A1     B2     4      1 A1     B2     5      0 A1     B3     1      1 A1     B3     2      0 A1     B3     3      0 A1     B3     4      1 A1     B3     5      1 A2     B1     1      0 A2     B1     2      0 A2     B1     3      0 A2     B1     4      0 A2     B1     5      0 A2     B2     1      1 A2     B2     2      0 A2     B2     3      0 A2     B2     4      1 A2     B2     5      0 A2     B3     1      1 A2     B3     2      1 A2     B3     3      1 A2     B3     4      0 A2     B3     5      1 A3     B1     1      1 A3     B1     2      0 A3     B1     3      1 A3     B1     4      0 A3     B1     5      0 A3     B2     1      0 A3     B2     2      1 A3     B2     3      1 A3     B2     4      1 A3     B2     5      0 A3     B3     1      0 A3     B3     2      1 A3     B3     3      0 A3     B3     4      1 A3     B3     5      1 ;   Is it true when it displayed in as shown below ? how to write the codes?       Please help me it is so important for me... ... View more

Thank you. You saved me a lot of time. I will try to make it look nice either with png or just shorten the labels. Have a nice weekend. ... View more

Thanks a lot. -jenny- ... View more

You could use good-old traditional gchart, instead 🙂 And in v9.2, gchart even supports >32-character bar/midpoint text. Here is some code to do the similar plot: axis1 label=none value=none; axis2 label=none value=(j=right); proc gchart data=test (where=(year=1993)); hbar product / type=sum sumvar=actual nostats subgroup=product maxis=axis1 gaxis=axis2 group=text space=0; run; ... View more

Thank you Dan. I was hoping for a nice option for this, since i have a lot of variables and formats for my graphs. Well, well. I will put the text in the label instead, as you suggested. Tks jenny ... View more

Thanks! ... View more

Hi: You're going to allow the user to select multiple ACROSS variables??? Or just one or two. In your example, you showed only category as the ACROSS variable, nested with Salary, N and Mean. The GROUP variables in PROC REPORT are what go down the rows -- so if the users select multiple GROUP variables, you would be OK. Because the naming system follows a regular pattern, it is possible to write a SAS macro program to generate all the _cx_ statements you need as described in this paper on selected REPORT topics: http://support.sas.com/rnd/papers/sgf07/sgf2007-report.pdf If you are unfamiliar with the SAS Macro Facility, I recommend this paper as a good introduction: http://www2.sas.com/proceedings/sugi28/056-28.pdf cynthia ... View more

To the OP: yours is a new query, suggest you not piggy-back on a query that was authored by someone else -- consider though adding a link in your forum post as an alternative to highlight relative content. Also, your choice of forum is something else to consider next time - SAS/Graph has its own forum. Scott Barry SBBWorks, Inc. ... View more

Hi Jenny, I have managed to get exactly what I want using proc template and proc sgrender, thanks to some suggestions from SAS guys on here. I can now get overlaid horizontal boxplots as one of the boxplot options in proc template is orient= which specifies the orientation of the y-axis and the boxes so if you set it to horizontal you get hoizontal box plots, and when you set the layout=overlay you get overlaid horizontal boxplots. In proc template there is a whole load of attributes you can set too to change the appareance of the text, data markers, lables colours borders etc. I found it perfect for what I wanted to do. This might be a useful resource if you're still struggling http://support.sas.com/documentation/cdl/en/grstatgraph/63878/HTML/default/viewer.htm#/documentation/cdl/en/grstatgraph/63878/HTML/default/titlepage.htm ... View more

this actually does work, although Excel still puts a flag on the value because it wants to convert it to a number. The @ format causes the tagset to automatically set the type to String, and the format to '@'. If you don't like the little flags, then you might want to try using a number format that will preserve the leading zeros. format:00000 Should do the trick for this example. Eric ... View more

Hi: In the future, it really would be better to start an new post and then refer back to this post. For TABULATE purposes, the VAR statement STYLE= override only impacts the variable HEADER cells. To impact the calculated statistics for one variable differently from another variable, you would need to use the STYLE= override in the table statement. An example of this is shown here: http://support.sas.com/kb/25/410.html Note the way that the TABLE statement has [pre] var * {style={attribute=value}} OR you could have var * stat*{style={attribute=value}} [/pre] and your TAGATTR attribute would go inside the curly braces with the Excel format in quotes as the value. cynthia ... View more

Jenny, Try this. Create new code as follows: options obs=100; run; After you run this code, drag the big table into the process. I believe that should limit you to 100 obs. Afterwards, you would probably want to reset the number of obs to max because this option change affects all subsequent tasks (Someone correct me if I'm wrong, please). Nori ... View more

Perfect, thank you! /jenny Message was edited by: Jennys at Jun 30, 2006 9:59 AM ... View more