ordering % in custom tables

[NicoDW]

Hi there,

i  have the following questions in my survey
do you want to live in a house (yes/no)
do you want to live in an appartment (yes/no)
do you want to live in a shared house (yes/no)

I do a crosstabulation using gender (m/w) using customtables. Next I've
hided the "no" results using SPSSINC MODIFY TABLES.
       
               MEN         WOMEN
HOUSE     75%            66%
APPART     90%           70%
SHARED    44%          45%

Now I want to sort the percentage of men from high to low.
How can I do this?
many thanks






--
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

[Javier Figueroa]

I think it is not possible to simply use the customtable, because they are different variables you would have to do a macro or ordering it from the outside in excel or access

El jue., 1 ago. 2019 a las 9:11, NicoDW (<[hidden email]>) escribió:

Hi there,

i  have the following questions in my survey
do you want to live in a house (yes/no)
do you want to live in an appartment (yes/no)
do you want to live in a shared house (yes/no)

I do a crosstabulation using gender (m/w) using customtables. Next I've
hided the "no" results using SPSSINC MODIFY TABLES.

               MEN         WOMEN
HOUSE     75%            66%
APPART     90%           70%
SHARED    44%          45%

Now I want to sort the percentage of men from high to low.
How can I do this?
many thanks






--
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

--
===================== 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]

While you can't sort across ordinary variables, you can do this by defining a multiple category set and then using MODIFY TABLES to reorder the rows by the first column.  Here is an example.

data list list/house appart shared gender (4F1.0).
begin data
1 1 1 1
0 0 0 1
1 0 1 0
0 1 0 0
0 1 1 0
1 1 0 1
0 0 1 0
end data
dataset name survey.
MRSETS
  /MDGROUP NAME=$housing CATEGORYLABELS=VARLABELS VARIABLES=appart house shared VALUE=1
  /DISPLAY NAME=[$housing].

CTABLES
  /TABLE $housing [COUNT] BY gender.

SPSSINC MODIFY TABLES subtype="customtable"
SELECT=0 DIMENSION= COLUMNS LEVEL = -1
PROCESS = PRECEDING
/STYLES  APPLYTO=DATACELLS
CUSTOMFUNCTION="customstylefunctions.sortTable(direction='d')".

The custom function is installed along with the MODIFY TABLES extension.

On Thu, Aug 1, 2019 at 9:11 AM NicoDW <[hidden email]> wrote:

Hi there,

i  have the following questions in my survey
do you want to live in a house (yes/no)
do you want to live in an appartment (yes/no)
do you want to live in a shared house (yes/no)

I do a crosstabulation using gender (m/w) using customtables. Next I've
hided the "no" results using SPSSINC MODIFY TABLES.

               MEN         WOMEN
HOUSE     75%            66%
APPART     90%           70%
SHARED    44%          45%

Now I want to sort the percentage of men from high to low.
How can I do this?
many thanks






--
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

--
===================== 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

[NicoDW]

Thanks Jon, i'll give it a try and keep you posted.



--
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

[Javier Figueroa]

Big Jon, very good. Excellent

I take advantage of my spss add-ons file

Thank you.

El jue., 1 ago. 2019 a las 10:49, NicoDW (<[hidden email]>) escribió:

Thanks Jon, i'll give it a try and keep you posted.



--
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

--
===================== 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