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
Medium Priority
504 Views
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
Question by:duta
• 4
• 3

LVL 9

Expert Comment

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

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

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

Author Comment

ID: 23718910
Thank you so much for your kind 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

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

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

Author Comment

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.

duta

0

## Featured Post

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…
###### Suggested Courses
Course of the Month10 days, 18 hours left to enroll