Hello,   I wrote the following code to calculate ratios with data included in a Dataset called 'CABU'. Many values in CABU are empty or 0.   The problem: the following code doesn't work properly at least when both variables (n and d) are empty ; the result I get is a void instead of a value = 0.   How should I handle this?   Thank you in advance PY   data CABU_array; set CABU; array n ABL_Anzahl_Akt               ABL_Anzahl_Gen                       ABL_mit_DEROU                   MTB_NGV                    MTB_RSV_Anz                          ABL_Anzahl_Gen_Online            MTB_Anzahl                      MTB_Anzahl_Online                    MTB_Anzahl_RKR                  ABL_Anzahl_Gruen           MTB_Vertriebserfolg                  AAb_Volumen            ABL_Anzahl_Gen_Verm        MTB_NGV_Online                       /* MTB_NGV_Verm */                       MTB_RSV_Anz_Online         /* MTB_RSV_Anz_Verm */; array d ABL_Anzahl_vzk               ABL_Anzahl_Akt                       ABL_Anzahl_Akt                  MTB_Anzahl                      MTB_Anzahl                                ABL_Anzahl_Akt_Online            ABL_Anzahl_Gen             ABL_Anzahl_Gen_Online                ABL_Anzahl_VZK                  ABL_Anzahl_Gen             ABL_Anzahl_VZK                       AAb_Anzahl            ABL_Anzahl_Akt_Verm        MTB_Anzahl_Online                    /* MTB_Anzahl_Verm */                    MTB_Anzahl_Online          /* MTB_Anzahl_Verm */; array r ABL_vzk_Ratio                ABL_Gen_Quote                        ABL_DEROU_Quote                      MTB_TICKET_AVG             RSV_QUOTE                            ABL_Gen_Quote_Online            MTB_AuszahlumtbQ           MTB_AuszahlumtbQ_Online         MTB_Anzahl_VZK                  ABL_GRUEN_Quote            MTB_VOL_je_VZK                       AAb_TktGR            ABL_Gen_Quote_Verm         MTB_TICKET_AVG_Onl                   /* MTB_TICKET_AVG_Verm */               RSV_QUOTE_Onl              /* RSV_QUOTE_Verm */; do   i=1 to dim(n) ;      if missing(n[i]) and not missing(d[i]) then do;            n[i] = 0;            r[i] = 0;      end;      if missing(d[i]) and not missing(n[i]) then do;            d[i] = 0;            r[i] = 1;      end;      if missing(d[i]) and missing(n[i]) then do;           n[i] = 0;            d[i] = 0;            r[i] = 0;      end;      else do;           r[i] = n[i]/d[i];    end; end; format abl: mtb: AAb: commax17.4; run; proc sort data=cabu_array (drop=i); by stufe marktregion_bt nlbez_bt mbrbez_bt jahr monat; run; ... View more

  Hello,   I want o create a pie chart with data structured as the folloing:   data Beispiel(label='Beispiel'); input Structure:$35. Month:2. Anz:5.; /* Anz is a numeric value, actually */ datalines; Nord 1 250 South 1 305 Center 1 444 East 1 140 West 1 456 Nord 2 210 South 2 175 Center 1 413 East 2 199 West 2 302 Nord 3 150 South 3 405 Center 3 124 East 3 140 West 3 456 Nord 4 105 South 4 375 Center 4 145 East 4 240 West 4 159 ; run;   I wrote:   PROC TEMPLATE; DEFINE STATGRAPH pie; BEGINGRAPH; LAYOUT REGION; PIECHART CATEGORY = Anz / group=monat DATALABELLOCATION = OUTSIDE DATALABELCONTENT = ALL CATEGORYDIRECTION = CLOCKWISE START = 180 NAME = 'pie'; DISCRETELEGEND 'pie' / TITLE = 'Anzahl der Anträge'; ENDLAYOUT; ENDGRAPH; END; RUN; proc sgrender data=Beispiel template = pie; run;   it gives stupid results (calculation the number of structures for each month and classified by Anz value). The reverse (variable = Structure instéad of Anz).   How should I proceed to get a pie chart where the value of Anz gives the part of each structure for each month? ... View more

hallo,   I have the following table:   and I want to obtain the following one:   where : Delta 19/18 is the difference of the Prod values between the 2 years by structure and month. Evolution in Percent 19/18  is the %age change of the Prod values between the 2 years by structure and month.   How can I programm this?   thanks for your help. PY ... View more