What if I need subgroup identifiers with repeating groups of a certain size?
A spreadsheet formula can generate a repeating identifier variable of a certain size. For example, the formula: =v0-n*trunc((v0-1)/n) where n is the maximum group size, can be used to generate a variable with codes up to that size. For example, when n=4, then the following values (codes) of the grouping variable will be generated: 1, 2, 3, 4, 1, 2, 3, 4, 1, 2, 3, 4,… When I use the Case Weights option, I do not believe the results are correct. Case Weights must be integers. If the variable chosen as the weighting variable is a non-integer number it will be truncated to become an integer. The Case Weights option treats values of a selected variable as integer case multipliers when processing the data.
