Recode by percentile 50-75-90-95-above 95

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

Recode by percentile 50-75-90-95-above 95

Peter Spangler
I have rows with cases and two variables, one multilevel variables coded 1-4. The other is transaction value. I want to bin the transaction values by percentile 50-75-90-95-above 95 for each level of variable 1. 
I tried to recode the using Select Cases to select only the level I wanted to recode but it recoded all cases. Can I do this with syntax more easily?
Reply | Threaded
Open this post in threaded view
|

Re: Recode by percentile 50-75-90-95-above 95

David Marso
Administrator
I believe I gave you the basic required code in a previous related posting (please don't start new threads for followup on previous questions.
-To apply it to the new question will require your study of the commands and generalization of the concepts-).   I'll sometimes toss you a fish, but don't expect a pretty bow or extensive play by play verbiage explaining any subtle nuances.  That 2nd level of SPSS enlightenment is your  responsibility.

FWIW:
When the dialogs don't result in what you expect it behooves you to post the relevant syntax so we are not poking around in the murky realm of InterneTelepathy.

A simple data mockup and example of desired results goes a distance as well.
IMNSHO:  You can achieve almost anything more simply with syntax than that clumsy recode/select dialog.

Peter Spangler wrote
I have rows with cases and two variables, one multilevel variables coded
1-4. The other is transaction value. I want to bin the transaction values
by percentile 50-75-90-95-above 95 for each level of variable 1.
I tried to recode the using Select Cases to select only the level I wanted
to recode but it recoded all cases. Can I do this with syntax more easily?
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
Reply | Threaded
Open this post in threaded view
|

Re: Recode by percentile 50-75-90-95-above 95

Rich Ulrich
In reply to this post by Peter Spangler
It sounds like you need to check the options for RANK
in order to rank  /BY  var1   (or whatever the syntax is).

--
Rich Ulrich


Date: Thu, 21 Feb 2013 11:40:22 -0800
From: [hidden email]
Subject: Recode by percentile 50-75-90-95-above 95
To: [hidden email]

I have rows with cases and two variables, one multilevel variables coded 1-4. The other is transaction value. I want to bin the transaction values by percentile 50-75-90-95-above 95 for each level of variable 1. 
I tried to recode the using Select Cases to select only the level I wanted to recode but it recoded all cases. Can I do this with syntax more easily?