Tabular output from aggregated data?

[Robert L]

I have got this dataset with aggregated/calculated  data, variables such as county, year and the percentage in the population with a BMI over 25 for each combination of county and year. To present these numbers, it would be handy if they could be set up in an ordinary table.

 

In Chart Builder, there is the option of using VALUE instead of the default choice of MEAN when the variable at hand is defined as a scale varaiable. Any way something similar could be done with for example Custom tables?

 

There is also the PRINT command. It works, but since the numerical codes rather than labels are printed, it would save some time to have the variables with their  labels in a table format from the beginning.

 

Suggestions, anyone?

 

Robert

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Jon Peck]

It sounds like each cell would have just one case in it, since the data are aggregated, so wouldn't the mean statistic be just the value?

On Mon, Jun 29, 2020 at 4:50 AM Robert Lundqvist <[hidden email]> wrote:

I have got this dataset with aggregated/calculated  data, variables such as county, year and the percentage in the population with a BMI over 25 for each combination of county and year. To present these numbers, it would be handy if they could be set up in an ordinary table.

 

In Chart Builder, there is the option of using VALUE instead of the default choice of MEAN when the variable at hand is defined as a scale varaiable. Any way something similar could be done with for example Custom tables?

 

There is also the PRINT command. It works, but since the numerical codes rather than labels are printed, it would save some time to have the variables with their  labels in a table format from the beginning.

 

Suggestions, anyone?

 

Robert

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

--
===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Robert L]

Jon, spot on, thanks. Guess I made things more complicated than they have to
be. Happens every now and then...



-----
Robert Lundqvist
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD