Visual binning with group by variables

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Visual binning with group by variables

Nagaraju Thogiti
Hi,

 

I want to create new variables which are deciles of some continuous
variables (e.g. variables X1 to X10) as new variables and added to the
original dataset. I have another set of variables, Y1 to Y5, which are
categorical variables and let us say each has five levels. I want to
create ten new variables X11 to X20 within each of these combinations of
Y1 to Y5. It is something like aggregate summaries within cases, but now
I want some percentiles instead and make new variables out of it.

 

I tried with split file but it just separates me the output. How do I
proceed?

 

Thank you,

Nagu

====================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
Reply | Threaded
Open this post in threaded view
|

Re: Visual binning with group by variables

Spousta Jan
Hi Nagu,

Do you mean something like this?

RANK VARIABLES= X1 to X10 BY Y1 to Y5  /NTILES (10).

Best regards

Jan



-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Nagaraju Thogiti
Sent: Thursday, March 13, 2008 8:19 PM
To: [hidden email]
Subject: Visual binning with group by variables

Hi,



I want to create new variables which are deciles of some continuous variables (e.g. variables X1 to X10) as new variables and added to the original dataset. I have another set of variables, Y1 to Y5, which are categorical variables and let us say each has five levels. I want to create ten new variables X11 to X20 within each of these combinations of
Y1 to Y5. It is something like aggregate summaries within cases, but now I want some percentiles instead and make new variables out of it.



I tried with split file but it just separates me the output. How do I proceed?



Thank you,

Nagu

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



_____

Tato zpráva a všechny připojené soubory jsou důvěrné a určené výlučně adresátovi(-ům). Jestliže nejste oprávněným adresátem, je zakázáno jakékoliv zveřejňování, zprostředkování nebo jiné použití těchto informací. Jestliže jste tento mail dostali neoprávněně, prosím, uvědomte odesilatele a smažte zprávu i přiložené soubory. Odesilatel nezodpovídá za jakékoliv chyby nebo opomenutí způsobené tímto přenosem.

This message and any attached files are confidential and intended solely for the addressee(s). Any publication, transmission or other use of the information by a person or entity other than the intended addressee is prohibited. If you receive this in error please contact the sender and delete the message as well as all attached documents. The sender does not accept liability for any errors or omissions as a result of the transmission.

-.- --

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: FOREIGN:RE: Visual binning with group by variables

Nagaraju Thogiti
Yes.

-----Original Message-----
From: Spousta Jan [mailto:[hidden email]]
Sent: Friday, March 14, 2008 2:29 AM
To: Nagaraju Thogiti; [hidden email]
Subject: FOREIGN:RE: Visual binning with group by variables

Hi Nagu,

Do you mean something like this?

RANK VARIABLES= X1 to X10 BY Y1 to Y5  /NTILES (10).

Best regards

Jan



-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Nagaraju Thogiti
Sent: Thursday, March 13, 2008 8:19 PM
To: [hidden email]
Subject: Visual binning with group by variables

Hi,



I want to create new variables which are deciles of some continuous variables (e.g. variables X1 to X10) as new variables and added to the original dataset. I have another set of variables, Y1 to Y5, which are categorical variables and let us say each has five levels. I want to create ten new variables X11 to X20 within each of these combinations of
Y1 to Y5. It is something like aggregate summaries within cases, but now I want some percentiles instead and make new variables out of it.



I tried with split file but it just separates me the output. How do I proceed?



Thank you,

Nagu

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



_____

Tato zpráva a všechny připojené soubory jsou důvěrné a určené výlučně adresátovi(-ům). Jestliže nejste oprávněným adresátem, je zakázáno jakékoliv zveřejňování, zprostředkování nebo jiné použití těchto informací. Jestliže jste tento mail dostali neoprávněně, prosím, uvědomte odesilatele a smažte zprávu i přiložené soubory. Odesilatel nezodpovídá za jakékoliv chyby nebo opomenutí způsobené tímto přenosem.

This message and any attached files are confidential and intended solely for the addressee(s). Any publication, transmission or other use of the information by a person or entity other than the intended addressee is prohibited. If you receive this in error please contact the sender and delete the message as well as all attached documents. The sender does not accept liability for any errors or omissions as a result of the transmission.

-.- --

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