Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SPSS 16:  How to convert ratio-level measure into categorical variables?

Posted on 2009-02-23
10
Medium Priority
?
504 Views
Last Modified: 2012-06-21
Dear experts:

Hi!

I have a data as follows:
Annual Family income  ($)
55,000
75,000
100,000
30,000
150,000

I would like to group the above family income as follows:
1)     under 30,000
2)    30,001 - 50,000
3)  50,001 - 70,000
4) 70,001 - 90,000
5) 90,001 - 110,000
6) More than 110,000

I've already entered the entered the numbers    (55,000, 75,000, 100,000, 30,000, 150,000 . . . . ).

I think there is a way to convert the entries into      3,          4,            5,              2,       6, . . ., using
some tools in SPSS.

Can you kindly show me how to make the conversion?

Thanks!


0
Comment
Question by:duta
  • 4
  • 3
7 Comments
 
LVL 9

Expert Comment

by:richdiesal
ID: 23718737
Hi duta -

Just curious why you offered no points for this question?

But anyway, the solution is through the "Transform" menu, under "Recode into Different Variables."
0
 

Author Comment

by:duta
ID: 23718833
I thought the max of 500 points are offered by default.

Is there any change to that?

Thanks!
0
 
LVL 9

Accepted Solution

by:
richdiesal earned 2000 total points
ID: 23718881
There should be a add more points button somewhere...

Also, this syntax will do it for you automatically, replacing oldvar for your old variable name and newvar for your new one:

RECODE oldvar (Lowest thru 30000=1) (30001 thru 50000=2) (50001 thru 70000=3) (70001 thru 90000=4)
    (90001 thru 110000=5) (110001 thru Highest=6) INTO newvar.
EXECUTE.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:duta
ID: 23718910
Thank you so much for your kind tip.

I already tried your tip.

I am going to try the "Accept as solution" button to award you points.

If it does not work, I do not know what else I can do.
Thanks!
0
 

Author Comment

by:duta
ID: 23718933
TO Moderator:

I do accept richdiesal's tip as solution. His solution deserves the max 500 points.

For some reason, I cannot award points to him.

Thanks!

duta
0
 
LVL 9

Expert Comment

by:richdiesal
ID: 23719148
Ahh, my bad.  It hit my "SPSS" alert - didn't even check what zone it was in.
0
 

Author Comment

by:duta
ID: 23720018
NetMinder,

Thank you so much for your kind message.

Please post this question in the site you deem most appropriate on my behalf.

Thanks in advance!

duta


0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Tech giants such as Amazon and Google have sold Alexa and Echo to such an extent that they have become household names. And soon they are expected to be used by commoners in their homes, ordering takeout, picking out a song, answering trivia questio…
This applies to Dell but may also apply to other manufacturers as well. We ran across a few machines that just dropped recently it trust relationship with the server. After doing the basic removing and joining the domain again, it changed to No logo…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question