quartile number of a data point

[s_pushparaj]

Dear list
I have a five variables with 15 values each. I wish to divide values based on the quartile values of each variable. For example, if the quartile values of a variable X1 are
25th percentile 5
50th percentile 10
75th percentile 15
100th percentile 20
I wish to recode the values of X1 into to new variable, if the values are
less than 5 -> 1
5 - 10 -> 2
11-15 -> 3
16 - 20 -> 4.
I wish to do this process for all five variables. Kindly help me solve this problem in one go.
with thanks
Pushparaj

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

[Spousta Jan]

Use

RANK VARIABLES=var1 to var5 /NTILES (4) .

Best regards,

Jan

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of s_pushparaj
Sent: Friday, February 08, 2008 12:30 PM
To: [hidden email]
Subject: quartile number of a data point

Dear list
I have a five variables with 15 values each. I wish to divide values based on the quartile values of each variable. For example, if the quartile values of a variable X1 are 25th percentile 5 50th percentile 10 75th percentile 15 100th percentile 20 I wish to recode the values of X1 into to new variable, if the values are less than 5 -> 1
5 - 10 -> 2
11-15 -> 3
16 - 20 -> 4.
I wish to do this process for all five variables. Kindly help me solve this problem in one go.
with thanks
Pushparaj

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

[Art Kendall-2]

something like this untested syntax should work.
flip.
rank  variables= var1 to var5
  /ntiles(4)
 into quart1 to quart5.
flip.


Art Kendall
Social Research Consultants



s_pushparaj wrote:

> Dear list
> I have a five variables with 15 values each. I wish to divide values based on the quartile values of each variable. For example, if the quartile values of a variable X1 are
> 25th percentile 5
> 50th percentile 10
> 75th percentile 15
> 100th percentile 20
> I wish to recode the values of X1 into to new variable, if the values are
> less than 5 -> 1
> 5 - 10 -> 2
> 11-15 -> 3
> 16 - 20 -> 4.
> I wish to do this process for all five variables. Kindly help me solve this problem in one go.
> with thanks
> Pushparaj
>
> ===================
> 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

[Art Kendall-2]

OOPS!
I read the OP wrong. No need for the flip.  That would be to get
quartiles within a cases.
Maybe I should have my coffee before responding to e-mail.


rank  variables= var1 to var5
 /ntiles(4)
into quart1 to quart5.

Art

Art Kendall wrote:

> something like this untested syntax should work.
> flip.
> rank  variables= var1 to var5
>  /ntiles(4)
> into quart1 to quart5.
> flip.
>
>
> Art Kendall
> Social Research Consultants
>
>
>
> s_pushparaj wrote:
>> Dear list
>> I have a five variables with 15 values each. I wish to divide values
>> based on the quartile values of each variable. For example, if the
>> quartile values of a variable X1 are
>> 25th percentile 5
>> 50th percentile 10
>> 75th percentile 15
>> 100th percentile 20
>> I wish to recode the values of X1 into to new variable, if the values
>> are
>> less than 5 -> 1
>> 5 - 10 -> 2
>> 11-15 -> 3
>> 16 - 20 -> 4.
>> I wish to do this process for all five variables. Kindly help me
>> solve this problem in one go.
>> with thanks
>> Pushparaj
>>
>> ===================
>> 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
>
>

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

[Brian Moore-3]

Hi all-

How would I modify Jan's solution to manually control naming of the new variables?  Help indicates that "into" can be used with this command, but doesn't specify where it appears.

Thanks,
Brian

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Spousta Jan
Sent: Friday, February 08, 2008 5:06 AM
To: [hidden email]
Subject: Re: quartile number of a data point

Use

RANK VARIABLES=var1 to var5 /NTILES (4) .

Best regards,

Jan

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of s_pushparaj
Sent: Friday, February 08, 2008 12:30 PM
To: [hidden email]
Subject: quartile number of a data point

Dear list
I have a five variables with 15 values each. I wish to divide values based on the quartile values of each variable. For example, if the quartile values of a variable X1 are 25th percentile 5 50th percentile 10 75th percentile 15 100th percentile 20 I wish to recode the values of X1 into to new variable, if the values are less than 5 -> 1
5 - 10 -> 2
11-15 -> 3
16 - 20 -> 4.
I wish to do this process for all five variables. Kindly help me solve this problem in one go.
with thanks
Pushparaj

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

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

[vlad simion]

Hi,

try this:
RANK VARIABLES=var1 to var5 /NTILES (4)  into new_var1 to new_var5.

hth,
Vlad


On Feb 12, 2008 5:39 PM, Brian Moore <[hidden email]> wrote:

> Hi all-
>
> How would I modify Jan's solution to manually control naming of the new
> variables?  Help indicates that "into" can be used with this command, but
> doesn't specify where it appears.
>
> Thanks,
> Brian
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> Spousta Jan
> Sent: Friday, February 08, 2008 5:06 AM
> To: [hidden email]
> Subject: Re: quartile number of a data point
>
> Use
>
> RANK VARIABLES=var1 to var5 /NTILES (4) .
>
> Best regards,
>
> Jan
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> s_pushparaj
> Sent: Friday, February 08, 2008 12:30 PM
> To: [hidden email]
> Subject: quartile number of a data point
>
> Dear list
> I have a five variables with 15 values each. I wish to divide values based
> on the quartile values of each variable. For example, if the quartile values
> of a variable X1 are 25th percentile 5 50th percentile 10 75th percentile 15
> 100th percentile 20 I wish to recode the values of X1 into to new variable,
> if the values are less than 5 -> 1
> 5 - 10 -> 2
> 11-15 -> 3
> 16 - 20 -> 4.
> I wish to do this process for all five variables. Kindly help me solve
> this problem in one go.
> with thanks
> Pushparaj
>
> =======
> 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
>
> =====================
> 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
>

--
Vlad Simion
Data Analyst
Tel:      [phone]

[Marta Garcia-Granero]

Brian Moore wrote:
> How would I modify Jan's solution to manually control naming of the new variables?  Help indicates that "into" can be used with this command, but doesn't specify where it appears.
>
> RANK VARIABLES=var1 to var5 /NTILES (4) .
Hi:

Try: RANK VARIABLES=var1 to var5 /NTILES (4) INTO Newvar1 TO NewVar5.


Best regards,
Marta García-Granero

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