Re: Help with macros

Posted by Art Kendall on
URL: http://spssx-discussion.165.s1.nabble.com/Help-with-macros-tp5740865p5740870.html

It sounds like you are preparing the data for somebody else who will be using software other than SPSS.

"And I need to clean duplicates in original variables, not in the new ones."

Transforming input variables into themselves is a dangerous practice.  It may be that you want to send the set of transformed variables to somebody else.  But retaining the original variables makes it possible to go back and do things the way you eventually mean.

it sounds like you want to take the variables in a multiple response set and produce a new set.
something like a function such as
"unduplicate MRSet1 into MRSet2"

I am not sure I follow
"For the last row with data in the  cleaned results we need only one -3. "
Why wouldn't all respondents (cases) have the same number of values in a multiple response set? Even if some of those values are user-missing?

Can you cobble up an example set of variables that looks like the kind of input you are suggesting?
then for each case fill in a set of variables representing what you want.  Possibly, you could just take my example set and edit it so the Want variables look like what you want.