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: 
kmel56
‎09-01-2015
  • 33 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

PIE3D: Exploding slices

by Calcite | Level 5 in Graphics Programming
‎01-03-2012 05:03 AM
‎01-03-2012 05:03 AM
Hi everybody, This is my today's problem,  I am creating a PIE3D that i want with all slices exploded,  i wanted to display some of my text labels on two lines so I used the special caracter "0A"x to do it and it works. But when I want to explode the slices with the "two lines" tex labels it dosn't work. I have joined the sas data and this is my Gchart procedure : ODS RTF FILE="d:\test\test3.doc" ; GOPTION DEVICE=ACTXIMG VSIZE=25CM HSIZE=20CM ; PROC GCHART DATA=freq ;   PIE3D ltypologie /sumvar=percent noheading discrete                       explode="Acte d'AMP" "Autres" "Stimulation ovarienne" "Structure"                     clockwise angle=120 RADIUS=40 other=0 ;                     FORMAT percent pct_rd.; RUN ; QUIT ; GOPTION RESET=ALL ; ODS RTF CLOSE ; So the two slices who don't want to be exploded are : Erreur d'attribution/identification and Perte de gamètes/embryons Thanks a lot for your help ... View more

Problem with MINOR option

by Calcite | Level 5 in Graphics Programming
‎12-23-2011 08:51 AM
‎12-23-2011 08:51 AM
no it is just a visual choice i think, "communication direction" wants this visual, that's all ... View more

Problem with MINOR option

by Calcite | Level 5 in Graphics Programming
‎12-23-2011 08:32 AM
‎12-23-2011 08:32 AM
Okey, I have to think about it very interesting, but using this i'll have to change all my programs, may be let down the minor tricks :smileygrin: ... View more

Problem with MINOR option

by Calcite | Level 5 in Graphics Programming
‎12-23-2011 08:14 AM
‎12-23-2011 08:14 AM
Oh really!! so i can't have subgroups with gplot not like gchart , isn't it? ... View more

Re: Gchart Vbar : values with different colors

by Calcite | Level 5 in Graphics Programming
‎12-23-2011 08:10 AM
‎12-23-2011 08:10 AM
I totally agree with you but I am working in a company that uses this chart for graphics, and i am automating their programs. The other problem that i have is that sometimes there are some subgroups with small values 1 or 2 so It will be better that their text labels be on the right and not inside the subgroup bar, do you see the problem? ... View more

Problem with MINOR option

by Calcite | Level 5 in Graphics Programming
‎12-23-2011 08:06 AM
‎12-23-2011 08:06 AM
Indeed I am using it on MAXIS for Vbar GCHART ... View more

Problem with MINOR option

by Calcite | Level 5 in Graphics Programming
‎12-23-2011 05:06 AM
‎12-23-2011 05:06 AM
Hi everybody, I have this problem with a proc gchart using axis statement : WARNING: The MINOR= option on AXIS statement 2 was ignored          because the Nature de l'événement axis does not          support MINOR=. So i can't have minor ticks on my horiszontal axis. ... View more

Re: Gchart Vbar : values with different colors

by Calcite | Level 5 in Graphics Programming
‎12-23-2011 05:00 AM
‎12-23-2011 05:00 AM
Hi Robert, can I ask you an other small question. In fact I want that the text label for the upper subgroupe (Cyan blue and mybe another one, if the cyanblue subgroup have 0 observations) be ON the BAR and not inside, like in the excel example. I have tried this but doesn't work : data anno_text; set cross1; length function color $8; xsys='2'; ysys='2'; when='a'; midpoint=nat; subgroup=grave; function='label'; position='e'; text=trim(left(frequency)); if grave=0 then  color='white'; else if grave=1 then do; color='black' ; XC=nat; Y=frequency+1; end; run; ... View more

Re: Formats are lost when using ODSOUT

by Calcite | Level 5 in ODS and Base Reporting
‎12-22-2011 12:04 PM
‎12-22-2011 12:04 PM
thanks a lot Linlin and for you Cynthia ... View more

Re: Formats are lost when using ODSOUT

by Calcite | Level 5 in ODS and Base Reporting
‎12-22-2011 10:51 AM
‎12-22-2011 10:51 AM
I think there is something in my code that i really don't see, i have just began working with this kind of programming , it works with other tables but not for this one What is tech support, how can i contact them ?? thanks ... View more

Re: Formats are lost when using ODSOUT

by Calcite | Level 5 in ODS and Base Reporting
‎12-22-2011 10:36 AM
‎12-22-2011 10:36 AM
]HI, in fact i was meaning the object oriented program on sas using DATA _NULL_ and DECLARE ODSOUT, finally i've found the source of problem, I am now assigning the format in the _NULL_ DATA STEP so i Have variables formated in the output , but still have a problem, some cells are shifted. Here are the program, and the output with the problem : ods listing close; option nodate nonumber orientation=landscape; ods rtf path=&ch_res file="T3t.doc" style=rapport  startpage=no bodytitle; title "Tableau T3. Nombre d'incidents et d'effets indésirables en fonction de la gravité"; DATA _NULL_  ;         SET table03 END = fin;         IF _N_ = 1 THEN DO ;             DECLARE ODSOUT rapport () ;             rapport.TABLE_START() ;             rapport.ROW_START(TYPE:"HEADING") ;                 rapport.FORMAT_CELL(TEXT:"Niveau de gravité",ROW_SPAN:3,OVERRIDES:"JUST=LEFT") ;                 rapport.FORMAT_CELL(TEXT:"Total",ROW_SPAN:2) ;                 rapport.FORMAT_CELL(TEXT:"Non graves",COLUMN_SPAN:4) ;                 rapport.FORMAT_CELL(TEXT:"Graves",COLUMN_SPAN:5) ;             rapport.ROW_END() ;             rapport.ROW_START() ;                 rapport.FORMAT_CELL(TEXT:"G1",COLUMN_SPAN:2) ;                 rapport.FORMAT_CELL(TEXT:"G2",COLUMN_SPAN:2) ;                 rapport.FORMAT_CELL(TEXT:"G3",COLUMN_SPAN:2) ;                 rapport.FORMAT_CELL(TEXT:"G4",COLUMN_SPAN:2) ;                 rapport.FORMAT_CELL(TEXT:"G5") ;             rapport.ROW_END();             rapport.ROW_START() ;                 *rapport.FORMAT_CELL(TEXT:"") ;                 rapport.FORMAT_CELL(TEXT:"n",OVERRIDES:"FONTWEIGHT=BOLD cellwidth=1cm  ") ;                 rapport.FORMAT_CELL(TEXT:"n",OVERRIDES:"FONTWEIGHT=BOLD cellwidth=1cm") ;                 rapport.FORMAT_CELL(TEXT:"%",OVERRIDES:"FONTWEIGHT=BOLD cellwidth=2cm") ;                 rapport.FORMAT_CELL(TEXT:"n",OVERRIDES:"FONTWEIGHT=BOLD cellwidth=1cm") ;                 rapport.FORMAT_CELL(TEXT:"%",OVERRIDES:"FONTWEIGHT=BOLD cellwidth=1cm") ;                 rapport.FORMAT_CELL(TEXT:"n",OVERRIDES:"FONTWEIGHT=BOLD cellwidth=1cm") ;                 rapport.FORMAT_CELL(TEXT:"%",OVERRIDES:"FONTWEIGHT=BOLD cellwidth=1cm") ;                 rapport.FORMAT_CELL(TEXT:"n",OVERRIDES:"FONTWEIGHT=BOLD cellwidth=1cm") ;                 rapport.FORMAT_CELL(TEXT:"%",OVERRIDES:"FONTWEIGHT=BOLD cellwidth=1cm") ;                 rapport.FORMAT_CELL(TEXT:"n",OVERRIDES:"FONTWEIGHT=BOLD cellwidth=1cm") ;                 *rapport.FORMAT_CELL(TEXT:"%",OVERRIDES:"FONTWEIGHT=BOLD cellwidth=1cm") ;             rapport.ROW_END();         END ;             rapport.ROW_START() ;                 rapport.FORMAT_CELL(TEXT:put(nat,$effetinc.),OVERRIDES:"JUST=LEFT FONTWEIGHT=MEDIUM ") ;                 rapport.FORMAT_CELL(TEXT:frequency5,OVERRIDES:"FONTWEIGHT=MEDIUM") ;                 rapport.FORMAT_CELL(TEXT:frequency1,OVERRIDES:"FONTWEIGHT=MEDIUM") ;                 rapport.FORMAT_CELL(TEXT:compress(put(percent1,numx10.1)),OVERRIDES:"FONTWEIGHT=MEDIUM") ;                 rapport.FORMAT_CELL(TEXT:frequency2,OVERRIDES:"FONTWEIGHT=MEDIUM") ;                 rapport.FORMAT_CELL(TEXT:compress(put(percent2,numx10.1)),OVERRIDES:"FONTWEIGHT=MEDIUM") ;                 rapport.FORMAT_CELL(TEXT:frequency3,OVERRIDES:"FONTWEIGHT=MEDIUM") ;                 rapport.FORMAT_CELL(TEXT:compress(put(percent3,numx10.1)),OVERRIDES:"FONTWEIGHT=MEDIUM") ;                 rapport.FORMAT_CELL(TEXT:frequency4,OVERRIDES:"FONTWEIGHT=MEDIUM") ;                 rapport.FORMAT_CELL(TEXT:compress(put(percent4,numx10.1)),OVERRIDES:"FONTWEIGHT=MEDIUM") ;                 rapport.FORMAT_CELL(TEXT:freqG5,OVERRIDES:"FONTWEIGHT=MEDIUM") ;                 *rapport.FORMAT_CELL(TEXT:pctG5,OVERRIDES:"FONTWEIGHT=MEDIUM") ;             rapport.ROW_END();         IF fin THEN rapport.TABLE_END() ;     RUN; ods rtf close; ods listing; title;                                                                                                                                                                                                                                                                                Niveau de gravité   Total   Non    graves   Graves   G1   G2   G3   G4   G5     n   n   %   n   %   n   %   n   %   n   Incidents   90   15   4,3   38   10,9   30   8,6   7   2,0   0   Effets indésirables   259   6   1,7   16   4,6   173   49,6   64   18,3   0   Total   349   21   6,0   54   15,5   203   58,2   71   20,3   0   ... View more

Gchart Vbar : values with different colors

by Calcite | Level 5 in Graphics Programming
‎12-22-2011 09:05 AM
‎12-22-2011 09:05 AM
WOW I wasn't beleive that superman exists, thanks a lot ... View more

Gchart Vbar : values with different colors

by Calcite | Level 5 in Graphics Programming
‎12-22-2011 08:50 AM
‎12-22-2011 08:50 AM
Oh Okey, and can you give me a small example to do this with subgroups, I've never done it with subgroups:smileyplain: ... View more

Gchart Vbar : values with different colors

by Calcite | Level 5 in Graphics Programming
‎12-22-2011 08:42 AM
‎12-22-2011 08:42 AM
So this was done on EXCEL, I want the same thing on SAS, so you see for BLUE Subgroup the values are in WHITE and for the last Subgroup"Cyan Blue" one the value is on the BAR. How can I do that please ... View more

Gchart Vbar : values with different colors

by Calcite | Level 5 in Graphics Programming
‎12-22-2011 08:22 AM
‎12-22-2011 08:22 AM
Hi Robert thank for you answer. Maybe I wasn't so clear. My question wasn't about colors of subgroups( i have no problem with that) but I was meaning the values of each subgroup, say subgroup 1's value is 10, 2: 1 and 3: 15, what I want is that Value 10 for my first subgroup will be in WHITE color , and for the two other values Black color. Thanks again ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links