Login  Register

Re: Repeat case equals VAR

Posted by David Marso on Mar 29, 2013; 3:00pm
URL: http://spssx-discussion.165.s1.nabble.com/Repeat-case-equals-VAR-tp5719153p5719174.html

Well,  About as clear as this is likely to be!
Ponder this:
VARSTOCASES ...
SORT...
STRING ...
See DO IF and LAG
COMPUTE  ... CONCAT...
AGGREGATE or CASESTOVARS.
-------------------
Have a great weekend.  
I bet you'll sort it out by then, or realize that the
question as posed is very ill defined.

Peter Spangler wrote
David,
My apologies. I intended to be concise, not unclear.

I would like to create a new variable to assign the variable names to cases
where values are repeated across three variables. For example, value 999
appears in VAR1 and VAR2. I would assign this case VAR1, VAR2.

I hope this is more clear.

Peter


On Fri, Mar 29, 2013 at 7:37 AM, David Marso <[hidden email]> wrote:

> Peter,
> Your question is not clear .
> That might explain why nobody has bothered to respond!
> Please provide a little more detail?
> Here's how it works:
> If you take 1 minute to pose your question.
> I'll take 1 minute to respond.
> 90 sec gotta go.
> -------------------
>
> Peter Spangler wrote
> > Dear SPSS Folk,
> >
> > My data has 4 Columns. Each column has user IDs in Rows. Some of the IDs
> > repeat between VAR1 to VAR3. I would like to assign the names of the
> > variables to the cases for which that ID repeats.
> >
> >
> > *VAR1 VAR2 VAR3 NEW_VAR*
> >     1       2         3       VAR1, VAR2
> >     0       1         0
> >
> > Any suggestions are greatly appreciated!
>
>
>
>
>
> -----
> 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/Repeat-case-equals-VAR-tp5719153p5719169.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
>
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?"