PM49578: POPULATION PYRAMID NO LONGER SHOWS A LEGEND FOR SPLIT VARIABLE WHEN PERCENT INSTEAD OF FREQUENCIES IS USED FOR THE Y-AXIS

APAR status

• Closed as program error.

Error description

• You are working with IBM SPSS Statistics 19.0.0.1 or 20.0.0. You
  create a population pyramid histogram chart with a categorical
  variable as split variable (e.g. Gender) and a scale variable as
  distribution variable (e.g Salary). After you create the chart
  you double
  click on the chart in the viewer to edit it on Chart editor.
  Since you would like to have percentages instead of frequencies
  used as statistic for the Population Pyramid you click on the
  variables tab for the axis properties and select y-axis as
  element for percentage so that this is removed for frequencies.
  However, when you click Apply there is no longer a legend shown
  for the split variable and the colors for the split variable
  categories are lost.
  With statistics 18 - when you performed the steps described
  above - you got a legend for the split variable.
  This was reported to IBM SPSS Development.
  
  As a workaround on Chart Editor do not click OK, click Paste
  instead. You will get a syntax like the below.
  
  GGRAPH
    /GRAPHDATASET NAME="graphdataset" VARIABLES=salary gender
  MISSING=LISTWISE REPORTMISSING=NO
    /GRAPHSPEC SOURCE=INLINE.
  BEGIN GPL
    SOURCE: s=userSource(id("graphdataset"))
    DATA: salary=col(source(s), name("salary"))
    DATA: gender=col(source(s), name("gender"), unit.category())
    COORD: transpose(mirror(rect(dim(1,2))))
    GUIDE: axis(dim(1), label("Starting Salary"))
    GUIDE: axis(dim(1), opposite(), label("Starting Salary"))
    GUIDE: axis(dim(2), label("Frequency"))
    GUIDE: axis(dim(3), label("Gender"), opposite(), gap(0px))
    GUIDE: legend(aesthetic(aesthetic.color), null())
    SCALE: cat(dim(3), include("0", "1"))
    ELEMENT:
  interval(position(summary.count(bin.rect(salary*1*gender))),
  color.interior(gender))
  END GPL.
  
  In the above syntax change the folowing:
  
  Change summary.count to summary.percent.count in the ELEMENT
  statement
  Remove the ", null()" from the last GUIDE statement:  GUIDE:
  legend(aesthetic(aesthetic.color))
  
  The revised syntax will look like the below example. Run this
  revised syntax and you will get the legend for the population
  pyramid as expected:
  
  GGRAPH
    /GRAPHDATASET NAME="graphdataset" VARIABLES=salary gender
  MISSING=LISTWISE REPORTMISSING=NO
    /GRAPHSPEC SOURCE=INLINE.
  BEGIN GPL
    SOURCE: s=userSource(id("graphdataset"))
    DATA: salary=col(source(s), name("salary"))
    DATA: gender=col(source(s), name("gender"), unit.category())
    COORD: transpose(mirror(rect(dim(1,2))))
    GUIDE: axis(dim(1), label("Starting Salary"))
    GUIDE: axis(dim(1), opposite(), label("Starting Salary"))
    GUIDE: axis(dim(2), label("Frequency"))
    GUIDE: axis(dim(3), label("Gender"), opposite(), gap(0px))
    GUIDE: legend(aesthetic(aesthetic.color))
    SCALE: cat(dim(3), include("0", "1"))
    ELEMENT:
  interval(position(summary.percent.count(bin.rect(salary*1*gender
  ))), color.interior(gender))
  END GPL.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM SPSS Statistics users creating Population pyramid chart  *
  * with split variable                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * You are working with IBM SPSS Statistics 19.0.0.1 or 20.0.0. *
  * You                                                          *
  * create a population pyramid histogram chart with a           *
  * categorical                                                  *
  * variable as split variable (e.g. Gender) and a scale         *
  * variable as                                                  *
  * distribution variable (e.g Salary). After you create the     *
  * chart                                                        *
  * you double                                                   *
  * click on the chart in the viewer to edit it on Chart editor. *
  * Since you would like to have percentages instead of          *
  * frequencies                                                  *
  * used as statistic for the Population Pyramid you click on    *
  * the                                                          *
  * variables tab for the axis properties and select y-axis as   *
  * element for percentage so that this is removed for           *
  * frequencies.                                                 *
  * However, when you click Apply there is no longer a legend    *
  * shown                                                        *
  * for the split variable and the colors for the split variable *
  * categories are lost.                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Install IBM SPSS Statistics 19 FixPack 2 (19.0.0.2).         *
  ****************************************************************
  

Problem conclusion

• Install IBM SPSS Statistics 19 FixPack 2 (19.0.0.2).
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  SPSS STATISTICS

• Fixed component ID

  5725A54ST

Applicable component levels

• RJ00 PSN

     UP

• RJ00 PSY

     UP

• RK00 PSN

     UP

• RK00 PSY

     UP