Date:         Thu, 29 Oct 2009 16:15:34 +0000
Reply-To:     Ruben van den Berg <ruben_van_den_berg@hotmail.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Ruben van den Berg <ruben_van_den_berg@hotmail.com>
Subject:      SOLVED: Check whether 9 string variables are identical over some
              70 "respondents"
In-Reply-To:  <OF901A4C64.A826A492-ON8725765E.004F822B-8725765E.004FFECB@us.ibm.com>
Content-Type: multipart/alternative;

 <OF901A4C64.A826A492-ON8725765E.004F822B-8725765E.004FFECB@us.ibm.com>
MIME-Version: 1.0

--_1e443437-64ee-456b-921a-125ab840b152_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Dear Jon=2C

=20

GATHERMD is lovely and I'll surely use it more often. Especially the abilit=
y to get an overview of all SPSS files in a single folder is great!

=20

But honestly=2C it didn't really solve the problem I posted. The easiest -b=
ut unelegant- solution was saving the entire file as XLS=2C transposing it =
in XLS=2C and reopening it in SPSS (essentially FLIP with string variables)=
. Now I could use OMS -> frequencies -> aggregate -> match files to add the=
 number of different string values to the original table. I realized the st=
ructure of the original table (varname and 9 labels in single rows) facilit=
ated the intercomparison of the labels a lot.

=20

Kind regards!

=20

Ruben van den Berg

=20



=20



=20


Date: Thu=2C 29 Oct 2009 08:33:44 -0600
From: peck@us.ibm.com
Subject: Re: Check whether 9 string variables are identical over some 70 "r=
espondents"
To: SPSSX-L@LISTSERV.UGA.EDU


The easiest way to get a table of variable labels across files would be to =
use the GATHERMD extension command.  You give it a file specification=2C an=
d it reads all the files and collects variable names and labels.  (The orig=
inal motivation was to catalog a lot of datasets).  From that=2C you could =
just do FREQUENCIES on the label column after filtering by the set of varia=
ble names of interest.=20

This extension command will work with V17 or 18 and probably works with V16=
=2C too.  Of course it requires the Python plugin and the extension command=
=2C both of which can be downloaded from SPSS Developer Central=2C www.spss=
.com/DevCentral.=20

HTH=2C=20

Jon Peck
SPSS=2C an IBM Company
peck@us.ibm.com
312-651-3435=20






From:=20
Ruben van den Berg <ruben_van_den_berg@hotmail.com>=20

To:=20
SPSSX-L@LISTSERV.UGA.EDU=20

Date:=20
10/29/2009 08:18 AM=20

Subject:=20
[SPSSX-L] Check whether 9 string variables are identical over              =
some 70              "respondents"=20

Sent by:=20
"SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>





Dear all=2C

I merged 9 data files with ADD FILES. However=2C to make sure that the vari=
able labels are identical over the 9 files=2C I made a table with a single =
column of variable names and the corresponding variable labels for each of =
the 9 files (so 10 string variables in total). Since the original files had=
 a set of some 70 variables in common=2C my 'variable label table' has some=
 70 lines. Ideally=2C all variable labels should be identical but on visual=
 inspection I've already spotted some slight differences.

What I was thinking about=2C is to count the number of different values wit=
hin 'respondents' over my 9 string variables in order to identify those var=
iables for which labels differ between files. I thought about FLIPping the =
data and using OMS and FREQUENCIES but I think FLIP doesn't work with strin=
gs.

Does anybody have an idea whether/how this is possible? I've Python install=
ed but virtually no experience with it.

Thanks a lot!

Ruben van den Berg










New Windows 7: Find the right PC for you. Learn more.=20

                                         =20
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/=

--_1e443437-64ee-456b-921a-125ab840b152_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style><!--
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Verdana
}
--></style>
</head>
<body class=3D'hmmessage'>
Dear Jon=2C<BR>
&nbsp=3B<BR>
GATHERMD&nbsp=3Bis lovely and I'll surely use it more often. Especially the=
 ability to get an overview of all SPSS files in a single folder is great!<=
BR>
&nbsp=3B<BR>
But honestly=2C it didn't really solve the problem I posted.&nbsp=3BThe eas=
iest -but unelegant- solution was saving the entire file as XLS=2C transpos=
ing it in XLS=2C and reopening it in SPSS (essentially&nbsp=3BFLIP with str=
ing variables).&nbsp=3BNow I could use OMS -&gt=3B&nbsp=3Bfrequencies -&gt=
=3B aggregate -&gt=3B match files to add the number of different string val=
ues to the original table. I realized the structure of the original table (=
varname and 9 labels in single rows) facilitated the intercomparison of the=
 labels a lot.<BR>
&nbsp=3B<BR>
Kind regards!<BR>
&nbsp=3B<BR>
Ruben van den Berg<BR>
&nbsp=3B<BR>
<BR><BR>&nbsp=3B<BR><BR><BR><BR>&nbsp=3B<BR>
<HR id=3DstopSpelling>
Date: Thu=2C 29 Oct 2009 08:33:44 -0600<BR>From: peck@us.ibm.com<BR>Subject=
: Re: Check whether 9 string variables are identical over some 70 "responde=
nts"<BR>To: SPSSX-L@LISTSERV.UGA.EDU<BR><BR><BR><FONT face=3Dsans-serif siz=
e=3D2>The easiest way to get a table of variable labels across files would =
be to use the GATHERMD extension command. &nbsp=3BYou give it a file specif=
ication=2C and it reads all the files and collects variable names and label=
s. &nbsp=3B(The original motivation was to catalog a lot of datasets). &nbs=
p=3BFrom that=2C you could just do FREQUENCIES on the label column after fi=
ltering by the set of variable names of interest.</FONT> <BR><BR><FONT face=
=3Dsans-serif size=3D2>This extension command will work with V17 or 18 and =
probably works with V16=2C too. &nbsp=3BOf course it requires the Python pl=
ugin and the extension command=2C both of which can be downloaded from SPSS=
 Developer Central=2C </FONT><A href=3D"http://www.spss.com/DevCentral"><FO=
NT face=3Dsans-serif size=3D2>www.spss.com/DevCentral</FONT></A><FONT face=
=3Dsans-serif size=3D2>.</FONT> <BR><BR><FONT face=3Dsans-serif size=3D2>HT=
H=2C</FONT> <BR><BR><FONT face=3Dsans-serif size=3D2>Jon Peck<BR>SPSS=2C an=
 IBM Company<BR>peck@us.ibm.com<BR>312-651-3435</FONT> <BR><BR><BR>
<TABLE width=3D"100%">
<TBODY>
<TR vAlign=3Dtop>
<TD><FONT face=3Dsans-serif color=3D#5f5f5f size=3D1>From:</FONT>=20
<TD><FONT face=3Dsans-serif size=3D1>Ruben van den Berg &lt=3Bruben_van_den=
_berg@hotmail.com&gt=3B</FONT>=20
<TR vAlign=3Dtop>
<TD><FONT face=3Dsans-serif color=3D#5f5f5f size=3D1>To:</FONT>=20
<TD><FONT face=3Dsans-serif size=3D1>SPSSX-L@LISTSERV.UGA.EDU</FONT>=20
<TR vAlign=3Dtop>
<TD><FONT face=3Dsans-serif color=3D#5f5f5f size=3D1>Date:</FONT>=20
<TD><FONT face=3Dsans-serif size=3D1>10/29/2009 08:18 AM</FONT>=20
<TR vAlign=3Dtop>
<TD><FONT face=3Dsans-serif color=3D#5f5f5f size=3D1>Subject:</FONT>=20
<TD><FONT face=3Dsans-serif size=3D1>[SPSSX-L] Check whether 9 string varia=
bles are identical over &nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B &nbsp=
=3B &nbsp=3Bsome 70 &nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B &nbsp=3B &=
nbsp=3B"respondents"</FONT>=20
<TR vAlign=3Dtop>
<TD><FONT face=3Dsans-serif color=3D#5f5f5f size=3D1>Sent by:</FONT>=20
<TD><FONT face=3Dsans-serif size=3D1>"SPSSX(r) Discussion" &lt=3BSPSSX-L@LI=
STSERV.UGA.EDU&gt=3B</FONT></TR></TBODY></TABLE><BR>
<HR noShade>
<BR><BR><BR><FONT face=3DVerdana size=3D2>Dear all=2C<BR><BR>I merged 9 dat=
a files with ADD FILES. However=2C to make sure that the variable labels ar=
e identical over the 9 files=2C I made a table with a single column of vari=
able names and the corresponding variable labels for each of the 9 files (s=
o 10 string variables in total). Since the original files had a set of some=
 70 variables in common=2C my 'variable label table' has some 70 lines. Ide=
ally=2C all variable labels should be identical but on visual inspection I'=
ve already spotted some slight differences.<BR><BR>What I was thinking abou=
t=2C is to <B>count the number of different values within 'respondents' ove=
r my 9 string variables </B>in order to identify those variables for which =
labels differ between files. I thought about FLIPping the data and using OM=
S and FREQUENCIES but I think FLIP doesn't work with strings.<BR><BR>Does a=
nybody have an idea whether/how this is possible? I've Python installed but=
 virtually no experience with it.<BR><BR>Thanks a lot!<BR><BR>Ruben van den=
 Berg<BR><BR><BR><BR><BR><BR><BR><BR><BR></FONT>
<HR>
<FONT face=3DVerdana size=3D2>New Windows 7: Find the right PC for you. </F=
ONT><A href=3D"http://windows.microsoft.com/shop"><FONT face=3DVerdana colo=
r=3Dblue size=3D2><U>Learn more.</U></FONT></A> <BR><BR>                                          <br /><=
hr />Express yourself instantly with MSN Messenger! <a href=3D'http://clk.a=
tdmt.com/AVE/go/onm00200471ave/direct/01/' target=3D'_new'>MSN Messenger</a=
></body>
</html>=

--_1e443437-64ee-456b-921a-125ab840b152_--

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (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