TRANSFORM Keyword (GGRAPH command)
The TRANSFORM
keyword applies a transformation to the graph dataset.
NO. Do not transform the graph dataset.
VARSTOCASES
(SUMMARY="varname" INDEX="varname"). Transform the
summary function results to cases in the graph dataset. Use this when you are creating graphs of separate variables. The
results of each summary function becomes a case in the graph dataset,
and the data elements drawn for each case act like categories in a
categorical graph. Each case is identified by an index variable whose
value is a unique sequential number. The result of the summary function
is stored in the summary variable. The upper and lower bound of error
interval functions are also stored in two other variables. By default,
the names of the variables are #INDEX for the index variable, #SUMMARY
for the summary variable, #HIGH for the upper bound variable, and
#LOW for the lower bound variable. You can change these names by using
the SUMMARY
, INDEX
, HIGH
, and LOW
qualifiers. Furthermore,
break variables in the variable specification are treated as fixed
variables and are not transposed. Note that this transformation is
similar to the VARSTOCASES
command (see VARSTOCASES).
Examples
GGRAPH
/GRAPHDATASET NAME="graphdataset" VARIABLES=MEAN(salbegin) MEAN(salary)
TRANSFORM=VARSTOCASES(SUMMARY="meansal" INDEX="variables")
/GRAPHSPEC SOURCE=INLINE.
BEGIN GPL
SOURCE: s=userSource(id("graphdataset"))
DATA: variables=col(source(s), name("variables"), unit.category())
DATA: meansal=col(source(s), name("meansal"))
GUIDE: axis(dim(2), label("Mean"))
ELEMENT: interval(position(variables*meansal))
END GPL.
GGRAPH
/GRAPHDATASET NAME="graphdataset" VARIABLES=MEANCI(salbegin, 95) MEANCI(salary, 95)
TRANSFORM=VARSTOCASES(SUMMARY="meansal" INDEX="variables" LOW="low" HIGH="high")
/GRAPHSPEC SOURCE=INLINE.
BEGIN GPL
SOURCE: s=userSource(id("graphdataset"))
DATA: variables=col(source(s), name("variables"), unit.category())
DATA: meansal=col(source(s), name("meansal"))
DATA: low=col(source(s), name("low"))
DATA: high=col(source(s), name("high"))
GUIDE: axis(dim(2), label("Mean with 95% CI"))
ELEMENT: point(position(variables*meansal))
ELEMENT: interval(position(region.spread.range(variables*(low+high))),
shape(shape.ibeam))
END GPL.