How to combine different continuous variables into one categorical

[DLR]

I would like to combine (or merge) multiple continuous level measure variables into one categorical variable?  

I currently have:
VarX=number of people in respondent's household
VarY=number of people in respondent's work/school
Varz=number of respondent's neighbor

I would like to create a new variable such that
social network=
value 1=VarX
value 2=VarY
Value 3=VarZ

I appreciate any help you can provide.

Thank you

[David Marso]

I think you need to define the rules for creation of this 'variable'!
Please be very specific as at present this question makes minimal sense.
--

DLR wrote

I would like to combine (or merge) multiple continuous level measure variables into one categorical variable?  

I currently have:
VarX=number of people in respondent's household
VarY=number of people in respondent's work/school
Varz=number of respondent's neighbor

I would like to create a new variable such that
social network=
value 1=VarX
value 2=VarY
Value 3=VarZ

I appreciate any help you can provide.

Thank you

[Ryan]

Concatenate the dataset vertically (3 records) and create an indicator variable called "soc_net_indic" with the following value labels for each record: 1=household, 2=work/school, and 3 = neighbor. Then create a second variable which provides the actual numbers corresponding / linking to each value.

R

Sent from my iPhone

> On Mar 3, 2015, at 2:40 PM, David Marso <[hidden email]> wrote:
>
> I think you need to define the rules for creation of this 'variable'!
> Please be very specific as at present this question makes minimal sense.
> --
>
> DLR wrote
>> I would like to combine (or merge) multiple continuous level measure
>> variables into one categorical variable?  
>>
>> I currently have:
>> VarX=number of people in respondent's household
>> VarY=number of people in respondent's work/school
>> Varz=number of respondent's neighbor
>>
>> I would like to create a new variable such that
>> social network=
>> value 1=VarX
>> value 2=VarY
>> Value 3=VarZ
>>
>> I appreciate any help you can provide.
>>
>> Thank you
>
>
>
>
>
> -----
> 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?"
> --
> View this message in context: http://spssx-discussion.1045642.n5.nabble.com/How-to-combine-different-continuous-variables-into-one-categorical-tp5728885p5728886.html
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =====================
> 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

[DLR]

Thank Ryan.  The thing that confuses me is that the original variables are ratio level measures (e.g. the number of...), not string.  So if I follow your logic, then I treat them as string to then recreate them as numerical?  I am not be following you.  

[Bruce Weaver]

Also please provide a small example showing the current state of the data, and what you want it to look like afterwards.  (This is often far more helpful than a verbal description.)

David Marso wrote

I think you need to define the rules for creation of this 'variable'!
Please be very specific as at present this question makes minimal sense.
--

DLR wrote

I would like to combine (or merge) multiple continuous level measure variables into one categorical variable?  

I currently have:
VarX=number of people in respondent's household
VarY=number of people in respondent's work/school
Varz=number of respondent's neighbor

I would like to create a new variable such that
social network=
value 1=VarX
value 2=VarY
Value 3=VarZ

I appreciate any help you can provide.

Thank you