digest e-mail coming as garbled mess...

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

digest e-mail coming as garbled mess...

Koch, Erin C.
I recently signed up to receive the SPSS-X listserve e-mails in digest form (too many e-mails a day).  Unfortunately, what I'm getting are the garbled messages below... Any way to fix this?

Thanks,
Erin

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Automatic digest processor
Sent: Saturday, June 30, 2012 12:01 AM
To: Recipients of SPSSX-L digests
Subject: SPSSX-L Digest - 28 Jun 2012 to 29 Jun 2012 (#2012-180)

There are 33 messages totalling 5008 lines in this issue.

Topics of the day:

  1. IBM SPSS Questions (3)
  2. SPSS Database Capacity (6)
  3. Converting Fortran to SPSS (9)
  4. odds ratio to chi square conversion (2)
  5. Spss Syntax select all values in a variable? (7)
  6. Importing excel (3)
  7. Offset in GEE means contrasts? (2)
  8. Tree analysis failure

=====================
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

----------------------------------------------------------------------

Date:    Fri, 29 Jun 2012 16:37:12 +0800
From:    Eins Bernardo <[hidden email]>
Subject: IBM SPSS Questions

--1923299080-1311176581-1340959032=:86552
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Three questions for IBM SPSS personnel or others:=0A=0A=0A=0A1. Any forum o=
n modeler/clementine?=0A2. Do you have matrix showing the comparison of cap=
abilities/features of AMOS across versions?=0A3. Any forum on AMOS?=0A=0ATh=
ank you.=0AEins
--1923299080-1311176581-1340959032=:86552
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><body><div style=3D"color:#000; background-color:#fff; font-family:ti=
mes new roman, new york, times, serif;font-size:12pt"><div><span style=3D"f=
ont-size: 12pt; ">Three questions for IBM SPSS personnel or others:</span><=
br></div><div style=3D"font-size: 12pt; font-family: 'times new roman', 'ne=
w york', times, serif; "><div style=3D"font-size: 12pt; font-family: 'times=
 new roman', 'new york', times, serif; "><div id=3D"yiv1658673517"><div sty=
le=3D"color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size:=
 12pt; font-family: 'times new roman', 'new york', times, serif; "><div><br=
></div><div>1. Any forum on modeler/clementine?</div><div>2. Do you have ma=
trix showing the comparison of capabilities/features of AMOS across version=
s?</div><div>3. Any forum on AMOS?</div><div><br></div><div>Thank you.</div=
><div>Eins</div></div></div><br><br> </div> </div>  </div></body></html>
--1923299080-1311176581-1340959032=:86552--

------------------------------

Date:    Fri, 29 Jun 2012 03:09:07 -0700
From:    Albert-Jan Roskam <[hidden email]>
Subject: Re: SPSS Database Capacity

--2119556593-359084761-1340964547=:10469
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi, =0A=0A=0ASee the line "How many variables and cases can SPSS for window=
s handle?"=A0 on http://www.spsstools.net/FAQ.htm Not sure what the differe=
nces are when on a 64 bit architecture.=0A=0A=A0=0ARegards,=0AAlbert-Jan=0A=
=0A=0A~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~=
~=0AAll right, but apart from the sanitation, the medicine, education, wine=
, public order, irrigation, roads, a =0Afresh water system, and public heal=
th, what have the Romans ever done for us?=0A~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~=
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~=A0=0A=0A=0A>______________________=
__________=0A> From: David Marso <[hidden email]>=0A>To: SPSSX-L@LIS=
TSERV.UGA.EDU =0A>Sent: Friday, June 29, 2012 5:56 AM=0A>Subject: Re: [SPSS=
X-L] SPSS Database Capacity=0A> =0A>Hi Jon,=0A>Please (when you have a mome=
nt) restate the actual *ABSOLUTE* max cases X=0A>max vars for both 32 bit a=
nd 64 bits maybe even 132 bit systems just for the=0A>hell of it=A0 (assumi=
ng infinite disk space and RAM).=A0 Would love a core dump=0A>of the theory=
.=0A>=0A>Jon K Peck wrote=0A>>=0A>> 1.5M records is not a large file by SPS=
S standards.=0A>>=0A>> Jon Peck (no "h") aka Kim=0A>> Senior Software Engin=
eer, IBM=0A>> peck@.ibm=0A>> new phone: 720-342-5621=0A>>=0A>>=0A>>=0A>>=0A=
>> From:=A0  btafoya &lt;btafoya@&gt;=0A>> To:=A0 =A0  SPSSX-L@.uga=0A>> Da=
te:=A0  06/26/2012 08:39 PM=0A>> Subject:=A0 =A0 =A0 =A0 [SPSSX-L] SPSS Dat=
abase Capacity=0A>> Sent by:=A0 =A0 =A0 =A0 "SPSSX(r) Discussion" &lt;SPSSX=
-L@.uga&gt;=0A>>=0A>>=0A>>=0A>> I have a population of 1.5 Million records =
that I want to use in SPSS.=0A>> Will=0A>> it work? What platform will I ne=
ed to handle something like this? I will=0A>> be=0A>> taking random samples=
 but will need to get descriptive statistics from the=0A>> entire populatio=
n.=0A>>=0A>> --=0A>> View this message in context:=0A>> http://spssx-discus=
sion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp5713809.html=0A>>=0A>> =
Sent from the SPSSX Discussion mailing list archive at Nabble.com.=0A>>=0A>=
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=0A>> To m=
anage your subscription to SPSSX-L, send a message to=0A>> LISTSERV@.UGA (n=
ot to SPSSX-L), with no body text except the=0A>> command. To leave the lis=
t, send the command=0A>> SIGNOFF SPSSX-L=0A>> For a list of commands to man=
age subscriptions, send the command=0A>> INFO REFCARD=0A>>=0A>=0A>=0A>--=0A=
>View this message in context: http://spssx-discussion.1045642.n5.nabble.co=
m/SPSS-Database-Capacity-tp5713809p5713886.html=0A>Sent from the SPSSX Disc=
ussion mailing list archive at Nabble.com.=0A>=0A>=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=0A>To manage your subscription to S=
PSSX-L, send a message to=0A>[hidden email] (not to SPSSX-L), wi=
th no body text except the=0A>command. To leave the list, send the command=
=0A>SIGNOFF SPSSX-L=0A>For a list of commands to manage subscriptions, send=
 the command=0A>INFO REFCARD=0A>=0A>=0A>
--2119556593-359084761-1340964547=:10469
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><body><div style=3D"color:#000; background-color:#fff; font-family:ti=
mes new roman, new york, times, serif;font-size:12pt"><div><span>Hi, <br></=
span></div><div><span><br></span></div><div><span>See the line "How many va=
riables and cases can SPSS for windows handle?"&nbsp; on http://www.spsstoo=
ls.net/FAQ.htm</span> Not sure what the differences are when on a 64 bit ar=
chitecture.<br></div><div>&nbsp;</div><div>Regards,<br>Albert-Jan<br><br></=
div><div>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~=
~~~~<br>All right, but apart from the sanitation, the medicine, education, =
wine, public order, irrigation, roads, a <br>fresh water system, and public=
 health, what have the Romans ever done for us?<br>~~~~~~~~~~~~~~~~~~~~~~~~=
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~&nbsp;<br> <blockquote style=
=3D"border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: =
5px; padding-left: 5px;">  <div style=3D"font-family: times new roman, new
 york, times, serif; font-size: 12pt;"> <div style=3D"font-family: times ne=
w roman, new york, times, serif; font-size: 12pt;"> <div dir=3D"ltr"> <font=
 face=3D"Arial" size=3D"2"> <hr size=3D"1">  <b><span style=3D"font-weight:=
bold;">From:</span></b> David Marso &lt;[hidden email]&gt;<br> <b><s=
pan style=3D"font-weight: bold;">To:</span></b> [hidden email] <b=
r> <b><span style=3D"font-weight: bold;">Sent:</span></b> Friday, June 29, =
2012 5:56 AM<br> <b><span style=3D"font-weight: bold;">Subject:</span></b> =
Re: [SPSSX-L] SPSS Database Capacity<br> </font> </div> <br>=0AHi Jon,<br>P=
lease (when you have a moment) restate the actual *ABSOLUTE* max cases X<br=
>max vars for both 32 bit and 64 bits maybe even 132 bit systems just for t=
he<br>hell of it&nbsp; (assuming infinite disk space and RAM).&nbsp; Would =
love a core dump<br>of the theory.<br><br>Jon K Peck wrote<br>&gt;<br>&gt; =
1.5M records is not a large file by SPSS standards.<br>&gt;<br>&gt; Jon Pec=
k (no "h") aka Kim<br>&gt; Senior Software Engineer, IBM<br>&gt; peck@.ibm<=
br>&gt; new phone: 720-342-5621<br>&gt;<br>&gt;<br>&gt;<br>&gt;<br>&gt; Fro=
m:&nbsp;  btafoya &amp;lt;btafoya@&amp;gt;<br>&gt; To:&nbsp; &nbsp;  SPSSX-=
L@.uga<br>&gt; Date:&nbsp;  06/26/2012 08:39 PM<br>&gt; Subject:&nbsp; &nbs=
p; &nbsp; &nbsp; [SPSSX-L] SPSS Database Capacity<br>&gt; Sent by:&nbsp; &n=
bsp; &nbsp; &nbsp; "SPSSX(r) Discussion" &amp;lt;SPSSX-L@.uga&amp;gt;<br>&g=
t;<br>&gt;<br>&gt;<br>&gt; I have a population of 1.5 Million records that =
I want to use in SPSS.<br>&gt; Will<br>&gt; it work?
 What platform will I need to handle something like this? I will<br>&gt; be=
<br>&gt; taking random samples but will need to get descriptive statistics =
from the<br>&gt; entire population.<br>&gt;<br>&gt; --<br>&gt; View this me=
ssage in context:<br>&gt; http://spssx-discussion.1045642.n5.nabble.com/SPS=
S-Database-Capacity-tp5713809.html<br>&gt;<br>&gt; Sent from the SPSSX Disc=
ussion mailing list archive at <a target=3D"_blank" href=3D"http://nabble.c=
om/">Nabble.com</a>.<br>&gt;<br>&gt; =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D<br>&gt; To manage your subscription to SPSSX-L,=
 send a message to<br>&gt; LISTSERV@.UGA (not to SPSSX-L), with no body tex=
t except the<br>&gt; command. To leave the list, send the command<br>&gt; S=
IGNOFF SPSSX-L<br>&gt; For a list of commands to manage subscriptions, send=
 the command<br>&gt; INFO REFCARD<br>&gt;<br><br><br>--<br>View this messag=
e in context: http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-C=
apacity-tp5713809p5713886.html<br>Sent
 from the SPSSX Discussion mailing list archive at Nabble.com.<br><br>=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<br>To manage y=
our subscription to SPSSX-L, send a message to<br><a ymailto=3D"mailto:LIST=
[hidden email]" href=3D"mailto:[hidden email]">LISTSERV@L=
ISTSERV.UGA.EDU</a> (not to SPSSX-L), with no body text except the<br>comma=
nd. To leave the list, send the command<br>SIGNOFF SPSSX-L<br>For a list of=
 commands to manage subscriptions, send the command<br>INFO REFCARD<br><br>=
<br> </div> </div> </blockquote>  </div></div></body></html>
--2119556593-359084761-1340964547=:10469--

------------------------------

Date:    Fri, 29 Jun 2012 07:24:48 -0400
From:    Art Kendall <[hidden email]>
Subject: Re: Converting Fortran to SPSS

However, until we know what the task is, we don't even know if it can
already be accomplished in SPSS without any MATRIX, macros, (don't look
at this next word David) Python.

As Rich said the OP does not even say what dialect FORTRAN the code is in.
these code snippets on DEC FORTRAN circa 1974 takes a lot more code in
the IBM dialect.

parameter nstim= 20
parameter ncases=210

double precision data (nstim,nstim,ncases)
double precision summary(nstim,nstim)

dimension year (1901/2012)

implicit double precision (a, z)

and in later DEC FORTRAN
real  * 16 anything

the code may also rely on the compile time option of turning on array
index checking so that if an array index is out of bounds an error is
created.
for example a value in the data for year that was 1900 would create an
error message

Art Kendall Social
Research Consultants

On 6/28/2012 10:25 PM, David Marso wrote:

> I know you would never think that I would think what would result should be a
> 'line by line' but a first mental pass would be and 10 lines of FORTRAN
> would likely end up as a CSUM, MSUM... 50 might be CALL EIGEN...10 SWEEP....
> etc (MATRIX doesn't have all that many built in linear algebra functions per
> se)
> Depending upon the level of internal documentation, actual supporting math
> equations etc it could be a few spins of the Ouija board and a few spent
> black candles before a blaring epiphany crafts an algorithm.
> Of course one must also consider that MATRIX doesn't *directly* support
> subroutines. OTOH I have clever ways around that.
> In summary I agree 'translate the code to algorithms, and program the
> algorithms.'
> OTOH I want to add screw the code!  What is the original algorithm/math and
> code directly for the jugular!
>
>
> Rich Ulrich-2 wrote
>> I haven't used Fortran since they still spelled it FORTRAN -
>> the vector operators are probably transparent; but I
>> wonder how people use assignment of pointers.  - So, the
>> version of Fortran might be relevant.
>>
>> Since the Matrix language has matrix operators, I suggest
>> that line-by-line is an awkward way to translate old, primitive
>> Fortran, the stuff that looks mainly like Basis.  Is that what
>> it is?  Instead, translate the code to algorithms, and program
>> the algorithms.
>>
>> --
>> Rich Ulrich
>>
>>> Date: Thu, 28 Jun 2012 15:10:33 -0700
>>> From: david.marso@
>>> Subject: Re: Converting Fortran to SPSS
>>> To: SPSSX-L@.UGA
>>>
>>> What does it do?
>>> How long is the code?
>>> Are there verifiable test 'data' to confirm whatever might result?
>>> ---
>>> No such guide exists to my knowledge.  Pretty much would need to convert
>>> line by line.
>>> If it is short and sweet, does something interesting and has verifiable
>>> confirmation post it here and I'd be happy to look at it and post
>>> suggestions (probably short of actually writing the code).
>>> If it is long and boring I'd consider doing it for a reasonable
>>> consulting
>>> fee.
>>> I haven't looked at FORTRAN in over 20 years but it's like writing a
>>> tricycle.
>>>
>>>
>>> Dates, Brian wrote
>>>> I have a task on which I'm working in matrix mode in SPSS.  The only
>>>> solution that's available in publication regarding this task is written
>>>> in Fortran, with which I'm woefully inadequate.  Does a guide exist
>>>> which assists in the conversion of Fortran code to SPSS syntax, similar
>>>> to the guides that are available comparing SPSS to SAS or R?  Thanks.
>>>>
>>>>
>> ...
>>
>
> --
> View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS-tp5713876p5713883.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
>

------------------------------

Date:    Fri, 29 Jun 2012 08:46:24 -0400
From:    "Dates, Brian" <[hidden email]>
Subject: Re: Converting Fortran to SPSS

Thanks for the responses.  The task is the skewness of a Pearson Type
III distribution for Multiresponse Randomized Block Permutation
Procedures (MRBP), so definitely 'long and boring'.  I'll just tough it
out with the formulae I have and try to figure out the Fortran for some
assistance. Thanks again.

Brian





-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
David Marso
Sent: Thursday, June 28, 2012 10:26 PM
To: [hidden email]
Subject: Re: Converting Fortran to SPSS

I know you would never think that I would think what would result should
be a
'line by line' but a first mental pass would be and 10 lines of FORTRAN
would likely end up as a CSUM, MSUM... 50 might be CALL EIGEN...10
SWEEP....
etc (MATRIX doesn't have all that many built in linear algebra functions
per
se)
Depending upon the level of internal documentation, actual supporting
math
equations etc it could be a few spins of the Ouija board and a few spent
black candles before a blaring epiphany crafts an algorithm.
Of course one must also consider that MATRIX doesn't *directly* support
subroutines. OTOH I have clever ways around that.
In summary I agree 'translate the code to algorithms, and program the
algorithms.'
OTOH I want to add screw the code!  What is the original algorithm/math
and
code directly for the jugular!


Rich Ulrich-2 wrote

>
> I haven't used Fortran since they still spelled it FORTRAN -
> the vector operators are probably transparent; but I
> wonder how people use assignment of pointers.  - So, the
> version of Fortran might be relevant.
>
> Since the Matrix language has matrix operators, I suggest
> that line-by-line is an awkward way to translate old, primitive
> Fortran, the stuff that looks mainly like Basis.  Is that what
> it is?  Instead, translate the code to algorithms, and program
> the algorithms.
>
> --
> Rich Ulrich
>
>> Date: Thu, 28 Jun 2012 15:10:33 -0700
>> From: david.marso@
>> Subject: Re: Converting Fortran to SPSS
>> To: SPSSX-L@.UGA
>>
>> What does it do?
>> How long is the code?
>> Are there verifiable test 'data' to confirm whatever might result?
>> ---
>> No such guide exists to my knowledge.  Pretty much would need to
convert
>> line by line.
>> If it is short and sweet, does something interesting and has
verifiable

>> confirmation post it here and I'd be happy to look at it and post
>> suggestions (probably short of actually writing the code).
>> If it is long and boring I'd consider doing it for a reasonable
>> consulting
>> fee.
>> I haven't looked at FORTRAN in over 20 years but it's like writing a
>> tricycle.
>>
>>
>> Dates, Brian wrote
>> >
>> > I have a task on which I'm working in matrix mode in SPSS.  The
only
>> > solution that's available in publication regarding this task is
written
>> > in Fortran, with which I'm woefully inadequate.  Does a guide exist
>> > which assists in the conversion of Fortran code to SPSS syntax,
similar
>> > to the guides that are available comparing SPSS to SAS or R?
Thanks.
>> >
>> >
> ...
>


--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS
-tp5713876p5713883.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

------------------------------

Date:    Fri, 29 Jun 2012 06:15:34 -0700
From:    Bruce Weaver <[hidden email]>
Subject: Re: Converting Fortran to SPSS

Have you come across Li Cai's MRPP macro?

  http://lcai.bol.ucla.edu/mrpp.txt
  http://lcai.bol.ucla.edu/programs.html
  http://lcai.bol.ucla.edu/mrpp.pdf

HTH.



Dates, Brian wrote

>
> Thanks for the responses.  The task is the skewness of a Pearson Type
> III distribution for Multiresponse Randomized Block Permutation
> Procedures (MRBP), so definitely 'long and boring'.  I'll just tough it
> out with the formulae I have and try to figure out the Fortran for some
> assistance. Thanks again.
>
> Brian
>
>
>
>
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@.UGA] On Behalf Of
> David Marso
> Sent: Thursday, June 28, 2012 10:26 PM
> To: SPSSX-L@.UGA
> Subject: Re: Converting Fortran to SPSS
>
> I know you would never think that I would think what would result should
> be a
> 'line by line' but a first mental pass would be and 10 lines of FORTRAN
> would likely end up as a CSUM, MSUM... 50 might be CALL EIGEN...10
> SWEEP....
> etc (MATRIX doesn't have all that many built in linear algebra functions
> per
> se)
> Depending upon the level of internal documentation, actual supporting
> math
> equations etc it could be a few spins of the Ouija board and a few spent
> black candles before a blaring epiphany crafts an algorithm.
> Of course one must also consider that MATRIX doesn't *directly* support
> subroutines. OTOH I have clever ways around that.
> In summary I agree 'translate the code to algorithms, and program the
> algorithms.'
> OTOH I want to add screw the code!  What is the original algorithm/math
> and
> code directly for the jugular!
>
>
> Rich Ulrich-2 wrote
>>
>> I haven't used Fortran since they still spelled it FORTRAN -
>> the vector operators are probably transparent; but I
>> wonder how people use assignment of pointers.  - So, the
>> version of Fortran might be relevant.
>>
>> Since the Matrix language has matrix operators, I suggest
>> that line-by-line is an awkward way to translate old, primitive
>> Fortran, the stuff that looks mainly like Basis.  Is that what
>> it is?  Instead, translate the code to algorithms, and program
>> the algorithms.
>>
>> --
>> Rich Ulrich
>>
>>> Date: Thu, 28 Jun 2012 15:10:33 -0700
>>> From: david.marso@
>>> Subject: Re: Converting Fortran to SPSS
>>> To: SPSSX-L@.UGA
>>>
>>> What does it do?
>>> How long is the code?
>>> Are there verifiable test 'data' to confirm whatever might result?
>>> ---
>>> No such guide exists to my knowledge.  Pretty much would need to
> convert
>>> line by line.
>>> If it is short and sweet, does something interesting and has
> verifiable
>>> confirmation post it here and I'd be happy to look at it and post
>>> suggestions (probably short of actually writing the code).
>>> If it is long and boring I'd consider doing it for a reasonable
>>> consulting
>>> fee.
>>> I haven't looked at FORTRAN in over 20 years but it's like writing a
>>> tricycle.
>>>
>>>
>>> Dates, Brian wrote
>>> >
>>> > I have a task on which I'm working in matrix mode in SPSS.  The
> only
>>> > solution that's available in publication regarding this task is
> written
>>> > in Fortran, with which I'm woefully inadequate.  Does a guide exist
>>> > which assists in the conversion of Fortran code to SPSS syntax,
> similar
>>> > to the guides that are available comparing SPSS to SAS or R?
> Thanks.
>>> >
>>> >
>> ...
>>
>
>
> --
> View this message in context:
> http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS
> -tp5713876p5713883.html
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> LISTSERV@.UGA (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
> LISTSERV@.UGA (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
>


-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS-tp5713876p5713891.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

------------------------------

Date:    Fri, 29 Jun 2012 09:24:09 -0400
From:    "Dates, Brian" <[hidden email]>
Subject: Re: Converting Fortran to SPSS

Bruce,

Thanks. Yes, I have copies, and it's somewhat helpful, but the blocking
factor changes the way that all of the cumulants are calculated.  The
Fortran code I have is from the Blossom software.  I think between the
two, I can get through it.  I was looking for a time-saver, something
like the "R for SPSS and SAS Users" document.  I'm very rusty on
Fortran.  I really appreciate the suggestion.  When I'm finished I'll
let the list know, or contact Raynald to see if he wants to post it, in
case anyone is interested in the macro.

Brian

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Bruce Weaver
Sent: Friday, June 29, 2012 9:16 AM
To: [hidden email]
Subject: Re: Converting Fortran to SPSS

Have you come across Li Cai's MRPP macro?

  http://lcai.bol.ucla.edu/mrpp.txt
  http://lcai.bol.ucla.edu/programs.html
  http://lcai.bol.ucla.edu/mrpp.pdf

HTH.



Dates, Brian wrote
>
> Thanks for the responses.  The task is the skewness of a Pearson Type
> III distribution for Multiresponse Randomized Block Permutation
> Procedures (MRBP), so definitely 'long and boring'.  I'll just tough
it
> out with the formulae I have and try to figure out the Fortran for
some

> assistance. Thanks again.
>
> Brian
>
>
>
>
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@.UGA] On Behalf Of
> David Marso
> Sent: Thursday, June 28, 2012 10:26 PM
> To: SPSSX-L@.UGA
> Subject: Re: Converting Fortran to SPSS
>
> I know you would never think that I would think what would result
should
> be a
> 'line by line' but a first mental pass would be and 10 lines of
FORTRAN
> would likely end up as a CSUM, MSUM... 50 might be CALL EIGEN...10
> SWEEP....
> etc (MATRIX doesn't have all that many built in linear algebra
functions
> per
> se)
> Depending upon the level of internal documentation, actual supporting
> math
> equations etc it could be a few spins of the Ouija board and a few
spent
> black candles before a blaring epiphany crafts an algorithm.
> Of course one must also consider that MATRIX doesn't *directly*
support
> subroutines. OTOH I have clever ways around that.
> In summary I agree 'translate the code to algorithms, and program the
> algorithms.'
> OTOH I want to add screw the code!  What is the original
algorithm/math

> and
> code directly for the jugular!
>
>
> Rich Ulrich-2 wrote
>>
>> I haven't used Fortran since they still spelled it FORTRAN -
>> the vector operators are probably transparent; but I
>> wonder how people use assignment of pointers.  - So, the
>> version of Fortran might be relevant.
>>
>> Since the Matrix language has matrix operators, I suggest
>> that line-by-line is an awkward way to translate old, primitive
>> Fortran, the stuff that looks mainly like Basis.  Is that what
>> it is?  Instead, translate the code to algorithms, and program
>> the algorithms.
>>
>> --
>> Rich Ulrich
>>
>>> Date: Thu, 28 Jun 2012 15:10:33 -0700
>>> From: david.marso@
>>> Subject: Re: Converting Fortran to SPSS
>>> To: SPSSX-L@.UGA
>>>
>>> What does it do?
>>> How long is the code?
>>> Are there verifiable test 'data' to confirm whatever might result?
>>> ---
>>> No such guide exists to my knowledge.  Pretty much would need to
> convert
>>> line by line.
>>> If it is short and sweet, does something interesting and has
> verifiable
>>> confirmation post it here and I'd be happy to look at it and post
>>> suggestions (probably short of actually writing the code).
>>> If it is long and boring I'd consider doing it for a reasonable
>>> consulting
>>> fee.
>>> I haven't looked at FORTRAN in over 20 years but it's like writing a
>>> tricycle.
>>>
>>>
>>> Dates, Brian wrote
>>> >
>>> > I have a task on which I'm working in matrix mode in SPSS.  The
> only
>>> > solution that's available in publication regarding this task is
> written
>>> > in Fortran, with which I'm woefully inadequate.  Does a guide
exist

>>> > which assists in the conversion of Fortran code to SPSS syntax,
> similar
>>> > to the guides that are available comparing SPSS to SAS or R?
> Thanks.
>>> >
>>> >
>> ...
>>
>
>
> --
> View this message in context:
>
http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS

> -tp5713876p5713883.html
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> LISTSERV@.UGA (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
> LISTSERV@.UGA (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
>


-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS
-tp5713876p5713891.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

------------------------------

Date:    Fri, 29 Jun 2012 13:37:58 +0000
From:    "Zuluaga, Juan" <[hidden email]>
Subject: Re: Converting Fortran to SPSS

--_000_4B236621C4E4E943B7BB21F73014CD946DA75BBESCSU83Acampusst_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I would run Fortran code as a call from R. No need to translate it, only so=
me tweaking needed. You do need to understand what the Fortran code does.


--_000_4B236621C4E4E943B7BB21F73014CD946DA75BBESCSU83Acampusst_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 14 (filtered medium)">
<title>LISTSERV at the University of Georgia</title>
<style><!--
/* Font Definitions */
@font-face
        {font-family:Courier;
        panose-1:2 7 4 9 2 2 5 2 4 4;}
@font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:Consolas;
        panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
        {font-family:"Comic Sans MS";
        panose-1:3 15 7 2 3 3 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
h1
        {mso-style-priority:9;
        mso-style-link:"Heading 1 Char";
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:16.5pt;
        font-family:"Times New Roman","serif";
        font-weight:bold;}
h2
        {mso-style-priority:9;
        mso-style-link:"Heading 2 Char";
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:15.0pt;
        font-family:"Times New Roman","serif";
        font-weight:bold;}
h3
        {mso-style-priority:9;
        mso-style-link:"Heading 3 Char";
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:13.5pt;
        font-family:"Times New Roman","serif";
        font-weight:bold;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:none none;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:blue;
        text-decoration:none none;}
p
        {mso-style-priority:99;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
kbd
        {mso-style-priority:99;
        font-family:Courier;}
pre
        {mso-style-priority:99;
        mso-style-link:"HTML Preformatted Char";
        margin:0in;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:Courier;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
        {mso-style-priority:99;
        mso-style-link:"Balloon Text Char";
        margin:0in;
        margin-bottom:.0001pt;
        font-size:8.0pt;
        font-family:"Tahoma","sans-serif";}
span.Heading1Char
        {mso-style-name:"Heading 1 Char";
        mso-style-priority:9;
        mso-style-link:"Heading 1";
        font-family:"Cambria","serif";
        color:#365F91;
        font-weight:bold;}
span.Heading2Char
        {mso-style-name:"Heading 2 Char";
        mso-style-priority:9;
        mso-style-link:"Heading 2";
        font-family:"Cambria","serif";
        color:#4F81BD;
        font-weight:bold;}
span.Heading3Char
        {mso-style-name:"Heading 3 Char";
        mso-style-priority:9;
        mso-style-link:"Heading 3";
        font-family:"Cambria","serif";
        color:#4F81BD;
        font-weight:bold;}
span.HTMLPreformattedChar
        {mso-style-name:"HTML Preformatted Char";
        mso-style-priority:99;
        mso-style-link:"HTML Preformatted";
        font-family:"Consolas","serif";}
p.bod, li.bod, div.bod
        {mso-style-name:bod;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:10.5pt;
        font-family:"Comic Sans MS";
        color:black;}
p.small, li.small, div.small
        {mso-style-name:small;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:9.0pt;
        font-family:"Times New Roman","serif";}
p.smaller, li.smaller, div.smaller
        {mso-style-name:smaller;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:7.5pt;
        font-family:"Times New Roman","serif";}
p.large, li.large, div.large
        {mso-style-name:large;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
p.larger, li.larger, div.larger
        {mso-style-name:larger;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:13.5pt;
        font-family:"Times New Roman","serif";}
p.foot, li.foot, div.foot
        {mso-style-name:foot;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:9.0pt;
        font-family:"Times New Roman","serif";
        color:gray;}
p.block, li.block, div.block
        {mso-style-name:block;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        text-align:justify;
        font-size:9.0pt;
        font-family:"Times New Roman","serif";
        color:#555555;}
p.fixed, li.fixed, div.fixed
        {mso-style-name:fixed;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:12.0pt;
        font-family:Courier;}
span.EmailStyle34
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
span.BalloonTextChar
        {mso-style-name:"Balloon Text Char";
        mso-style-priority:99;
        mso-style-link:"Balloon Text";
        font-family:"Tahoma","sans-serif";}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
/* List Definitions */
@list l0
        {mso-list-id:536116027;
        mso-list-template-ids:-1253508970;}
@list l0:level1
        {mso-level-number-format:bullet;
        mso-level-text:\F0B7;
        mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l0:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l0:level3
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level4
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level5
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level6
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level7
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level8
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level9
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l1
        {mso-list-id:728960832;
        mso-list-template-ids:-1963021210;}
@list l1:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
ol
        {margin-bottom:0in;}
ul
        {margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1041" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=3D"white" lang=3D"EN-US" link=3D"blue" vlink=3D"blue">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:&quot;Ca=
libri&quot;,&quot;sans-serif&quot;;color:#1F497D">I would run Fortran code =
as a call from R. No need to translate it, only some tweaking needed. You d=
o need to understand what the Fortran code does.
<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:&quot;Ca=
libri&quot;,&quot;sans-serif&quot;;color:#1F497D"><o:p>&nbsp;</o:p></span><=
/p>
</div>
</body>
</html>

--_000_4B236621C4E4E943B7BB21F73014CD946DA75BBESCSU83Acampusst_--

------------------------------

Date:    Fri, 29 Jun 2012 09:45:35 -0400
From:    "Maguin, Eugene" <[hidden email]>
Subject: odds ratio to chi square conversion

Is there a way to convert an odds ratio to a chi square value? Specifically, given a 2x2 crosstabulation of x against y, the association between x and y can be expressed as an odds ratio (OR: bc/ad), as exp(B) from a logistic regression or a chi square. Knowing only either OR or B, can a chi-square be computed? One of the places this problem comes up is in meta-analyses where authors don't report sufficient data in primary reports.

Thanks, Gene Maguin

------------------------------

Date:    Fri, 29 Jun 2012 08:13:04 -0600
From:    Jon K Peck <[hidden email]>
Subject: Re: IBM SPSS Questions

This is a multipart message in MIME format.
--=_alternative 004E195887257A2C_=
Content-Type: text/plain; charset="US-ASCII"

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621




From:   Eins Bernardo <[hidden email]>
To:     [hidden email]
Date:   06/29/2012 02:41 AM
Subject:        [SPSSX-L] IBM SPSS Questions
Sent by:        "SPSSX(r) Discussion" <[hidden email]>



Three questions for IBM SPSS personnel or others:

1. Any forum on modeler/clementine?
>>>The SPSS Community forums linked from the SPSS Community site (
www.ibm.com/developerworks/spssdevcentral) include a Modeler forum.  There
are also some LinkedIn forums that cover Modeler.

2. Do you have matrix showing the comparison of capabilities/features of
AMOS across versions?
>>>I am not aware of such an item, but you might find this information in
a What's New section in the AMOS help.
3. Any forum on AMOS?

Thank you.
Eins



--=_alternative 004E195887257A2C_=
Content-Type: text/html; charset="US-ASCII"

<font size=2 face="sans-serif"><br>
Jon Peck (no &quot;h&quot;) aka Kim<br>
Senior Software Engineer, IBM<br>
[hidden email]<br>
new phone: 720-342-5621<br>
</font>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">Eins Bernardo &lt;[hidden email]&gt;</font>
<br><font size=1 color=#5f5f5f face="sans-serif">To: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">[hidden email]</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">06/29/2012 02:41 AM</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject: &nbsp; &nbsp;
&nbsp; &nbsp;</font><font size=1 face="sans-serif">[SPSSX-L] IBM
SPSS Questions</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Sent by: &nbsp; &nbsp;
&nbsp; &nbsp;</font><font size=1 face="sans-serif">&quot;SPSSX(r)
Discussion&quot; &lt;[hidden email]&gt;</font>
<br>
<hr noshade>
<br>
<br>
<br><font size=3 face="Roman">Three questions for IBM SPSS personnel or
others:</font>
<br>
<br><font size=3 face="Times New Roman">1. Any forum on modeler/clementine?</font>
<br><font size=3 face="Times New Roman">&gt;&gt;&gt;The SPSS Community
forums linked from the SPSS Community site (</font><a href=www.ibm.com/developerworks/spssdevcentral><font size=3 face="Times New Roman">www.ibm.com/developerworks/spssdevcentral</font></a><font size=3 face="Times New Roman">)
include a Modeler forum. &nbsp;There are also some LinkedIn forums that
cover Modeler.</font>
<br>
<br><font size=3 face="Times New Roman">2. Do you have matrix showing the
comparison of capabilities/features of AMOS across versions?</font>
<br><font size=3 face="Times New Roman">&gt;&gt;&gt;I am not aware of such
an item, but you might find this information in a What's New section in
the AMOS help.</font>
<br><font size=3 face="Times New Roman">3. Any forum on AMOS?</font>
<br>
<br><font size=3 face="Times New Roman">Thank you.</font>
<br><font size=3 face="Times New Roman">Eins</font>
<br><font size=3 face="Times New Roman"><br>
</font>
<br>
--=_alternative 004E195887257A2C_=--

------------------------------

Date:    Fri, 29 Jun 2012 09:42:05 -0500
From:    Rick Oliver <[hidden email]>
Subject: Re: SPSS Database Capacity

This is a multipart message in MIME format.
--=_alternative 004FDAAF86257A2C_=
Content-Type: text/plain; charset="US-ASCII"

I don't think the information on that page is entirely accurate. I'm not
aware of any theoretical limits on either cases or variables. Your
computing environment will determine practical limits.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]
Phone: 312.893.4922 | T/L: 206-4922



From:   Albert-Jan Roskam <[hidden email]>
To:     [hidden email]
Date:   06/29/2012 05:10 AM
Subject:        Re: SPSS Database Capacity
Sent by:        "SPSSX(r) Discussion" <[hidden email]>



Hi,

See the line "How many variables and cases can SPSS for windows handle?"
on http://www.spsstools.net/FAQ.htm Not sure what the differences are when
on a 64 bit architecture.

Regards,
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All right, but apart from the sanitation, the medicine, education, wine,
public order, irrigation, roads, a
fresh water system, and public health, what have the Romans ever done for
us?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: David Marso <[hidden email]>
To: [hidden email]
Sent: Friday, June 29, 2012 5:56 AM
Subject: Re: [SPSSX-L] SPSS Database Capacity

Hi Jon,
Please (when you have a moment) restate the actual *ABSOLUTE* max cases X
max vars for both 32 bit and 64 bits maybe even 132 bit systems just for
the
hell of it  (assuming infinite disk space and RAM).  Would love a core
dump
of the theory.

Jon K Peck wrote

>
> 1.5M records is not a large file by SPSS standards.
>
> Jon Peck (no "h") aka Kim
> Senior Software Engineer, IBM
> peck@.ibm
> new phone: 720-342-5621
>
>
>
>
> From:  btafoya &lt;btafoya@&gt;
> To:    SPSSX-L@.uga
> Date:  06/26/2012 08:39 PM
> Subject:        [SPSSX-L] SPSS Database Capacity
> Sent by:        "SPSSX(r) Discussion" &lt;SPSSX-L@.uga&gt;
>
>
>
> I have a population of 1.5 Million records that I want to use in SPSS.
> Will
> it work? What platform will I need to handle something like this? I will
> be
> taking random samples but will need to get descriptive statistics from
the
> entire population.
>
> --
> View this message in context:
>
http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp5713809.html

>
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> LISTSERV@.UGA (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
>


--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp5713809p5713886.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



--=_alternative 004FDAAF86257A2C_=
Content-Type: text/html; charset="US-ASCII"

<font size=2 face="sans-serif">I don't think the information on that page
is entirely accurate. I'm not aware of any theoretical limits on either
cases or variables. Your computing environment will determine practical
limits.</font>
<br>
<br><font size=2 face="sans-serif">Rick Oliver<br>
Senior Information Developer<br>
IBM Business Analytics (SPSS)<br>
E-mail: [hidden email]<br>
Phone: 312.893.4922 | T/L: 206-4922</font>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">Albert-Jan Roskam &lt;[hidden email]&gt;</font>
<br><font size=1 color=#5f5f5f face="sans-serif">To: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">[hidden email]</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">06/29/2012 05:10 AM</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject: &nbsp; &nbsp;
&nbsp; &nbsp;</font><font size=1 face="sans-serif">Re: SPSS Database
Capacity</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Sent by: &nbsp; &nbsp;
&nbsp; &nbsp;</font><font size=1 face="sans-serif">&quot;SPSSX(r)
Discussion&quot; &lt;[hidden email]&gt;</font>
<br>
<hr noshade>
<br>
<br>
<br><font size=3 face="Times">Hi, </font>
<br>
<br><font size=3 face="Times">See the line &quot;How many variables and
cases can SPSS for windows handle?&quot; &nbsp;on </font><a href=http://www.spsstools.net/FAQ.htm><font size=3 face="Times">http://www.spsstools.net/FAQ.htm</font></a><font size=3 face="Times">
Not sure what the differences are when on a 64 bit architecture.</font>
<br><font size=3 face="Times">&nbsp;</font>
<br><font size=3 face="Times">Regards,<br>
Albert-Jan<br>
</font>
<br><font size=3 face="Times">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br>
All right, but apart from the sanitation, the medicine, education, wine,
public order, irrigation, roads, a <br>
fresh water system, and public health, what have the Romans ever done for
us?<br>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
</font>
<br>
<hr><font size=2 face="Arial"><b>From:</b> David Marso &lt;[hidden email]&gt;<b><br>
To:</b> [hidden email] <b><br>
Sent:</b> Friday, June 29, 2012 5:56 AM<b><br>
Subject:</b> Re: [SPSSX-L] SPSS Database Capacity</font>
<br><font size=3 face="Times"><br>
Hi Jon,<br>
Please (when you have a moment) restate the actual *ABSOLUTE* max cases
X<br>
max vars for both 32 bit and 64 bits maybe even 132 bit systems just for
the<br>
hell of it &nbsp;(assuming infinite disk space and RAM). &nbsp;Would love
a core dump<br>
of the theory.<br>
<br>
Jon K Peck wrote<br>
&gt;<br>
&gt; 1.5M records is not a large file by SPSS standards.<br>
&gt;<br>
&gt; Jon Peck (no &quot;h&quot;) aka Kim<br>
&gt; Senior Software Engineer, IBM<br>
&gt; peck@.ibm<br>
&gt; new phone: 720-342-5621<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; From: &nbsp;btafoya &amp;lt;btafoya@&amp;gt;<br>
&gt; To: &nbsp; &nbsp;SPSSX-L@.uga<br>
&gt; Date: &nbsp;06/26/2012 08:39 PM<br>
&gt; Subject: &nbsp; &nbsp; &nbsp; &nbsp;[SPSSX-L] SPSS Database Capacity<br>
&gt; Sent by: &nbsp; &nbsp; &nbsp; &nbsp;&quot;SPSSX(r) Discussion&quot;
&amp;lt;SPSSX-L@.uga&amp;gt;<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; I have a population of 1.5 Million records that I want to use in SPSS.<br>
&gt; Will<br>
&gt; it work? What platform will I need to handle something like this?
I will<br>
&gt; be<br>
&gt; taking random samples but will need to get descriptive statistics
from the<br>
&gt; entire population.<br>
&gt;<br>
&gt; --<br>
&gt; View this message in context:<br>
&gt; </font><a href="http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp5713809.html"><font size=3 face="Times">http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp5713809.html</font></a><font size=3 face="Times"><br>
&gt;<br>
&gt; Sent from the SPSSX Discussion mailing list archive at </font><a href=http://nabble.com/ target=_blank><font size=3 color=blue face="Times"><u>Nabble.com</u></font></a><font size=3 face="Times">.<br>
&gt;<br>
&gt; =====================<br>
&gt; To manage your subscription to SPSSX-L, send a message to<br>
&gt; LISTSERV@.UGA (not to SPSSX-L), with no body text except the<br>
&gt; command. To leave the list, send the command<br>
&gt; SIGNOFF SPSSX-L<br>
&gt; For a list of commands to manage subscriptions, send the command<br>
&gt; INFO REFCARD<br>
&gt;<br>
<br>
<br>
--<br>
View this message in context: </font><a href="http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp5713809p5713886.html"><font size=3 face="Times">http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp5713809p5713886.html</font></a><font size=3 face="Times"><br>
Sent from the SPSSX Discussion mailing list archive at Nabble.com.<br>
<br>
=====================<br>
To manage your subscription to SPSSX-L, send a message to</font><font size=3 color=blue face="Times"><u><br>
</u></font><a href=mailto:[hidden email]><font size=3 color=blue face="Times"><u>[hidden email]</u></font></a><font size=3 face="Times">
(not to SPSSX-L), with no body text except the<br>
command. To leave the list, send the command<br>
SIGNOFF SPSSX-L<br>
For a list of commands to manage subscriptions, send the command<br>
INFO REFCARD<br>
<br>
</font>
<br>
--=_alternative 004FDAAF86257A2C_=--

------------------------------

Date:    Fri, 29 Jun 2012 07:52:57 -0700
From:    Tom1234 <[hidden email]>
Subject: Spss Syntax select all values in a variable?

Is there any way in syntax(or otherwise) to select (and count) the number of
values in a variable?
I understand that VALUE LABELS is to assign them, but how would I select
already existing values/Value labels?

The reason being is:
I'm trying to write a script in SAX/WinWrap basic that allows me to
auto-code the value labels of variables in three ways:
1 - Via input box: User is prompted to enter variable and then a loop
selects the next available value and prompts the user to enter a value label
for each value that hasn't got a label already.
2 - By directly copying: User is prompted to enter variable and then a loop
reads the value, if it is a string the script puts a upper case letter at
the start and replaces any ^s with 's (a common error when exporting from
cati or excel) and then displays a message box saying the coding is
complete.
3 - Shift the value labels by a specified amount, user is prompted to enter
the number (positive or negative) that they want the labels to move (very
usefull when recoding large numbers of values) i.e. if you have 245 values
and you remove number 36 and 37 from the list, you'd have to redo the value
labels of every value after 35 so that they were 2 places closer if you
wanted consecutive values.

Here's part of my proto/pseudo code:


-----

"Lo there do I see my father. Lo there do I see my mother and my sisters and my brothers. Lo there do I see the line of my people, back to the beginning. Lo, they do call to me, they bid me take my place among them, in the Halls of Valhalla, where the brave may live...forever."
--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Spss-Syntax-select-all-values-in-a-variable-tp5713897.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

------------------------------

Date:    Fri, 29 Jun 2012 10:58:09 -0400
From:    Rich Ulrich <[hidden email]>
Subject: Re: odds ratio to chi square conversion

--_39102319-98b3-49fe-86d7-f3490a307318_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


No.  You need both sets of marginal totals to convert=20
an OR to a chi squared.  You can show this by taking a
fixed total-N and constructing various tables with the
same OR and different tests.

For the meta-analysis:  after making sure that the=20
information really is not there=2C contact the authors.
They probably will oblige.

A worthwhile meta-analysis is seldom easy.  It wants=20
expertise both in statistics and in the content=2C so=2C good luck.

--=20
Rich Ulrich=20

> Date: Fri=2C 29 Jun 2012 09:45:35 -0400
> From: [hidden email]
> Subject: odds ratio to chi square conversion
> To: [hidden email]
>=20
> Is there a way to convert an odds ratio to a chi square value? Specifical=
ly=2C given a 2x2 crosstabulation of x against y=2C the association between=
 x and y can be expressed as an odds ratio (OR: bc/ad)=2C as exp(B) from a =
logistic regression or a chi square. Knowing only either OR or B=2C can a c=
hi-square be computed? One of the places this problem comes up is in meta-a=
nalyses where authors don't report sufficient data in primary reports.
>=20
> Thanks=2C Gene Maguin
> ...
                                          =

--_39102319-98b3-49fe-86d7-f3490a307318_
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:Tahoma
}
--></style></head>
<body class=3D'hmmessage'><div dir=3D'ltr'>
No.&nbsp=3B You need both sets of marginal totals to convert <br>an OR to a=
 chi squared.&nbsp=3B You can show this by taking a<br>fixed total-N and co=
nstructing various tables with the<br>same OR and different tests.<br><br>F=
or the meta-analysis:&nbsp=3B after making sure that the <br>information re=
ally is not there=2C contact the authors.<br>They probably will oblige.<br>=
<br>A worthwhile meta-analysis is seldom easy.&nbsp=3B It wants <br>experti=
se both in statistics and in the content=2C so=2C good luck.<br><br>-- <br>=
Rich Ulrich <br><br><div><div id=3D"SkyDrivePlaceholder"></div>&gt=3B Date:=
 Fri=2C 29 Jun 2012 09:45:35 -0400<br>&gt=3B From: [hidden email]<br>&=
gt=3B Subject: odds ratio to chi square conversion<br>&gt=3B To: SPSSX-L@LI=
STSERV.UGA.EDU<br>&gt=3B <br>&gt=3B Is there a way to convert an odds ratio=
 to a chi square value? Specifically=2C given a 2x2 crosstabulation of x ag=
ainst y=2C the association between x and y can be expressed as an odds rati=
o (OR: bc/ad)=2C as exp(B) from a logistic regression or a chi square. Know=
ing only either OR or B=2C can a chi-square be computed? One of the places =
this problem comes up is in meta-analyses where authors don't report suffic=
ient data in primary reports.<br>&gt=3B <br>&gt=3B Thanks=2C Gene Maguin<br=
>&gt=3B ...<br></div>                                     </div></body>
</html>=

--_39102319-98b3-49fe-86d7-f3490a307318_--

------------------------------

Date:    Fri, 29 Jun 2012 09:03:17 -0600
From:    Jon K Peck <[hidden email]>
Subject: Re: SPSS Database Capacity

This is a multipart message in MIME format.
--=_alternative 0052B23887257A2C_=
Content-Type: text/plain; charset="US-ASCII"

Information on absolute limits on cases and variables in Statistics isn't
readily available, because those limits are far beyond practical
constraints imposed by the hardware and OS.  IOW, you can assume that no
such limits exist on the part of Statistics.  However, there are a few
procedures - mainly time series oriented, that require the data to be held
in memory and are thus likely to run out of resources sooner than the
general case.  Since Statistics mostly does not hold all the cases in
memory, you will run out of patience before you run out of memory.

Our QA testbed goes up to 66,000 variables and more than 4 billion cases.
That is an absurd number of variables, but there you are.  Certainly,
keeping the number of variables down to a reasonable number will speed
performance.  And I often wonder why people are often so averse to taking
random samples of vast datasets except in situations where they are
searching for needle-in-haystack very rare events.

BTW, I learned an interesting fact recently about the Watson system that
won the Jeopardy contest.  It had 155 terabytes of physical memory.  Don't
try that at home.

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621




From:   David Marso <[hidden email]>
To:     [hidden email]
Date:   06/28/2012 09:59 PM
Subject:        Re: [SPSSX-L] SPSS Database Capacity
Sent by:        "SPSSX(r) Discussion" <[hidden email]>



Hi Jon,
Please (when you have a moment) restate the actual *ABSOLUTE* max cases X
max vars for both 32 bit and 64 bits maybe even 132 bit systems just for
the
hell of it  (assuming infinite disk space and RAM).  Would love a core
dump
of the theory.

Jon K Peck wrote

>
> 1.5M records is not a large file by SPSS standards.
>
> Jon Peck (no "h") aka Kim
> Senior Software Engineer, IBM
> peck@.ibm
> new phone: 720-342-5621
>
>
>
>
> From:   btafoya &lt;btafoya@&gt;
> To:     SPSSX-L@.uga
> Date:   06/26/2012 08:39 PM
> Subject:        [SPSSX-L] SPSS Database Capacity
> Sent by:        "SPSSX(r) Discussion" &lt;SPSSX-L@.uga&gt;
>
>
>
> I have a population of 1.5 Million records that I want to use in SPSS.
> Will
> it work? What platform will I need to handle something like this? I will
> be
> taking random samples but will need to get descriptive statistics from
the
> entire population.
>
> --
> View this message in context:
>
http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp5713809.html

>
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> LISTSERV@.UGA (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
>


--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp5713809p5713886.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



--=_alternative 0052B23887257A2C_=
Content-Type: text/html; charset="US-ASCII"

<font size=2 face="sans-serif">Information on absolute limits on cases
and variables in Statistics isn't readily available, because those limits
are far beyond practical constraints imposed by the hardware and OS. &nbsp;IOW,
you can assume that no such limits exist on the part of Statistics. &nbsp;However,
there are a few procedures - mainly time series oriented, that require
the data to be held in memory and are thus likely to run out of resources
sooner than the general case. &nbsp;Since Statistics mostly does not hold
all the cases in memory, you will run out of patience before you run out
of memory.</font>
<br>
<br><font size=2 face="sans-serif">Our QA testbed goes up to 66,000 variables
and more than 4 billion cases. &nbsp;That is an absurd number of variables,
but there you are. &nbsp;Certainly, keeping the number of variables down
to a reasonable number will speed performance. &nbsp;And I often wonder
why people are often so averse to taking random samples of vast datasets
except in situations where they are searching for needle-in-haystack very
rare events.</font>
<br>
<br><font size=2 face="sans-serif">BTW, I learned an interesting fact recently
about the Watson system that won the Jeopardy contest. &nbsp;It had 155
terabytes of physical memory. &nbsp;Don't try that at home.</font>
<br><font size=2 face="sans-serif"><br>
Jon Peck (no &quot;h&quot;) aka Kim<br>
Senior Software Engineer, IBM<br>
[hidden email]<br>
new phone: 720-342-5621<br>
</font>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">David Marso &lt;[hidden email]&gt;</font>
<br><font size=1 color=#5f5f5f face="sans-serif">To: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">[hidden email]</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">06/28/2012 09:59 PM</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject: &nbsp; &nbsp;
&nbsp; &nbsp;</font><font size=1 face="sans-serif">Re: [SPSSX-L]
SPSS Database Capacity</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Sent by: &nbsp; &nbsp;
&nbsp; &nbsp;</font><font size=1 face="sans-serif">&quot;SPSSX(r)
Discussion&quot; &lt;[hidden email]&gt;</font>
<br>
<hr noshade>
<br>
<br>
<br><tt><font size=2>Hi Jon,<br>
Please (when you have a moment) restate the actual *ABSOLUTE* max cases
X<br>
max vars for both 32 bit and 64 bits maybe even 132 bit systems just for
the<br>
hell of it &nbsp;(assuming infinite disk space and RAM). &nbsp;Would love
a core dump<br>
of the theory.<br>
<br>
Jon K Peck wrote<br>
&gt;<br>
&gt; 1.5M records is not a large file by SPSS standards.<br>
&gt;<br>
&gt; Jon Peck (no &quot;h&quot;) aka Kim<br>
&gt; Senior Software Engineer, IBM<br>
&gt; peck@.ibm<br>
&gt; new phone: 720-342-5621<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; From: &nbsp; btafoya &amp;lt;btafoya@&amp;gt;<br>
&gt; To: &nbsp; &nbsp; SPSSX-L@.uga<br>
&gt; Date: &nbsp; 06/26/2012 08:39 PM<br>
&gt; Subject: &nbsp; &nbsp; &nbsp; &nbsp;[SPSSX-L] SPSS Database Capacity<br>
&gt; Sent by: &nbsp; &nbsp; &nbsp; &nbsp;&quot;SPSSX(r) Discussion&quot;
&amp;lt;SPSSX-L@.uga&amp;gt;<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; I have a population of 1.5 Million records that I want to use in SPSS.<br>
&gt; Will<br>
&gt; it work? What platform will I need to handle something like this?
I will<br>
&gt; be<br>
&gt; taking random samples but will need to get descriptive statistics
from the<br>
&gt; entire population.<br>
&gt;<br>
&gt; --<br>
&gt; View this message in context:<br>
&gt; </font></tt><a href="http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp5713809.html"><tt><font size=2>http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp5713809.html</font></tt></a><tt><font size=2><br>
&gt;<br>
&gt; Sent from the SPSSX Discussion mailing list archive at Nabble.com.<br>
&gt;<br>
&gt; =====================<br>
&gt; To manage your subscription to SPSSX-L, send a message to<br>
&gt; LISTSERV@.UGA (not to SPSSX-L), with no body text except the<br>
&gt; command. To leave the list, send the command<br>
&gt; SIGNOFF SPSSX-L<br>
&gt; For a list of commands to manage subscriptions, send the command<br>
&gt; INFO REFCARD<br>
&gt;<br>
<br>
<br>
--<br>
View this message in context: </font></tt><a href="http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp5713809p5713886.html"><tt><font size=2>http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp5713809p5713886.html</font></tt></a><tt><font size=2><br>
Sent from the SPSSX Discussion mailing list archive at Nabble.com.<br>
<br>
=====================<br>
To manage your subscription to SPSSX-L, send a message to<br>
[hidden email] (not to SPSSX-L), with no body text except the<br>
command. To leave the list, send the command<br>
SIGNOFF SPSSX-L<br>
For a list of commands to manage subscriptions, send the command<br>
INFO REFCARD<br>
<br>
</font></tt>
<br>
--=_alternative 0052B23887257A2C_=--

------------------------------

Date:    Fri, 29 Jun 2012 09:05:44 -0600
From:    Jon K Peck <[hidden email]>
Subject: Re: Spss Syntax select all values in a variable?

This is a multipart message in MIME format.
--=_alternative 0052E45C87257A2C_=
Content-Type: text/plain; charset="US-ASCII"

There are many ways to do this.  The simplest is to run AGGREGATE using
the variable as a break variable and creating a new dataset from the
output and then examine its size.

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621




From:   Tom1234 <[hidden email]>
To:     [hidden email]
Date:   06/29/2012 08:58 AM
Subject:        [SPSSX-L] Spss Syntax select all values in a variable?
Sent by:        "SPSSX(r) Discussion" <[hidden email]>



Is there any way in syntax(or otherwise) to select (and count) the number
of
values in a variable?
I understand that VALUE LABELS is to assign them, but how would I select
already existing values/Value labels?

The reason being is:
I'm trying to write a script in SAX/WinWrap basic that allows me to
auto-code the value labels of variables in three ways:
1 - Via input box: User is prompted to enter variable and then a loop
selects the next available value and prompts the user to enter a value
label
for each value that hasn't got a label already.
2 - By directly copying: User is prompted to enter variable and then a
loop
reads the value, if it is a string the script puts a upper case letter at
the start and replaces any ^s with 's (a common error when exporting from
cati or excel) and then displays a message box saying the coding is
complete.
3 - Shift the value labels by a specified amount, user is prompted to
enter
the number (positive or negative) that they want the labels to move (very
usefull when recoding large numbers of values) i.e. if you have 245 values
and you remove number 36 and 37 from the list, you'd have to redo the
value
labels of every value after 35 so that they were 2 places closer if you
wanted consecutive values.

Here's part of my proto/pseudo code:


-----

"Lo there do I see my father. Lo there do I see my mother and my sisters
and my brothers. Lo there do I see the line of my people, back to the
beginning. Lo, they do call to me, they bid me take my place among them,
in the Halls of Valhalla, where the brave may live...forever."
--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Spss-Syntax-select-all-values-in-a-variable-tp5713897.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



--=_alternative 0052E45C87257A2C_=
Content-Type: text/html; charset="US-ASCII"

<font size=2 face="sans-serif">There are many ways to do this. &nbsp;The
simplest is to run AGGREGATE using the variable as a break variable and
creating a new dataset from the output and then examine its size.</font>
<br><font size=2 face="sans-serif"><br>
Jon Peck (no &quot;h&quot;) aka Kim<br>
Senior Software Engineer, IBM<br>
[hidden email]<br>
new phone: 720-342-5621<br>
</font>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">Tom1234 &lt;[hidden email]&gt;</font>
<br><font size=1 color=#5f5f5f face="sans-serif">To: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">[hidden email]</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">06/29/2012 08:58 AM</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject: &nbsp; &nbsp;
&nbsp; &nbsp;</font><font size=1 face="sans-serif">[SPSSX-L] Spss
Syntax select all values in a variable?</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Sent by: &nbsp; &nbsp;
&nbsp; &nbsp;</font><font size=1 face="sans-serif">&quot;SPSSX(r)
Discussion&quot; &lt;[hidden email]&gt;</font>
<br>
<hr noshade>
<br>
<br>
<br><tt><font size=2>Is there any way in syntax(or otherwise) to select
(and count) the number of<br>
values in a variable?<br>
I understand that VALUE LABELS is to assign them, but how would I select<br>
already existing values/Value labels?<br>
<br>
The reason being is:<br>
I'm trying to write a script in SAX/WinWrap basic that allows me to<br>
auto-code the value labels of variables in three ways:<br>
1 - Via input box: User is prompted to enter variable and then a loop<br>
selects the next available value and prompts the user to enter a value
label<br>
for each value that hasn't got a label already.<br>
2 - By directly copying: User is prompted to enter variable and then a
loop<br>
reads the value, if it is a string the script puts a upper case letter
at<br>
the start and replaces any ^s with 's (a common error when exporting from<br>
cati or excel) and then displays a message box saying the coding is<br>
complete.<br>
3 - Shift the value labels by a specified amount, user is prompted to enter<br>
the number (positive or negative) that they want the labels to move (very<br>
usefull when recoding large numbers of values) i.e. if you have 245 values<br>
and you remove number 36 and 37 from the list, you'd have to redo the value<br>
labels of every value after 35 so that they were 2 places closer if you<br>
wanted consecutive values.<br>
<br>
Here's part of my proto/pseudo code:<br>
<br>
<br>
-----<br>
<br>
&quot;Lo there do I see my father. Lo there do I see my mother and my sisters
and my brothers. Lo there do I see the line of my people, back to the beginning.
Lo, they do call to me, they bid me take my place among them, in the Halls
of Valhalla, where the brave may live...forever.&quot;<br>
--<br>
View this message in context: </font></tt><a href="http://spssx-discussion.1045642.n5.nabble.com/Spss-Syntax-select-all-values-in-a-variable-tp5713897.html"><tt><font size=2>http://spssx-discussion.1045642.n5.nabble.com/Spss-Syntax-select-all-values-in-a-variable-tp5713897.html</font></tt></a><tt><font size=2><br>
Sent from the SPSSX Discussion mailing list archive at Nabble.com.<br>
<br>
=====================<br>
To manage your subscription to SPSSX-L, send a message to<br>
[hidden email] (not to SPSSX-L), with no body text except the<br>
command. To leave the list, send the command<br>
SIGNOFF SPSSX-L<br>
For a list of commands to manage subscriptions, send the command<br>
INFO REFCARD<br>
<br>
</font></tt>
<br>
--=_alternative 0052E45C87257A2C_=--

------------------------------

Date:    Fri, 29 Jun 2012 11:17:56 -0400
From:    "Maguin, Eugene" <[hidden email]>
Subject: Re: SPSS Database Capacity

--_000_4024B96CBC305F4E863248D2D6CDF5A813E3902295MBCCR5itorgad_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Jon,

Perhaps you would comment on this please.
Recently somebody asked me off-list about display problems opening a 37Gb S=
PSS file with 90.546M records (rows).  This person said he had a pop-up mes=
sage that SPSS can 'only' display 90,500,000 rows. Are there display limits=
 and if so, are those limits determined by the specifications of the comput=
er. What specifications go into determining the limits and are there settin=
gs that can be tweaked to increase the limits?

Thanks, Gene Maguin




From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Jo=
n K Peck
Sent: Friday, June 29, 2012 11:03 AM
To: [hidden email]
Subject: Re: SPSS Database Capacity

Information on absolute limits on cases and variables in Statistics isn't r=
eadily available, because those limits are far beyond practical constraints=
 imposed by the hardware and OS.  IOW, you can assume that no such limits e=
xist on the part of Statistics.  However, there are a few procedures - main=
ly time series oriented, that require the data to be held in memory and are=
 thus likely to run out of resources sooner than the general case.  Since S=
tatistics mostly does not hold all the cases in memory, you will run out of=
 patience before you run out of memory.

Our QA testbed goes up to 66,000 variables and more than 4 billion cases.  =
That is an absurd number of variables, but there you are.  Certainly, keepi=
ng the number of variables down to a reasonable number will speed performan=
ce.  And I often wonder why people are often so averse to taking random sam=
ples of vast datasets except in situations where they are searching for nee=
dle-in-haystack very rare events.

BTW, I learned an interesting fact recently about the Watson system that wo=
n the Jeopardy contest.  It had 155 terabytes of physical memory.  Don't tr=
y that at home.

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]<mailto:[hidden email]>
new phone: 720-342-5621




From:        David Marso <[hidden email]<mailto:[hidden email]=
m>>
To:        [hidden email]<mailto:[hidden email]>
Date:        06/28/2012 09:59 PM
Subject:        Re: [SPSSX-L] SPSS Database Capacity
Sent by:        "SPSSX(r) Discussion" <[hidden email]<mailto:SPSS=
[hidden email]>>
________________________________



Hi Jon,
Please (when you have a moment) restate the actual *ABSOLUTE* max cases X
max vars for both 32 bit and 64 bits maybe even 132 bit systems just for th=
e
hell of it  (assuming infinite disk space and RAM).  Would love a core dump
of the theory.

Jon K Peck wrote

>
> 1.5M records is not a large file by SPSS standards.
>
> Jon Peck (no "h") aka Kim
> Senior Software Engineer, IBM
> peck@.ibm<mailto:peck@.ibm>
> new phone: 720-342-5621
>
>
>
>
> From:   btafoya &lt;btafoya@&gt;
> To:     SPSSX-L@.uga<mailto:SPSSX-L@.uga>
> Date:   06/26/2012 08:39 PM
> Subject:        [SPSSX-L] SPSS Database Capacity
> Sent by:        "SPSSX(r) Discussion" &lt;SPSSX-L@.uga&gt;
>
>
>
> I have a population of 1.5 Million records that I want to use in SPSS.
> Will
> it work? What platform will I need to handle something like this? I will
> be
> taking random samples but will need to get descriptive statistics from th=
e
> entire population.
>
> --
> View this message in context:
> http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp57=
13809.html
>
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> To manage your subscription to SPSSX-L, send a message to
> LISTSERV@.UGA<mailto:LISTSERV@.UGA> (not to SPSSX-L), with no body text e=
xcept 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
>


--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com=
/SPSS-Database-Capacity-tp5713809p5713886.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
To manage your subscription to SPSSX-L, send a message to
[hidden email]<mailto:[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


--_000_4024B96CBC305F4E863248D2D6CDF5A813E3902295MBCCR5itorgad_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40"><head><meta http-equiv=3DContent-Type content=
=3D"text/html; charset=3Dus-ascii"><meta name=3DGenerator content=3D"Micros=
oft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#def=
ault#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
tt
        {mso-style-priority:99;
        font-family:"Courier New";}
span.EmailStyle18
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-family:"Calibri","sans-serif";}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DEN-US link=3Dblue vli=
nk=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><span style=3D'f=
ont-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Jon, <o:p=
></o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:11.0pt;font=
-family:"Calibri","sans-serif";color:#1F497D'><o:p>&nbsp;</o:p></span></p><=
p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri","=
sans-serif";color:#1F497D'>Perhaps you would comment on this please. <o:p><=
/o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-f=
amily:"Calibri","sans-serif";color:#1F497D'>Recently somebody asked me off-=
list about display problems opening a </span>37Gb SPSS file with 90.546M re=
cords (rows).&nbsp; This person said he had a pop-up message that SPSS can =
&#8216;only&#8217; display 90,500,000 rows.&nbsp;Are there display limits a=
nd if so, are those limits determined by the specifications of the computer=
. What specifications go into determining the limits and are there settings=
 that can be tweaked to increase the limits?<o:p></o:p></p><p class=3DMsoNo=
rmal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal><span style=3D'font-size:11.=
0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thanks, Gene Maguin<o=
:p></o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:11.0pt;fo=
nt-family:"Calibri","sans-serif";color:#1F497D'><o:p>&nbsp;</o:p></span></p=
><p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri"=
,"sans-serif";color:#1F497D'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNorm=
al><span style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color=
:#1F497D'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span style=3D'f=
ont-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p>&nbs=
p;</o:p></span></p><p class=3DMsoNormal><b><span style=3D'font-size:10.0pt;=
font-family:"Tahoma","sans-serif"'>From:</span></b><span style=3D'font-size=
:10.0pt;font-family:"Tahoma","sans-serif"'> SPSSX(r) Discussion [mailto:SPS=
[hidden email]] <b>On Behalf Of </b>Jon K Peck<br><b>Sent:</b> Frida=
y, June 29, 2012 11:03 AM<br><b>To:</b> [hidden email]<br><b>Subj=
ect:</b> Re: SPSS Database Capacity<o:p></o:p></span></p><p class=3DMsoNorm=
al><o:p>&nbsp;</o:p></p><p class=3DMsoNormal><span style=3D'font-size:10.0p=
t;font-family:"Arial","sans-serif"'>Information on absolute limits on cases=
 and variables in Statistics isn't readily available, because those limits =
are far beyond practical constraints imposed by the hardware and OS. &nbsp;=
IOW, you can assume that no such limits exist on the part of Statistics. &n=
bsp;However, there are a few procedures - mainly time series oriented, that=
 require the data to be held in memory and are thus likely to run out of re=
sources sooner than the general case. &nbsp;Since Statistics mostly does no=
t hold all the cases in memory, you will run out of patience before you run=
 out of memory.</span> <br><br><span style=3D'font-size:10.0pt;font-family:=
"Arial","sans-serif"'>Our QA testbed goes up to 66,000 variables and more t=
han 4 billion cases. &nbsp;That is an absurd number of variables, but there=
 you are. &nbsp;Certainly, keeping the number of variables down to a reason=
able number will speed performance. &nbsp;And I often wonder why people are=
 often so averse to taking random samples of vast datasets except in situat=
ions where they are searching for needle-in-haystack very rare events.</spa=
n> <br><br><span style=3D'font-size:10.0pt;font-family:"Arial","sans-serif"=
'>BTW, I learned an interesting fact recently about the Watson system that =
won the Jeopardy contest. &nbsp;It had 155 terabytes of physical memory. &n=
bsp;Don't try that at home.</span> <br><span style=3D'font-size:10.0pt;font=
-family:"Arial","sans-serif"'><br>Jon Peck (no &quot;h&quot;) aka Kim<br>Se=
nior Software Engineer, IBM<br><a href=3D"mailto:[hidden email]">[hidden email]=
bm.com</a><br>new phone: 720-342-5621<br></span><br><br><br><br><span style=
=3D'font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F'>From: &=
nbsp; &nbsp; &nbsp; &nbsp;</span><span style=3D'font-size:7.5pt;font-family=
:"Arial","sans-serif"'>David Marso &lt;<a href=3D"mailto:david.marso@gmail.=
com">[hidden email]</a>&gt;</span> <br><span style=3D'font-size:7.5p=
t;font-family:"Arial","sans-serif";color:#5F5F5F'>To: &nbsp; &nbsp; &nbsp; =
&nbsp;</span><span style=3D'font-size:7.5pt;font-family:"Arial","sans-serif=
"'><a href=3D"mailto:[hidden email]">[hidden email]</a>=
</span> <br><span style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"=
;color:#5F5F5F'>Date: &nbsp; &nbsp; &nbsp; &nbsp;</span><span style=3D'font=
-size:7.5pt;font-family:"Arial","sans-serif"'>06/28/2012 09:59 PM</span> <b=
r><span style=3D'font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F=
5F5F'>Subject: &nbsp; &nbsp; &nbsp; &nbsp;</span><span style=3D'font-size:7=
.5pt;font-family:"Arial","sans-serif"'>Re: [SPSSX-L] SPSS Database Capacity=
</span> <br><span style=3D'font-size:7.5pt;font-family:"Arial","sans-serif"=
;color:#5F5F5F'>Sent by: &nbsp; &nbsp; &nbsp; &nbsp;</span><span style=3D'f=
ont-size:7.5pt;font-family:"Arial","sans-serif"'>&quot;SPSSX(r) Discussion&=
quot; &lt;<a href=3D"mailto:[hidden email]">[hidden email].=
edu</a>&gt;</span> <o:p></o:p></p><div class=3DMsoNormal align=3Dcenter sty=
le=3D'text-align:center'><hr size=3D2 width=3D"100%" noshade style=3D'color=
:#A0A0A0' align=3Dcenter></div><p class=3DMsoNormal style=3D'margin-bottom:=
12.0pt'><br><br><br><tt><span style=3D'font-size:10.0pt'>Hi Jon,</span></tt=
><span style=3D'font-size:10.0pt;font-family:"Courier New"'><br><tt>Please =
(when you have a moment) restate the actual *ABSOLUTE* max cases X</tt><br>=
<tt>max vars for both 32 bit and 64 bits maybe even 132 bit systems just fo=
r the</tt><br><tt>hell of it &nbsp;(assuming infinite disk space and RAM). =
&nbsp;Would love a core dump</tt><br><tt>of the theory.</tt><br><br><tt>Jon=
 K Peck wrote</tt><br><tt>&gt;</tt><br><tt>&gt; 1.5M records is not a large=
 file by SPSS standards.</tt><br><tt>&gt;</tt><br><tt>&gt; Jon Peck (no &qu=
ot;h&quot;) aka Kim</tt><br><tt>&gt; Senior Software Engineer, IBM</tt><br>=
<tt>&gt; <a href=3D"mailto:peck@.ibm">peck@.ibm</a></tt><br><tt>&gt; new ph=
one: 720-342-5621</tt><br><tt>&gt;</tt><br><tt>&gt;</tt><br><tt>&gt;</tt><b=
r><tt>&gt;</tt><br><tt>&gt; From: &nbsp; btafoya &amp;lt;btafoya@&amp;gt;</=
tt><br><tt>&gt; To: &nbsp; &nbsp; <a href=3D"mailto:SPSSX-L@.uga">SPSSX-L@.=
uga</a></tt><br><tt>&gt; Date: &nbsp; 06/26/2012 08:39 PM</tt><br><tt>&gt; =
Subject: &nbsp; &nbsp; &nbsp; &nbsp;[SPSSX-L] SPSS Database Capacity</tt><b=
r><tt>&gt; Sent by: &nbsp; &nbsp; &nbsp; &nbsp;&quot;SPSSX(r) Discussion&qu=
ot; &amp;lt;SPSSX-L@.uga&amp;gt;</tt><br><tt>&gt;</tt><br><tt>&gt;</tt><br>=
<tt>&gt;</tt><br><tt>&gt; I have a population of 1.5 Million records that I=
 want to use in SPSS.</tt><br><tt>&gt; Will</tt><br><tt>&gt; it work? What =
platform will I need to handle something like this? I will</tt><br><tt>&gt;=
 be</tt><br><tt>&gt; taking random samples but will need to get descriptive=
 statistics from the</tt><br><tt>&gt; entire population.</tt><br><tt>&gt;</=
tt><br><tt>&gt; --</tt><br><tt>&gt; View this message in context:</tt><br><=
tt>&gt; </tt></span><a href=3D"http://spssx-discussion.1045642.n5.nabble.co=
m/SPSS-Database-Capacity-tp5713809.html"><tt><span style=3D'font-size:10.0p=
t'>http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp5=
713809.html</span></tt></a><span style=3D'font-size:10.0pt;font-family:"Cou=
rier New"'><br><tt>&gt;</tt><br><tt>&gt; Sent from the SPSSX Discussion mai=
ling list archive at Nabble.com.</tt><br><tt>&gt;</tt><br><tt>&gt; =3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</tt><br><tt>&gt; =
To manage your subscription to SPSSX-L, send a message to</tt><br><tt>&gt; =
<a href=3D"mailto:LISTSERV@.UGA">LISTSERV@.UGA</a> (not to SPSSX-L), with n=
o body text except the</tt><br><tt>&gt; command. To leave the list, send th=
e command</tt><br><tt>&gt; SIGNOFF SPSSX-L</tt><br><tt>&gt; For a list of c=
ommands to manage subscriptions, send the command</tt><br><tt>&gt; INFO REF=
CARD</tt><br><tt>&gt;</tt><br><br><br><tt>--</tt><br><tt>View this message =
in context: </tt></span><a href=3D"http://spssx-discussion.1045642.n5.nabbl=
e.com/SPSS-Database-Capacity-tp5713809p5713886.html"><tt><span style=3D'fon=
t-size:10.0pt'>http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-=
Capacity-tp5713809p5713886.html</span></tt></a><span style=3D'font-size:10.=
0pt;font-family:"Courier New"'><br><tt>Sent from the SPSSX Discussion maili=
ng list archive at Nabble.com.</tt><br><br><tt>=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</tt><br><tt>To manage your subscriptio=
n to SPSSX-L, send a message to</tt><br><tt><a href=3D"mailto:LISTSERV@LIST=
SERV.UGA.EDU">[hidden email]</a> (not to SPSSX-L), with no body =
text except the</tt><br><tt>command. To leave the list, send the command</t=
t><br><tt>SIGNOFF SPSSX-L</tt><br><tt>For a list of commands to manage subs=
criptions, send the command</tt><br><tt>INFO REFCARD</tt><br><br></span><o:=
p></o:p></p></div></body></html>=

--_000_4024B96CBC305F4E863248D2D6CDF5A813E3902295MBCCR5itorgad_--

------------------------------

Date:    Fri, 29 Jun 2012 15:24:22 +0000
From:    "Poes, Matthew Joseph" <[hidden email]>
Subject: Re: SPSS Database Capacity

--_000_139EBE2EF1603B48A3BC8F89B34434D414FE91FECITESMBX3aduill_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I believe the aversion to random sampling (as I experience it) is that peop=
le often have a tendency to hoard.  There is reluctance to give up the data=
, given the time and money spent on collecting it.  Often there is also a b=
elief that if your sample is actually a population, then then you should an=
alyze the entire population, instead of a sample of it, because its somehow=
 more valid.  There doesn't seem to be a clear understanding that you can i=
nfer with near total confidence everything you need from just a sample, as =
compared with the entire population.  Added to that is the common misconcep=
tions with regard to drawing multiple random samples to confirm results.  P=
eople often don't understand the statistics they want or use, and don't und=
erstand why we can't just give them a single number.  I believe its related=
 to the same mindset that has led to numerous requests for how to do a mult=
iple imputation and save out a single data set.

To echo what Jon has mentioned on some practical limits, some of my analysi=
s work has required that I allow the program to run overnight or for a few =
hours, and increased variables and cases are frequently the result.  One ex=
ample you could run into is ridge regression.  Another one I use far more o=
ften are the mixed modeling (MLM/HLM, etc.).  With regard to MLM, I have fo=
und that the most common cause of overnight run times is a misspecification=
 of the model in which I attempted to allow too many variables to be random=
 to the point of absurdity.  Occasionally this will happen with a reasonabl=
y specified model, where my a-priori theory that some factor be allowed to =
vary random is reasonable, but where the number of varied levels and amount=
 of cases is so large that it takes quite a long time to converge on a fina=
l model.  Again the main cause is a large number of levels to said model, a=
nd many blocks within higher levels.  This is not an SPSS problem (maybe th=
e efficiency of the algorithm, but I don't know that others are better), ra=
ther it's a hardware resource problem.

Matthew J Poes
Research Data Specialist
Center for Prevention Research and Development
University of Illinois
510 Devonshire Dr.
Champaign, IL 61820
Phone: 217-265-4576
email: [hidden email]<mailto:[hidden email]>


From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Jo=
n K Peck
Sent: Friday, June 29, 2012 10:03 AM
To: [hidden email]
Subject: Re: SPSS Database Capacity

Information on absolute limits on cases and variables in Statistics isn't r=
eadily available, because those limits are far beyond practical constraints=
 imposed by the hardware and OS.  IOW, you can assume that no such limits e=
xist on the part of Statistics.  However, there are a few procedures - main=
ly time series oriented, that require the data to be held in memory and are=
 thus likely to run out of resources sooner than the general case.  Since S=
tatistics mostly does not hold all the cases in memory, you will run out of=
 patience before you run out of memory.

Our QA testbed goes up to 66,000 variables and more than 4 billion cases.  =
That is an absurd number of variables, but there you are.  Certainly, keepi=
ng the number of variables down to a reasonable number will speed performan=
ce.  And I often wonder why people are often so averse to taking random sam=
ples of vast datasets except in situations where they are searching for nee=
dle-in-haystack very rare events.

BTW, I learned an interesting fact recently about the Watson system that wo=
n the Jeopardy contest.  It had 155 terabytes of physical memory.  Don't tr=
y that at home.

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]<mailto:[hidden email]>
new phone: 720-342-5621




From:        David Marso <[hidden email]<mailto:[hidden email]=
m>>
To:        [hidden email]<mailto:[hidden email]>
Date:        06/28/2012 09:59 PM
Subject:        Re: [SPSSX-L] SPSS Database Capacity
Sent by:        "SPSSX(r) Discussion" <[hidden email]<mailto:SPSS=
[hidden email]>>
________________________________



Hi Jon,
Please (when you have a moment) restate the actual *ABSOLUTE* max cases X
max vars for both 32 bit and 64 bits maybe even 132 bit systems just for th=
e
hell of it  (assuming infinite disk space and RAM).  Would love a core dump
of the theory.

Jon K Peck wrote

>
> 1.5M records is not a large file by SPSS standards.
>
> Jon Peck (no "h") aka Kim
> Senior Software Engineer, IBM
> peck@.ibm<mailto:peck@.ibm>
> new phone: 720-342-5621
>
>
>
>
> From:   btafoya &lt;btafoya@&gt;
> To:     SPSSX-L@.uga<mailto:SPSSX-L@.uga>
> Date:   06/26/2012 08:39 PM
> Subject:        [SPSSX-L] SPSS Database Capacity
> Sent by:        "SPSSX(r) Discussion" &lt;SPSSX-L@.uga&gt;
>
>
>
> I have a population of 1.5 Million records that I want to use in SPSS.
> Will
> it work? What platform will I need to handle something like this? I will
> be
> taking random samples but will need to get descriptive statistics from th=
e
> entire population.
>
> --
> View this message in context:
> http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp57=
13809.html
>
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> To manage your subscription to SPSSX-L, send a message to
> LISTSERV@.UGA<mailto:LISTSERV@.UGA> (not to SPSSX-L), with no body text e=
xcept 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
>


--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com=
/SPSS-Database-Capacity-tp5713809p5713886.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
To manage your subscription to SPSSX-L, send a message to
[hidden email]<mailto:[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


--_000_139EBE2EF1603B48A3BC8F89B34434D414FE91FECITESMBX3aduill_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
tt
        {mso-style-priority:99;
        font-family:"Courier New";}
span.EmailStyle18
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-family:"Calibri","sans-serif";}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"blue" vlink=3D"purple">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:&quot;Ca=
libri&quot;,&quot;sans-serif&quot;;color:#1F497D">I believe the aversion to=
 random sampling (as I experience it) is that people often have a tendency =
to hoard.&nbsp; There is reluctance to give up the data, given
 the time and money spent on collecting it.&nbsp; Often there is also a bel=
ief that if your sample is actually a population, then then you should anal=
yze the entire population, instead of a sample of it, because its somehow m=
ore valid.&nbsp; There doesn&#8217;t seem to be
 a clear understanding that you can infer with near total confidence everyt=
hing you need from just a sample, as compared with the entire population.&n=
bsp; Added to that is the common misconceptions with regard to drawing mult=
iple random samples to confirm results.&nbsp;
 People often don&#8217;t understand the statistics they want or use, and d=
on&#8217;t understand why we can&#8217;t just give them a single number.&nb=
sp; I believe its related to the same mindset that has led to numerous requ=
ests for how to do a multiple imputation and save out a
 single data set.&nbsp; <o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:&quot;Ca=
libri&quot;,&quot;sans-serif&quot;;color:#1F497D"><o:p>&nbsp;</o:p></span><=
/p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:&quot;Ca=
libri&quot;,&quot;sans-serif&quot;;color:#1F497D">To echo what Jon has ment=
ioned on some practical limits, some of my analysis work has required that =
I allow the program to run overnight or for a few hours,
 and increased variables and cases are frequently the result.&nbsp; One exa=
mple you could run into is ridge regression.&nbsp; Another one I use far mo=
re often are the mixed modeling (MLM/HLM, etc.).&nbsp; With regard to MLM, =
I have found that the most common cause of overnight
 run times is a misspecification of the model in which I attempted to allow=
 too many variables to be random to the point of absurdity.&nbsp; Occasiona=
lly this will happen with a reasonably specified model, where my a-priori t=
heory that some factor be allowed to
 vary random is reasonable, but where the number of varied levels and amoun=
t of cases is so large that it takes quite a long time to converge on a fin=
al model.&nbsp; Again the main cause is a large number of levels to said mo=
del, and many blocks within higher levels.&nbsp;
 This is not an SPSS problem (maybe the efficiency of the algorithm, but I =
don&#8217;t know that others are better), rather it&#8217;s a hardware reso=
urce problem. &nbsp;&nbsp;&nbsp;&nbsp;<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:&quot;Ca=
libri&quot;,&quot;sans-serif&quot;;color:#1F497D"><o:p>&nbsp;</o:p></span><=
/p>
<p class=3D"MsoNormal"><b><span style=3D"font-size:11.0pt;font-family:&quot=
;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D">Matthew J Poes</span><=
/b><span style=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sa=
ns-serif&quot;;color:#1F497D"><o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:&quot;Ca=
libri&quot;,&quot;sans-serif&quot;;color:#1F497D">Research Data Specialist<=
o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:&quot;Ca=
libri&quot;,&quot;sans-serif&quot;;color:#1F497D">Center for Prevention Res=
earch and Development<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:&quot;Ca=
libri&quot;,&quot;sans-serif&quot;;color:#1F497D">University of Illinois<o:=
p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:&quot;Ca=
libri&quot;,&quot;sans-serif&quot;;color:#1F497D">510 Devonshire Dr.<o:p></=
o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:&quot;Ca=
libri&quot;,&quot;sans-serif&quot;;color:#1F497D">Champaign, IL 61820<o:p><=
/o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:&quot;Ca=
libri&quot;,&quot;sans-serif&quot;;color:#1F497D">Phone:&nbsp;217-265-4576<=
o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:&quot;Ca=
libri&quot;,&quot;sans-serif&quot;;color:#1F497D">email:
<a href=3D"mailto:[hidden email]">[hidden email]</a><o:p></o:p></sp=
an></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:&quot;Ca=
libri&quot;,&quot;sans-serif&quot;;color:#1F497D"><o:p>&nbsp;</o:p></span><=
/p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:&quot;Ca=
libri&quot;,&quot;sans-serif&quot;;color:#1F497D"><o:p>&nbsp;</o:p></span><=
/p>
<p class=3D"MsoNormal"><b><span style=3D"font-size:10.0pt;font-family:&quot=
;Tahoma&quot;,&quot;sans-serif&quot;">From:</span></b><span style=3D"font-s=
ize:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;"> SPSSX(r)=
 Discussion [mailto:[hidden email]]
<b>On Behalf Of </b>Jon K Peck<br>
<b>Sent:</b> Friday, June 29, 2012 10:03 AM<br>
<b>To:</b> [hidden email]<br>
<b>Subject:</b> Re: SPSS Database Capacity<o:p></o:p></span></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:&quot;Ar=
ial&quot;,&quot;sans-serif&quot;">Information on absolute limits on cases a=
nd variables in Statistics isn't readily available, because those limits ar=
e far beyond practical constraints imposed by the hardware
 and OS. &nbsp;IOW, you can assume that no such limits exist on the part of=
 Statistics. &nbsp;However, there are a few procedures - mainly time series=
 oriented, that require the data to be held in memory and are thus likely t=
o run out of resources sooner than the general
 case. &nbsp;Since Statistics mostly does not hold all the cases in memory,=
 you will run out of patience before you run out of memory.</span>
<br>
<br>
<span style=3D"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-se=
rif&quot;">Our QA testbed goes up to 66,000 variables and more than 4 billi=
on cases. &nbsp;That is an absurd number of variables, but there you are. &=
nbsp;Certainly, keeping the number of variables down to a reasonable
 number will speed performance. &nbsp;And I often wonder why people are oft=
en so averse to taking random samples of vast datasets except in situations=
 where they are searching for needle-in-haystack very rare events.</span>
<br>
<br>
<span style=3D"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-se=
rif&quot;">BTW, I learned an interesting fact recently about the Watson sys=
tem that won the Jeopardy contest. &nbsp;It had 155 terabytes of physical m=
emory. &nbsp;Don't try that at home.</span>
<br>
<span style=3D"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-se=
rif&quot;"><br>
Jon Peck (no &quot;h&quot;) aka Kim<br>
Senior Software Engineer, IBM<br>
<a href=3D"mailto:[hidden email]">[hidden email]</a><br>
new phone: 720-342-5621<br>
</span><br>
<br>
<br>
<br>
<span style=3D"font-size:7.5pt;font-family:&quot;Arial&quot;,&quot;sans-ser=
if&quot;;color:#5F5F5F">From: &nbsp; &nbsp; &nbsp; &nbsp;</span><span style=
=3D"font-size:7.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;">D=
avid Marso &lt;<a href=3D"mailto:[hidden email]">[hidden email]=
om</a>&gt;</span>
<br>
<span style=3D"font-size:7.5pt;font-family:&quot;Arial&quot;,&quot;sans-ser=
if&quot;;color:#5F5F5F">To: &nbsp; &nbsp; &nbsp; &nbsp;</span><span style=
=3D"font-size:7.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;"><=
a href=3D"mailto:[hidden email]">[hidden email]</a></sp=
an>
<br>
<span style=3D"font-size:7.5pt;font-family:&quot;Arial&quot;,&quot;sans-ser=
if&quot;;color:#5F5F5F">Date: &nbsp; &nbsp; &nbsp; &nbsp;</span><span style=
=3D"font-size:7.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;">0=
6/28/2012 09:59 PM</span>
<br>
<span style=3D"font-size:7.5pt;font-family:&quot;Arial&quot;,&quot;sans-ser=
if&quot;;color:#5F5F5F">Subject: &nbsp; &nbsp; &nbsp; &nbsp;</span><span st=
yle=3D"font-size:7.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;=
">Re: [SPSSX-L] SPSS Database Capacity</span>
<br>
<span style=3D"font-size:7.5pt;font-family:&quot;Arial&quot;,&quot;sans-ser=
if&quot;;color:#5F5F5F">Sent by: &nbsp; &nbsp; &nbsp; &nbsp;</span><span st=
yle=3D"font-size:7.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;=
">&quot;SPSSX(r) Discussion&quot; &lt;<a href=3D"mailto:[hidden email]=
a.edu">[hidden email]</a>&gt;</span>
<o:p></o:p></p>
<div class=3D"MsoNormal" align=3D"center" style=3D"text-align:center">
<hr size=3D"2" width=3D"100%" noshade=3D"" style=3D"color:#A0A0A0" align=3D=
"center">
</div>
<p class=3D"MsoNormal" style=3D"margin-bottom:12.0pt"><br>
<br>
<br>
<tt><span style=3D"font-size:10.0pt">Hi Jon,</span></tt><span style=3D"font=
-size:10.0pt;font-family:&quot;Courier New&quot;"><br>
<tt>Please (when you have a moment) restate the actual *ABSOLUTE* max cases=
 X</tt><br>
<tt>max vars for both 32 bit and 64 bits maybe even 132 bit systems just fo=
r the</tt><br>
<tt>hell of it &nbsp;(assuming infinite disk space and RAM). &nbsp;Would lo=
ve a core dump</tt><br>
<tt>of the theory.</tt><br>
<br>
<tt>Jon K Peck wrote</tt><br>
<tt>&gt;</tt><br>
<tt>&gt; 1.5M records is not a large file by SPSS standards.</tt><br>
<tt>&gt;</tt><br>
<tt>&gt; Jon Peck (no &quot;h&quot;) aka Kim</tt><br>
<tt>&gt; Senior Software Engineer, IBM</tt><br>
<tt>&gt; <a href=3D"mailto:peck@.ibm">peck@.ibm</a></tt><br>
<tt>&gt; new phone: 720-342-5621</tt><br>
<tt>&gt;</tt><br>
<tt>&gt;</tt><br>
<tt>&gt;</tt><br>
<tt>&gt;</tt><br>
<tt>&gt; From: &nbsp; btafoya &amp;lt;btafoya@&amp;gt;</tt><br>
<tt>&gt; To: &nbsp; &nbsp; <a href=3D"mailto:SPSSX-L@.uga">SPSSX-L@.uga</a>=
</tt><br>
<tt>&gt; Date: &nbsp; 06/26/2012 08:39 PM</tt><br>
<tt>&gt; Subject: &nbsp; &nbsp; &nbsp; &nbsp;[SPSSX-L] SPSS Database Capaci=
ty</tt><br>
<tt>&gt; Sent by: &nbsp; &nbsp; &nbsp; &nbsp;&quot;SPSSX(r) Discussion&quot=
; &amp;lt;SPSSX-L@.uga&amp;gt;</tt><br>
<tt>&gt;</tt><br>
<tt>&gt;</tt><br>
<tt>&gt;</tt><br>
<tt>&gt; I have a population of 1.5 Million records that I want to use in S=
PSS.</tt><br>
<tt>&gt; Will</tt><br>
<tt>&gt; it work? What platform will I need to handle something like this? =
I will</tt><br>
<tt>&gt; be</tt><br>
<tt>&gt; taking random samples but will need to get descriptive statistics =
from the</tt><br>
<tt>&gt; entire population.</tt><br>
<tt>&gt;</tt><br>
<tt>&gt; --</tt><br>
<tt>&gt; View this message in context:</tt><br>
<tt>&gt; </tt></span><a href=3D"http://spssx-discussion.1045642.n5.nabble.c=
om/SPSS-Database-Capacity-tp5713809.html"><tt><span style=3D"font-size:10.0=
pt">http://spssx-discussion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp=
5713809.html</span></tt></a><span style=3D"font-size:10.0pt;font-family:&qu=
ot;Courier New&quot;"><br>
<tt>&gt;</tt><br>
<tt>&gt; Sent from the SPSSX Discussion mailing list archive at Nabble.com.=
</tt><br>
<tt>&gt;</tt><br>
<tt>&gt; =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</t=
t><br>
<tt>&gt; To manage your subscription to SPSSX-L, send a message to</tt><br>
<tt>&gt; <a href=3D"mailto:LISTSERV@.UGA">LISTSERV@.UGA</a> (not to SPSSX-L=
), with no body text except the</tt><br>
<tt>&gt; command. To leave the list, send the command</tt><br>
<tt>&gt; SIGNOFF SPSSX-L</tt><br>
<tt>&gt; For a list of commands to manage subscriptions, send the command</=
tt><br>
<tt>&gt; INFO REFCARD</tt><br>
<tt>&gt;</tt><br>
<br>
<br>
<tt>--</tt><br>
<tt>View this message in context: </tt></span><a href=3D"http://spssx-discu=
ssion.1045642.n5.nabble.com/SPSS-Database-Capacity-tp5713809p5713886.html">=
<tt><span style=3D"font-size:10.0pt">http://spssx-discussion.1045642.n5.nab=
ble.com/SPSS-Database-Capacity-tp5713809p5713886.html</span></tt></a><span =
style=3D"font-size:10.0pt;font-family:&quot;Courier New&quot;"><br>
<tt>Sent from the SPSSX Discussion mailing list archive at Nabble.com.</tt>=
<br>
<br>
<tt>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</tt><br=
>
<tt>To manage your subscription to SPSSX-L, send a message to</tt><br>
<tt><a href=3D"mailto:[hidden email]">[hidden email]<=
/a> (not to SPSSX-L), with no body text except the</tt><br>
<tt>command. To leave the list, send the command</tt><br>
<tt>SIGNOFF SPSSX-L</tt><br>
<tt>For a list of commands to manage subscriptions, send the command</tt><b=
r>
<tt>INFO REFCARD</tt><br>
<br>
</span><o:p></o:p></p>
</div>
</body>
</html>

--_000_139EBE2EF1603B48A3BC8F89B34434D414FE91FECITESMBX3aduill_--

------------------------------

Date:    Fri, 29 Jun 2012 09:45:22 -0600
From:    Jon K Peck <[hidden email]>
Subject: Re: SPSS Database Capacity

This is a multipart message in MIME format.
--=_alternative 0056865D87257A2C_=
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: base64

VGhhdCBpcyBhIGRpc3BsYXkgaXNzdWUgd2l0aCB0aGUgRGF0YSBFZGl0b3IuICBJbiBzb21lIG9s
ZGVyIHZlcnNpb25zIG9mIA0KU1BTUy9TdGF0aXN0aWNzIChtYXliZSBzdGlsbCBwcmVzZW50LCBi
dXQgSSB0aGluayBpdCBpcyBnb25lKSwgdGhlIERFIGlzIA0KbGltaXRlZCBpbiBob3cgbWFueSBy
b3dzIGl0IHdpbGwgZGlzcGxheSBhcyBhIG1lbW9yeSBtYW5hZ2VtZW50IGlzc3VlLiAgSXQgDQpo
YXMgbm90aGluZyB0byBkbyB3aXRoIHByb2Nlc3NpbmcgY2FwYWJpbGl0aWVzIGluIG90aGVyIHBh
cnRzIG9mIHRoZSANCnN5c3RlbS4gIE9idmlvdXNseSBubyBvbmUgaXMgZ29pbmcgdG8gcGFnZSB0
aHJvdWdoIGh1Z2UgbnVtYmVycyBvZiByb3dzLiBJIA0KZG9uJ3QgdGhpbmsgdGhlIDkwIG1pbGxp
b24gbnVtYmVyIGlzIGNvcnJlY3QsIHRob3VnaC4gIEkgdGhpbmsgdGhlIGxpbWl0IA0Kd2FzIG1v
cmUgbGlrZSA5MCwwMDAsIGJ1dCBpdCB3YXMgY29uZmlndXJhYmxlICh2aXJ0dWFsIHJvd3MpLiAg
V2l0aCANClNlcnZlciwgaXQgaXMgcG9zc2libGUgdG8gc3VwcHJlc3MgdGhlIERFIGFsdG9nZXRo
ZXIsIHdoaWNoIGlzIGFwcHJvcHJpYXRlIA0KZm9yIHZlcnkgbGFyZ2UgZGF0YXNldHMuDQoNCkpv
biBQZWNrIChubyAiaCIpIGFrYSBLaW0NClNlbmlvciBTb2Z0d2FyZSBFbmdpbmVlciwgSUJNDQpw
ZWNrQHVzLmlibS5jb20NCm5ldyBwaG9uZTogNzIwLTM0Mi01NjIxDQoNCg0KDQoNCkZyb206ICAg
Ik1hZ3VpbiwgRXVnZW5lIiA8ZW1hZ3VpbkBidWZmYWxvLmVkdT4NClRvOiAgICAgU1BTU1gtTEBs
aXN0c2Vydi51Z2EuZWR1DQpEYXRlOiAgIDA2LzI5LzIwMTIgMDk6MjEgQU0NClN1YmplY3Q6ICAg
ICAgICBSZTogW1NQU1NYLUxdIFNQU1MgRGF0YWJhc2UgQ2FwYWNpdHkNClNlbnQgYnk6ICAgICAg
ICAiU1BTU1gocikgRGlzY3Vzc2lvbiIgPFNQU1NYLUxAbGlzdHNlcnYudWdhLmVkdT4NCg0KDQoN
CkpvbiwgDQogDQpQZXJoYXBzIHlvdSB3b3VsZCBjb21tZW50IG9uIHRoaXMgcGxlYXNlLiANClJl
Y2VudGx5IHNvbWVib2R5IGFza2VkIG1lIG9mZi1saXN0IGFib3V0IGRpc3BsYXkgcHJvYmxlbXMg
b3BlbmluZyBhIDM3R2IgDQpTUFNTIGZpbGUgd2l0aCA5MC41NDZNIHJlY29yZHMgKHJvd3MpLiAg
VGhpcyBwZXJzb24gc2FpZCBoZSBoYWQgYSBwb3AtdXAgDQptZXNzYWdlIHRoYXQgU1BTUyBjYW4g
4oCYb25seeKAmSBkaXNwbGF5IDkwLDUwMCwwMDAgcm93cy4gQXJlIHRoZXJlIGRpc3BsYXkgDQps
aW1pdHMgYW5kIGlmIHNvLCBhcmUgdGhvc2UgbGltaXRzIGRldGVybWluZWQgYnkgdGhlIHNwZWNp
ZmljYXRpb25zIG9mIHRoZSANCmNvbXB1dGVyLiBXaGF0IHNwZWNpZmljYXRpb25zIGdvIGludG8g
ZGV0ZXJtaW5pbmcgdGhlIGxpbWl0cyBhbmQgYXJlIHRoZXJlIA0Kc2V0dGluZ3MgdGhhdCBjYW4g
YmUgdHdlYWtlZCB0byBpbmNyZWFzZSB0aGUgbGltaXRzPw0KIA0KVGhhbmtzLCBHZW5lIE1hZ3Vp
bg0KIA0KIA0KIA0KIA0KRnJvbTogU1BTU1gocikgRGlzY3Vzc2lvbiBbbWFpbHRvOlNQU1NYLUxA
TElTVFNFUlYuVUdBLkVEVV0gT24gQmVoYWxmIE9mIA0KSm9uIEsgUGVjaw0KU2VudDogRnJpZGF5
LCBKdW5lIDI5LCAyMDEyIDExOjAzIEFNDQpUbzogU1BTU1gtTEBMSVNUU0VSVi5VR0EuRURVDQpT
dWJqZWN0OiBSZTogU1BTUyBEYXRhYmFzZSBDYXBhY2l0eQ0KIA0KSW5mb3JtYXRpb24gb24gYWJz
b2x1dGUgbGltaXRzIG9uIGNhc2VzIGFuZCB2YXJpYWJsZXMgaW4gU3RhdGlzdGljcyBpc24ndCAN
CnJlYWRpbHkgYXZhaWxhYmxlLCBiZWNhdXNlIHRob3NlIGxpbWl0cyBhcmUgZmFyIGJleW9uZCBw
cmFjdGljYWwgDQpjb25zdHJhaW50cyBpbXBvc2VkIGJ5IHRoZSBoYXJkd2FyZSBhbmQgT1MuICBJ
T1csIHlvdSBjYW4gYXNzdW1lIHRoYXQgbm8gDQpzdWNoIGxpbWl0cyBleGlzdCBvbiB0aGUgcGFy
dCBvZiBTdGF0aXN0aWNzLiAgSG93ZXZlciwgdGhlcmUgYXJlIGEgZmV3IA0KcHJvY2VkdXJlcyAt
IG1haW5seSB0aW1lIHNlcmllcyBvcmllbnRlZCwgdGhhdCByZXF1aXJlIHRoZSBkYXRhIHRvIGJl
IGhlbGQgDQppbiBtZW1vcnkgYW5kIGFyZSB0aHVzIGxpa2VseSB0byBydW4gb3V0IG9mIHJlc291
cmNlcyBzb29uZXIgdGhhbiB0aGUgDQpnZW5lcmFsIGNhc2UuICBTaW5jZSBTdGF0aXN0aWNzIG1v
c3RseSBkb2VzIG5vdCBob2xkIGFsbCB0aGUgY2FzZXMgaW4gDQptZW1vcnksIHlvdSB3aWxsIHJ1
biBvdXQgb2YgcGF0aWVuY2UgYmVmb3JlIHlvdSBydW4gb3V0IG9mIG1lbW9yeS4gDQoNCk91ciBR
QSB0ZXN0YmVkIGdvZXMgdXAgdG8gNjYsMDAwIHZhcmlhYmxlcyBhbmQgbW9yZSB0aGFuIDQgYmls
bGlvbiBjYXNlcy4gDQpUaGF0IGlzIGFuIGFic3VyZCBudW1iZXIgb2YgdmFyaWFibGVzLCBidXQg
dGhlcmUgeW91IGFyZS4gIENlcnRhaW5seSwgDQprZWVwaW5nIHRoZSBudW1iZXIgb2YgdmFyaWFi
bGVzIGRvd24gdG8gYSByZWFzb25hYmxlIG51bWJlciB3aWxsIHNwZWVkIA0KcGVyZm9ybWFuY2Uu
ICBBbmQgSSBvZnRlbiB3b25kZXIgd2h5IHBlb3BsZSBhcmUgb2Z0ZW4gc28gYXZlcnNlIHRvIHRh
a2luZyANCnJhbmRvbSBzYW1wbGVzIG9mIHZhc3QgZGF0YXNldHMgZXhjZXB0IGluIHNpdHVhdGlv
bnMgd2hlcmUgdGhleSBhcmUgDQpzZWFyY2hpbmcgZm9yIG5lZWRsZS1pbi1oYXlzdGFjayB2ZXJ5
IHJhcmUgZXZlbnRzLiANCg0KQlRXLCBJIGxlYXJuZWQgYW4gaW50ZXJlc3RpbmcgZmFjdCByZWNl
bnRseSBhYm91dCB0aGUgV2F0c29uIHN5c3RlbSB0aGF0IA0Kd29uIHRoZSBKZW9wYXJkeSBjb250
ZXN0LiAgSXQgaGFkIDE1NSB0ZXJhYnl0ZXMgb2YgcGh5c2ljYWwgbWVtb3J5LiAgRG9uJ3QgDQp0
cnkgdGhhdCBhdCBob21lLiANCg0KSm9uIFBlY2sgKG5vICJoIikgYWthIEtpbQ0KU2VuaW9yIFNv
ZnR3YXJlIEVuZ2luZWVyLCBJQk0NCnBlY2tAdXMuaWJtLmNvbQ0KbmV3IHBob25lOiA3MjAtMzQy
LTU2MjENCg0KDQoNCg0KRnJvbTogICAgICAgIERhdmlkIE1hcnNvIDxkYXZpZC5tYXJzb0BnbWFp
bC5jb20+IA0KVG86ICAgICAgICBTUFNTWC1MQGxpc3RzZXJ2LnVnYS5lZHUgDQpEYXRlOiAgICAg
ICAgMDYvMjgvMjAxMiAwOTo1OSBQTSANClN1YmplY3Q6ICAgICAgICBSZTogW1NQU1NYLUxdIFNQ
U1MgRGF0YWJhc2UgQ2FwYWNpdHkgDQpTZW50IGJ5OiAgICAgICAgIlNQU1NYKHIpIERpc2N1c3Np
b24iIDxTUFNTWC1MQGxpc3RzZXJ2LnVnYS5lZHU+IA0KDQoNCg0KDQpIaSBKb24sDQpQbGVhc2Ug
KHdoZW4geW91IGhhdmUgYSBtb21lbnQpIHJlc3RhdGUgdGhlIGFjdHVhbCAqQUJTT0xVVEUqIG1h
eCBjYXNlcyBYDQptYXggdmFycyBmb3IgYm90aCAzMiBiaXQgYW5kIDY0IGJpdHMgbWF5YmUgZXZl
biAxMzIgYml0IHN5c3RlbXMganVzdCBmb3IgDQp0aGUNCmhlbGwgb2YgaXQgIChhc3N1bWluZyBp
bmZpbml0ZSBkaXNrIHNwYWNlIGFuZCBSQU0pLiAgV291bGQgbG92ZSBhIGNvcmUgDQpkdW1wDQpv
ZiB0aGUgdGhlb3J5Lg0KDQpKb24gSyBQZWNrIHdyb3RlDQo+DQo+IDEuNU0gcmVjb3JkcyBpcyBu
b3QgYSBsYXJnZSBmaWxlIGJ5IFNQU1Mgc3RhbmRhcmRzLg0KPg0KPiBKb24gUGVjayAobm8gImgi
KSBha2EgS2ltDQo+IFNlbmlvciBTb2Z0d2FyZSBFbmdpbmVlciwgSUJNDQo+IHBlY2tALmlibQ0K
PiBuZXcgcGhvbmU6IDcyMC0zNDItNTYyMQ0KPg0KPg0KPg0KPg0KPiBGcm9tOiAgIGJ0YWZveWEg
Jmx0O2J0YWZveWFAJmd0Ow0KPiBUbzogICAgIFNQU1NYLUxALnVnYQ0KPiBEYXRlOiAgIDA2LzI2
LzIwMTIgMDg6MzkgUE0NCj4gU3ViamVjdDogICAgICAgIFtTUFNTWC1MXSBTUFNTIERhdGFiYXNl
IENhcGFjaXR5DQo+IFNlbnQgYnk6ICAgICAgICAiU1BTU1gocikgRGlzY3Vzc2lvbiIgJmx0O1NQ
U1NYLUxALnVnYSZndDsNCj4NCj4NCj4NCj4gSSBoYXZlIGEgcG9wdWxhdGlvbiBvZiAxLjUgTWls
bGlvbiByZWNvcmRzIHRoYXQgSSB3YW50IHRvIHVzZSBpbiBTUFNTLg0KPiBXaWxsDQo+IGl0IHdv
cms/IFdoYXQgcGxhdGZvcm0gd2lsbCBJIG5lZWQgdG8gaGFuZGxlIHNvbWV0aGluZyBsaWtlIHRo
aXM/IEkgd2lsbA0KPiBiZQ0KPiB0YWtpbmcgcmFuZG9tIHNhbXBsZXMgYnV0IHdpbGwgbmVlZCB0
byBnZXQgZGVzY3JpcHRpdmUgc3RhdGlzdGljcyBmcm9tIA0KdGhlDQo+IGVudGlyZSBwb3B1bGF0
aW9uLg0KPg0KPiAtLQ0KPiBWaWV3IHRoaXMgbWVzc2FnZSBpbiBjb250ZXh0Og0KPiANCmh0dHA6
Ly9zcHNzeC1kaXNjdXNzaW9uLjEwNDU2NDIubjUubmFiYmxlLmNvbS9TUFNTLURhdGFiYXNlLUNh
cGFjaXR5LXRwNTcxMzgwOS5odG1sDQoNCj4NCj4gU2VudCBmcm9tIHRoZSBTUFNTWCBEaXNjdXNz
aW9uIG1haWxpbmcgbGlzdCBhcmNoaXZlIGF0IE5hYmJsZS5jb20uDQo+DQo+ID09PT09PT09PT09
PT09PT09PT09PQ0KPiBUbyBtYW5hZ2UgeW91ciBzdWJzY3JpcHRpb24gdG8gU1BTU1gtTCwgc2Vu
ZCBhIG1lc3NhZ2UgdG8NCj4gTElTVFNFUlZALlVHQSAobm90IHRvIFNQU1NYLUwpLCB3aXRoIG5v
IGJvZHkgdGV4dCBleGNlcHQgdGhlDQo+IGNvbW1hbmQuIFRvIGxlYXZlIHRoZSBsaXN0LCBzZW5k
IHRoZSBjb21tYW5kDQo+IFNJR05PRkYgU1BTU1gtTA0KPiBGb3IgYSBsaXN0IG9mIGNvbW1hbmRz
IHRvIG1hbmFnZSBzdWJzY3JpcHRpb25zLCBzZW5kIHRoZSBjb21tYW5kDQo+IElORk8gUkVGQ0FS
RA0KPg0KDQoNCi0tDQpWaWV3IHRoaXMgbWVzc2FnZSBpbiBjb250ZXh0OiANCmh0dHA6Ly9zcHNz
eC1kaXNjdXNzaW9uLjEwNDU2NDIubjUubmFiYmxlLmNvbS9TUFNTLURhdGFiYXNlLUNhcGFjaXR5
LXRwNTcxMzgwOXA1NzEzODg2Lmh0bWwNCg0KU2VudCBmcm9tIHRoZSBTUFNTWCBEaXNjdXNzaW9u
IG1haWxpbmcgbGlzdCBhcmNoaXZlIGF0IE5hYmJsZS5jb20uDQoNCj09PT09PT09PT09PT09PT09
PT09PQ0KVG8gbWFuYWdlIHlvdXIgc3Vic2NyaXB0aW9uIHRvIFNQU1NYLUwsIHNlbmQgYSBtZXNz
YWdlIHRvDQpMSVNUU0VSVkBMSVNUU0VSVi5VR0EuRURVIChub3QgdG8gU1BTU1gtTCksIHdpdGgg
bm8gYm9keSB0ZXh0IGV4Y2VwdCB0aGUNCmNvbW1hbmQuIFRvIGxlYXZlIHRoZSBsaXN0LCBzZW5k
IHRoZSBjb21tYW5kDQpTSUdOT0ZGIFNQU1NYLUwNCkZvciBhIGxpc3Qgb2YgY29tbWFuZHMgdG8g
bWFuYWdlIHN1YnNjcmlwdGlvbnMsIHNlbmQgdGhlIGNvbW1hbmQNCklORk8gUkVGQ0FSRA0KDQoN
Cg==
--=_alternative 0056865D87257A2C_=
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: base64

PGZvbnQgc2l6ZT0yIGZhY2U9InNhbnMtc2VyaWYiPlRoYXQgaXMgYSBkaXNwbGF5IGlzc3VlIHdp
dGggdGhlIERhdGEgRWRpdG9yLg0KJm5ic3A7SW4gc29tZSBvbGRlciB2ZXJzaW9ucyBvZiBTUFNT
L1N0YXRpc3RpY3MgKG1heWJlIHN0aWxsIHByZXNlbnQsIGJ1dA0KSSB0aGluayBpdCBpcyBnb25l
KSwgdGhlIERFIGlzIGxpbWl0ZWQgaW4gaG93IG1hbnkgcm93cyBpdCB3aWxsIGRpc3BsYXkNCmFz
IGEgbWVtb3J5IG1hbmFnZW1lbnQgaXNzdWUuICZuYnNwO0l0IGhhcyBub3RoaW5nIHRvIGRvIHdp
dGggcHJvY2Vzc2luZw0KY2FwYWJpbGl0aWVzIGluIG90aGVyIHBhcnRzIG9mIHRoZSBzeXN0ZW0u
ICZuYnNwO09idmlvdXNseSBubyBvbmUgaXMgZ29pbmcNCnRvIHBhZ2UgdGhyb3VnaCBodWdlIG51
bWJlcnMgb2Ygcm93cy4gJm5ic3A7SSBkb24ndCB0aGluayB0aGUgOTAgbWlsbGlvbg0KbnVtYmVy
IGlzIGNvcnJlY3QsIHRob3VnaC4gJm5ic3A7SSB0aGluayB0aGUgbGltaXQgd2FzIG1vcmUgbGlr
ZSA5MCwwMDAsDQpidXQgaXQgd2FzIGNvbmZpZ3VyYWJsZSAodmlydHVhbCByb3dzKS4gJm5ic3A7
V2l0aCBTZXJ2ZXIsIGl0IGlzIHBvc3NpYmxlDQp0byBzdXBwcmVzcyB0aGUgREUgYWx0b2dldGhl
ciwgd2hpY2ggaXMgYXBwcm9wcmlhdGUgZm9yIHZlcnkgbGFyZ2UgZGF0YXNldHMuPC9mb250Pg0K
PGJyPjxmb250IHNpemU9MiBmYWNlPSJzYW5zLXNlcmlmIj48YnI+DQpKb24gUGVjayAobm8gJnF1
b3Q7aCZxdW90OykgYWthIEtpbTxicj4NClNlbmlvciBTb2Z0d2FyZSBFbmdpbmVlciwgSUJNPGJy
Pg0KcGVja0B1cy5pYm0uY29tPGJyPg0KbmV3IHBob25lOiA3MjAtMzQyLTU2MjE8YnI+DQo8L2Zv
bnQ+DQo8YnI+DQo8YnI+DQo8YnI+DQo8YnI+PGZvbnQgc2l6ZT0xIGNvbG9yPSM1ZjVmNWYgZmFj
ZT0ic2Fucy1zZXJpZiI+RnJvbTogJm5ic3A7ICZuYnNwOyAmbmJzcDsNCiZuYnNwOzwvZm9udD48
Zm9udCBzaXplPTEgZmFjZT0ic2Fucy1zZXJpZiI+JnF1b3Q7TWFndWluLCBFdWdlbmUmcXVvdDsN
CiZsdDtlbWFndWluQGJ1ZmZhbG8uZWR1Jmd0OzwvZm9udD4NCjxicj48Zm9udCBzaXplPTEgY29s
b3I9IzVmNWY1ZiBmYWNlPSJzYW5zLXNlcmlmIj5UbzogJm5ic3A7ICZuYnNwOyAmbmJzcDsNCiZu
YnNwOzwvZm9udD48Zm9udCBzaXplPTEgZmFjZT0ic2Fucy1zZXJpZiI+U1BTU1gtTEBsaXN0c2Vy
di51Z2EuZWR1PC9mb250Pg0KPGJyPjxmb250IHNpemU9MSBjb2xvcj0jNWY1ZjVmIGZhY2U9InNh
bnMtc2VyaWYiPkRhdGU6ICZuYnNwOyAmbmJzcDsgJm5ic3A7DQombmJzcDs8L2ZvbnQ+PGZvbnQg
c2l6ZT0xIGZhY2U9InNhbnMtc2VyaWYiPjA2LzI5LzIwMTIgMDk6MjEgQU08L2ZvbnQ+DQo8YnI+
PGZvbnQgc2l6ZT0xIGNvbG9yPSM1ZjVmNWYgZmFjZT0ic2Fucy1zZXJpZiI+U3ViamVjdDogJm5i
c3A7ICZuYnNwOw0KJm5ic3A7ICZuYnNwOzwvZm9udD48Zm9udCBzaXplPTEgZmFjZT0ic2Fucy1z
ZXJpZiI+UmU6IFtTUFNTWC1MXQ0KU1BTUyBEYXRhYmFzZSBDYXBhY2l0eTwvZm9udD4NCjxicj48
Zm9udCBzaXplPTEgY29sb3I9IzVmNWY1ZiBmYWNlPSJzYW5zLXNlcmlmIj5TZW50IGJ5OiAmbmJz
cDsgJm5ic3A7DQombmJzcDsgJm5ic3A7PC9mb250Pjxmb250IHNpemU9MSBmYWNlPSJzYW5zLXNl
cmlmIj4mcXVvdDtTUFNTWChyKQ0KRGlzY3Vzc2lvbiZxdW90OyAmbHQ7U1BTU1gtTEBsaXN0c2Vy
di51Z2EuZWR1Jmd0OzwvZm9udD4NCjxicj4NCjxociBub3NoYWRlPg0KPGJyPg0KPGJyPg0KPGJy
Pjxmb250IHNpemU9MiBjb2xvcj0jMDA0MDgwIGZhY2U9IkNhbGlicmkiPkpvbiwgPC9mb250Pg0K
PGJyPjxmb250IHNpemU9MiBjb2xvcj0jMDA0MDgwIGZhY2U9IkNhbGlicmkiPiZuYnNwOzwvZm9u
dD4NCjxicj48Zm9udCBzaXplPTIgY29sb3I9IzAwNDA4MCBmYWNlPSJDYWxpYnJpIj5QZXJoYXBz
IHlvdSB3b3VsZCBjb21tZW50DQpvbiB0aGlzIHBsZWFzZS4gPC9mb250Pg0KPGJyPjxmb250IHNp
emU9MiBjb2xvcj0jMDA0MDgwIGZhY2U9IkNhbGlicmkiPlJlY2VudGx5IHNvbWVib2R5IGFza2Vk
IG1lDQpvZmYtbGlzdCBhYm91dCBkaXNwbGF5IHByb2JsZW1zIG9wZW5pbmcgYSA8L2ZvbnQ+PGZv
bnQgc2l6ZT0zIGZhY2U9IlRpbWVzIE5ldyBSb21hbiI+MzdHYg0KU1BTUyBmaWxlIHdpdGggOTAu
NTQ2TSByZWNvcmRzIChyb3dzKS4gJm5ic3A7VGhpcyBwZXJzb24gc2FpZCBoZSBoYWQgYQ0KcG9w
LXVwIG1lc3NhZ2UgdGhhdCBTUFNTIGNhbiDigJhvbmx54oCZIGRpc3BsYXkgOTAsNTAwLDAwMCBy
b3dzLiBBcmUgdGhlcmUNCmRpc3BsYXkgbGltaXRzIGFuZCBpZiBzbywgYXJlIHRob3NlIGxpbWl0
cyBkZXRlcm1pbmVkIGJ5IHRoZSBzcGVjaWZpY2F0aW9ucw0Kb2YgdGhlIGNvbXB1dGVyLiBXaGF0
IHNwZWNpZmljYXRpb25zIGdvIGludG8gZGV0ZXJtaW5pbmcgdGhlIGxpbWl0cyBhbmQNCmFyZSB0
aGVyZSBzZXR0aW5ncyB0aGF0IGNhbiBiZSB0d2Vha2VkIHRvIGluY3JlYXNlIHRoZSBsaW1pdHM/
PC9mb250Pg0KPGJyPjxmb250IHNpemU9MyBmYWNlPSJUaW1lcyBOZXcgUm9tYW4iPiZuYnNwOzwv
Zm9udD4NCjxicj48Zm9udCBzaXplPTIgY29sb3I9IzAwNDA4MCBmYWNlPSJDYWxpYnJpIj5UaGFu
a3MsIEdlbmUgTWFndWluPC9mb250Pg0KPGJyPjxmb250IHNpemU9MiBjb2xvcj0jMDA0MDgwIGZh
Y2U9IkNhbGlicmkiPiZuYnNwOzwvZm9udD4NCjxicj48Zm9udCBzaXplPTIgY29sb3I9IzAwNDA4
MCBmYWNlPSJDYWxpYnJpIj4mbmJzcDs8L2ZvbnQ+DQo8YnI+PGZvbnQgc2l6ZT0yIGNvbG9yPSMw
MDQwODAgZmFjZT0iQ2FsaWJyaSI+Jm5ic3A7PC9mb250Pg0KPGJyPjxmb250IHNpemU9MiBjb2xv
cj0jMDA0MDgwIGZhY2U9IkNhbGlicmkiPiZuYnNwOzwvZm9udD4NCjxicj48Zm9udCBzaXplPTIg
ZmFjZT0iVGFob21hIj48Yj5Gcm9tOjwvYj4gU1BTU1gocikgRGlzY3Vzc2lvbiBbPC9mb250Pjxh
IGhyZWY9Im1haWx0bzpTUFNTWC1MQExJU1RTRVJWLlVHQS5FRFUiPjxmb250IHNpemU9MiBmYWNl
PSJUYWhvbWEiPm1haWx0bzpTUFNTWC1MQExJU1RTRVJWLlVHQS5FRFU8L2ZvbnQ+PC9hPjxmb250
IHNpemU9MiBmYWNlPSJUYWhvbWEiPl0NCjxiPk9uIEJlaGFsZiBPZiA8L2I+Sm9uIEsgUGVjazxi
Pjxicj4NClNlbnQ6PC9iPiBGcmlkYXksIEp1bmUgMjksIDIwMTIgMTE6MDMgQU08Yj48YnI+DQpU
bzo8L2I+IFNQU1NYLUxATElTVFNFUlYuVUdBLkVEVTxiPjxicj4NClN1YmplY3Q6PC9iPiBSZTog
U1BTUyBEYXRhYmFzZSBDYXBhY2l0eTwvZm9udD4NCjxicj48Zm9udCBzaXplPTMgZmFjZT0iVGlt
ZXMgTmV3IFJvbWFuIj4mbmJzcDs8L2ZvbnQ+DQo8YnI+PGZvbnQgc2l6ZT0yIGZhY2U9IkFyaWFs
Ij5JbmZvcm1hdGlvbiBvbiBhYnNvbHV0ZSBsaW1pdHMgb24gY2FzZXMgYW5kDQp2YXJpYWJsZXMg
aW4gU3RhdGlzdGljcyBpc24ndCByZWFkaWx5IGF2YWlsYWJsZSwgYmVjYXVzZSB0aG9zZSBsaW1p
dHMgYXJlDQpmYXIgYmV5b25kIHByYWN0aWNhbCBjb25zdHJhaW50cyBpbXBvc2VkIGJ5IHRoZSBo
YXJkd2FyZSBhbmQgT1MuICZuYnNwO0lPVywNCnlvdSBjYW4gYXNzdW1lIHRoYXQgbm8gc3VjaCBs
aW1pdHMgZXhpc3Qgb24gdGhlIHBhcnQgb2YgU3RhdGlzdGljcy4gJm5ic3A7SG93ZXZlciwNCnRo
ZXJlIGFyZSBhIGZldyBwcm9jZWR1cmVzIC0gbWFpbmx5IHRpbWUgc2VyaWVzIG9yaWVudGVkLCB0
aGF0IHJlcXVpcmUNCnRoZSBkYXRhIHRvIGJlIGhlbGQgaW4gbWVtb3J5IGFuZCBhcmUgdGh1cyBs
aWtlbHkgdG8gcnVuIG91dCBvZiByZXNvdXJjZXMNCnNvb25lciB0aGFuIHRoZSBnZW5lcmFsIGNh
c2UuICZuYnNwO1NpbmNlIFN0YXRpc3RpY3MgbW9zdGx5IGRvZXMgbm90IGhvbGQNCmFsbCB0aGUg
Y2FzZXMgaW4gbWVtb3J5LCB5b3Ugd2lsbCBydW4gb3V0IG9mIHBhdGllbmNlIGJlZm9yZSB5b3Ug
cnVuIG91dA0Kb2YgbWVtb3J5LjwvZm9udD48Zm9udCBzaXplPTMgZmFjZT0iVGltZXMgTmV3IFJv
bWFuIj4gPGJyPg0KPC9mb250Pjxmb250IHNpemU9MiBmYWNlPSJBcmlhbCI+PGJyPg0KT3VyIFFB
IHRlc3RiZWQgZ29lcyB1cCB0byA2NiwwMDAgdmFyaWFibGVzIGFuZCBtb3JlIHRoYW4gNCBiaWxs
aW9uIGNhc2VzLg0KJm5ic3A7VGhhdCBpcyBhbiBhYnN1cmQgbnVtYmVyIG9mIHZhcmlhYmxlcywg
YnV0IHRoZXJlIHlvdSBhcmUuICZuYnNwO0NlcnRhaW5seSwNCmtlZXBpbmcgdGhlIG51bWJlciBv
ZiB2YXJpYWJsZXMgZG93biB0byBhIHJlYXNvbmFibGUgbnVtYmVyIHdpbGwgc3BlZWQNCnBlcmZv
cm1hbmNlLiAmbmJzcDtBbmQgSSBvZnRlbiB3b25kZXIgd2h5IHBlb3BsZSBhcmUgb2Z0ZW4gc28g
YXZlcnNlIHRvDQp0YWtpbmcgcmFuZG9tIHNhbXBsZXMgb2YgdmFzdCBkYXRhc2V0cyBleGNlcHQg
aW4gc2l0dWF0aW9ucyB3aGVyZSB0aGV5DQphcmUgc2VhcmNoaW5nIGZvciBuZWVkbGUtaW4taGF5
c3RhY2sgdmVyeSByYXJlIGV2ZW50cy48L2ZvbnQ+PGZvbnQgc2l6ZT0zIGZhY2U9IlRpbWVzIE5l
dyBSb21hbiI+DQo8YnI+DQo8L2ZvbnQ+PGZvbnQgc2l6ZT0yIGZhY2U9IkFyaWFsIj48YnI+DQpC
VFcsIEkgbGVhcm5lZCBhbiBpbnRlcmVzdGluZyBmYWN0IHJlY2VudGx5IGFib3V0IHRoZSBXYXRz
b24gc3lzdGVtIHRoYXQNCndvbiB0aGUgSmVvcGFyZHkgY29udGVzdC4gJm5ic3A7SXQgaGFkIDE1
NSB0ZXJhYnl0ZXMgb2YgcGh5c2ljYWwgbWVtb3J5Lg0KJm5ic3A7RG9uJ3QgdHJ5IHRoYXQgYXQg
aG9tZS48L2ZvbnQ+PGZvbnQgc2l6ZT0zIGZhY2U9IlRpbWVzIE5ldyBSb21hbiI+DQo8L2ZvbnQ+
PGZvbnQgc2l6ZT0yIGZhY2U9IkFyaWFsIj48YnI+DQo8YnI+DQpKb24gUGVjayAobm8gJnF1b3Q7
aCZxdW90OykgYWthIEtpbTxicj4NClNlbmlvciBTb2Z0d2FyZSBFbmdpbmVlciwgSUJNPC9mb250
Pjxmb250IHNpemU9MiBjb2xvcj1ibHVlIGZhY2U9IkFyaWFsIj48dT48YnI+DQo8L3U+PC9mb250
PjxhIGhyZWY9bWFpbHRvOnBlY2tAdXMuaWJtLmNvbT48Zm9udCBzaXplPTIgY29sb3I9Ymx1ZSBm
YWNlPSJBcmlhbCI+PHU+cGVja0B1cy5pYm0uY29tPC91PjwvZm9udD48L2E+PGZvbnQgc2l6ZT0y
IGZhY2U9IkFyaWFsIj48YnI+DQpuZXcgcGhvbmU6IDcyMC0zNDItNTYyMTwvZm9udD48Zm9udCBz
aXplPTMgZmFjZT0iVGltZXMgTmV3IFJvbWFuIj48YnI+DQo8YnI+DQo8YnI+DQo8YnI+DQo8L2Zv
bnQ+PGZvbnQgc2l6ZT0xIGNvbG9yPSM1ZjVmNWYgZmFjZT0iQXJpYWwiPjxicj4NCkZyb206ICZu
YnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOzwvZm9udD48Zm9udCBzaXplPTEgZmFjZT0iQXJpYWwi
PkRhdmlkDQpNYXJzbyAmbHQ7PC9mb250PjxhIGhyZWY9bWFpbHRvOmRhdmlkLm1hcnNvQGdtYWls
LmNvbT48Zm9udCBzaXplPTEgY29sb3I9Ymx1ZSBmYWNlPSJBcmlhbCI+PHU+ZGF2aWQubWFyc29A
Z21haWwuY29tPC91PjwvZm9udD48L2E+PGZvbnQgc2l6ZT0xIGZhY2U9IkFyaWFsIj4mZ3Q7PC9m
b250Pjxmb250IHNpemU9MyBmYWNlPSJUaW1lcyBOZXcgUm9tYW4iPg0KPC9mb250Pjxmb250IHNp
emU9MSBjb2xvcj0jNWY1ZjVmIGZhY2U9IkFyaWFsIj48YnI+DQpUbzogJm5ic3A7ICZuYnNwOyAm
bmJzcDsgJm5ic3A7PC9mb250PjxhIGhyZWY9Im1haWx0bzpTUFNTWC1MQGxpc3RzZXJ2LnVnYS5l
ZHUiPjxmb250IHNpemU9MSBjb2xvcj1ibHVlIGZhY2U9IkFyaWFsIj48dT5TUFNTWC1MQGxpc3Rz
ZXJ2LnVnYS5lZHU8L3U+PC9mb250PjwvYT48Zm9udCBzaXplPTMgZmFjZT0iVGltZXMgTmV3IFJv
bWFuIj4NCjwvZm9udD48Zm9udCBzaXplPTEgY29sb3I9IzVmNWY1ZiBmYWNlPSJBcmlhbCI+PGJy
Pg0KRGF0ZTogJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7PC9mb250Pjxmb250IHNpemU9MSBm
YWNlPSJBcmlhbCI+MDYvMjgvMjAxMg0KMDk6NTkgUE08L2ZvbnQ+PGZvbnQgc2l6ZT0zIGZhY2U9
IlRpbWVzIE5ldyBSb21hbiI+IDwvZm9udD48Zm9udCBzaXplPTEgY29sb3I9IzVmNWY1ZiBmYWNl
PSJBcmlhbCI+PGJyPg0KU3ViamVjdDogJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7PC9mb250
Pjxmb250IHNpemU9MSBmYWNlPSJBcmlhbCI+UmU6DQpbU1BTU1gtTF0gU1BTUyBEYXRhYmFzZSBD
YXBhY2l0eTwvZm9udD48Zm9udCBzaXplPTMgZmFjZT0iVGltZXMgTmV3IFJvbWFuIj4NCjwvZm9u
dD48Zm9udCBzaXplPTEgY29sb3I9IzVmNWY1ZiBmYWNlPSJBcmlhbCI+PGJyPg0KU2VudCBieTog
Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7PC9mb250Pjxmb250IHNpemU9MSBmYWNlPSJBcmlh
bCI+JnF1b3Q7U1BTU1gocikNCkRpc2N1c3Npb24mcXVvdDsgJmx0OzwvZm9udD48YSBocmVmPSJt
YWlsdG86U1BTU1gtTEBsaXN0c2Vydi51Z2EuZWR1Ij48Zm9udCBzaXplPTEgY29sb3I9Ymx1ZSBm
YWNlPSJBcmlhbCI+PHU+U1BTU1gtTEBsaXN0c2Vydi51Z2EuZWR1PC91PjwvZm9udD48L2E+PGZv
bnQgc2l6ZT0xIGZhY2U9IkFyaWFsIj4mZ3Q7PC9mb250Pjxmb250IHNpemU9MyBmYWNlPSJUaW1l
cyBOZXcgUm9tYW4iPg0KPC9mb250Pg0KPGRpdiBhbGlnbj1jZW50ZXI+DQo8YnI+DQo8aHIgbm9z
aGFkZT48L2Rpdj4NCjxicj48Zm9udCBzaXplPTMgZmFjZT0iVGltZXMgTmV3IFJvbWFuIj48YnI+
DQo8YnI+DQo8L2ZvbnQ+PGZvbnQgc2l6ZT0yIGZhY2U9IkNvdXJpZXIgTmV3Ij48YnI+DQpIaSBK
b24sPGJyPg0KUGxlYXNlICh3aGVuIHlvdSBoYXZlIGEgbW9tZW50KSByZXN0YXRlIHRoZSBhY3R1
YWwgKkFCU09MVVRFKiBtYXggY2FzZXMNClg8YnI+DQptYXggdmFycyBmb3IgYm90aCAzMiBiaXQg
YW5kIDY0IGJpdHMgbWF5YmUgZXZlbiAxMzIgYml0IHN5c3RlbXMganVzdCBmb3INCnRoZTxicj4N
CmhlbGwgb2YgaXQgJm5ic3A7KGFzc3VtaW5nIGluZmluaXRlIGRpc2sgc3BhY2UgYW5kIFJBTSku
ICZuYnNwO1dvdWxkIGxvdmUNCmEgY29yZSBkdW1wPGJyPg0Kb2YgdGhlIHRoZW9yeS48YnI+DQo8
YnI+DQpKb24gSyBQZWNrIHdyb3RlPGJyPg0KJmd0Ozxicj4NCiZndDsgMS41TSByZWNvcmRzIGlz
IG5vdCBhIGxhcmdlIGZpbGUgYnkgU1BTUyBzdGFuZGFyZHMuPGJyPg0KJmd0Ozxicj4NCiZndDsg
Sm9uIFBlY2sgKG5vICZxdW90O2gmcXVvdDspIGFrYSBLaW08YnI+DQomZ3Q7IFNlbmlvciBTb2Z0
d2FyZSBFbmdpbmVlciwgSUJNPGJyPg0KJmd0OyA8L2ZvbnQ+PGEgaHJlZj1tYWlsdG86cGVja0Au
aWJtPjxmb250IHNpemU9MiBjb2xvcj1ibHVlIGZhY2U9IkNvdXJpZXIgTmV3Ij48dT5wZWNrQC5p
Ym08L3U+PC9mb250PjwvYT48Zm9udCBzaXplPTIgZmFjZT0iQ291cmllciBOZXciPjxicj4NCiZn
dDsgbmV3IHBob25lOiA3MjAtMzQyLTU2MjE8YnI+DQomZ3Q7PGJyPg0KJmd0Ozxicj4NCiZndDs8
YnI+DQomZ3Q7PGJyPg0KJmd0OyBGcm9tOiAmbmJzcDsgYnRhZm95YSAmYW1wO2x0O2J0YWZveWFA
JmFtcDtndDs8YnI+DQomZ3Q7IFRvOiAmbmJzcDsgJm5ic3A7IDwvZm9udD48YSBocmVmPSJtYWls
dG86U1BTU1gtTEAudWdhIj48Zm9udCBzaXplPTIgY29sb3I9Ymx1ZSBmYWNlPSJDb3VyaWVyIE5l
dyI+PHU+U1BTU1gtTEAudWdhPC91PjwvZm9udD48L2E+PGZvbnQgc2l6ZT0yIGZhY2U9IkNvdXJp
ZXIgTmV3Ij48YnI+DQomZ3Q7IERhdGU6ICZuYnNwOyAwNi8yNi8yMDEyIDA4OjM5IFBNPGJyPg0K
Jmd0OyBTdWJqZWN0OiAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDtbU1BTU1gtTF0gU1BTUyBE
YXRhYmFzZSBDYXBhY2l0eTxicj4NCiZndDsgU2VudCBieTogJm5ic3A7ICZuYnNwOyAmbmJzcDsg
Jm5ic3A7JnF1b3Q7U1BTU1gocikgRGlzY3Vzc2lvbiZxdW90Ow0KJmFtcDtsdDtTUFNTWC1MQC51
Z2EmYW1wO2d0Ozxicj4NCiZndDs8YnI+DQomZ3Q7PGJyPg0KJmd0Ozxicj4NCiZndDsgSSBoYXZl
IGEgcG9wdWxhdGlvbiBvZiAxLjUgTWlsbGlvbiByZWNvcmRzIHRoYXQgSSB3YW50IHRvIHVzZSBp
biBTUFNTLjxicj4NCiZndDsgV2lsbDxicj4NCiZndDsgaXQgd29yaz8gV2hhdCBwbGF0Zm9ybSB3
aWxsIEkgbmVlZCB0byBoYW5kbGUgc29tZXRoaW5nIGxpa2UgdGhpcz8NCkkgd2lsbDxicj4NCiZn
dDsgYmU8YnI+DQomZ3Q7IHRha2luZyByYW5kb20gc2FtcGxlcyBidXQgd2lsbCBuZWVkIHRvIGdl
dCBkZXNjcmlwdGl2ZSBzdGF0aXN0aWNzDQpmcm9tIHRoZTxicj4NCiZndDsgZW50aXJlIHBvcHVs
YXRpb24uPGJyPg0KJmd0Ozxicj4NCiZndDsgLS08YnI+DQomZ3Q7IFZpZXcgdGhpcyBtZXNzYWdl
IGluIGNvbnRleHQ6PGJyPg0KJmd0OyA8L2ZvbnQ+PGEgaHJlZj0iaHR0cDovL3Nwc3N4LWRpc2N1
c3Npb24uMTA0NTY0Mi5uNS5uYWJibGUuY29tL1NQU1MtRGF0YWJhc2UtQ2FwYWNpdHktdHA1NzEz
ODA5Lmh0bWwiPjxmb250IHNpemU9MiBjb2xvcj1ibHVlIGZhY2U9IkNvdXJpZXIgTmV3Ij48dT5o
dHRwOi8vc3Bzc3gtZGlzY3Vzc2lvbi4xMDQ1NjQyLm41Lm5hYmJsZS5jb20vU1BTUy1EYXRhYmFz
ZS1DYXBhY2l0eS10cDU3MTM4MDkuaHRtbDwvdT48L2ZvbnQ+PC9hPjxmb250IHNpemU9MiBmYWNl
PSJDb3VyaWVyIE5ldyI+PGJyPg0KJmd0Ozxicj4NCiZndDsgU2VudCBmcm9tIHRoZSBTUFNTWCBE
aXNjdXNzaW9uIG1haWxpbmcgbGlzdCBhcmNoaXZlIGF0IE5hYmJsZS5jb20uPGJyPg0KJmd0Ozxi
cj4NCiZndDsgPT09PT09PT09PT09PT09PT09PT09PGJyPg0KJmd0OyBUbyBtYW5hZ2UgeW91ciBz
dWJzY3JpcHRpb24gdG8gU1BTU1gtTCwgc2VuZCBhIG1lc3NhZ2UgdG88YnI+DQomZ3Q7IDwvZm9u
dD48YSBocmVmPW1haWx0bzpMSVNUU0VSVkAuVUdBPjxmb250IHNpemU9MiBjb2xvcj1ibHVlIGZh
Y2U9IkNvdXJpZXIgTmV3Ij48dT5MSVNUU0VSVkAuVUdBPC91PjwvZm9udD48L2E+PGZvbnQgc2l6
ZT0yIGZhY2U9IkNvdXJpZXIgTmV3Ij4NCihub3QgdG8gU1BTU1gtTCksIHdpdGggbm8gYm9keSB0
ZXh0IGV4Y2VwdCB0aGU8YnI+DQomZ3Q7IGNvbW1hbmQuIFRvIGxlYXZlIHRoZSBsaXN0LCBzZW5k
IHRoZSBjb21tYW5kPGJyPg0KJmd0OyBTSUdOT0ZGIFNQU1NYLUw8YnI+DQomZ3Q7IEZvciBhIGxp
c3Qgb2YgY29tbWFuZHMgdG8gbWFuYWdlIHN1YnNjcmlwdGlvbnMsIHNlbmQgdGhlIGNvbW1hbmQ8
YnI+DQomZ3Q7IElORk8gUkVGQ0FSRDxicj4NCiZndDs8YnI+DQo8YnI+DQo8YnI+DQotLTxicj4N
ClZpZXcgdGhpcyBtZXNzYWdlIGluIGNvbnRleHQ6IDwvZm9udD48YSBocmVmPSJodHRwOi8vc3Bz
c3gtZGlzY3Vzc2lvbi4xMDQ1NjQyLm41Lm5hYmJsZS5jb20vU1BTUy1EYXRhYmFzZS1DYXBhY2l0
eS10cDU3MTM4MDlwNTcxMzg4Ni5odG1sIj48Zm9udCBzaXplPTIgY29sb3I9Ymx1ZSBmYWNlPSJD
b3VyaWVyIE5ldyI+PHU+aHR0cDovL3Nwc3N4LWRpc2N1c3Npb24uMTA0NTY0Mi5uNS5uYWJibGUu
Y29tL1NQU1MtRGF0YWJhc2UtQ2FwYWNpdHktdHA1NzEzODA5cDU3MTM4ODYuaHRtbDwvdT48L2Zv
bnQ+PC9hPjxmb250IHNpemU9MiBmYWNlPSJDb3VyaWVyIE5ldyI+PGJyPg0KU2VudCBmcm9tIHRo
ZSBTUFNTWCBEaXNjdXNzaW9uIG1haWxpbmcgbGlzdCBhcmNoaXZlIGF0IE5hYmJsZS5jb20uPGJy
Pg0KPGJyPg0KPT09PT09PT09PT09PT09PT09PT09PGJyPg0KVG8gbWFuYWdlIHlvdXIgc3Vic2Ny
aXB0aW9uIHRvIFNQU1NYLUwsIHNlbmQgYSBtZXNzYWdlIHRvPC9mb250Pjxmb250IHNpemU9MiBj
b2xvcj1ibHVlIGZhY2U9IkNvdXJpZXIgTmV3Ij48dT48YnI+DQo8L3U+PC9mb250PjxhIGhyZWY9
bWFpbHRvOkxJU1RTRVJWQExJU1RTRVJWLlVHQS5FRFU+PGZvbnQgc2l6ZT0yIGNvbG9yPWJsdWUg
ZmFjZT0iQ291cmllciBOZXciPjx1PkxJU1RTRVJWQExJU1RTRVJWLlVHQS5FRFU8L3U+PC9mb250
PjwvYT48Zm9udCBzaXplPTIgZmFjZT0iQ291cmllciBOZXciPg0KKG5vdCB0byBTUFNTWC1MKSwg
d2l0aCBubyBib2R5IHRleHQgZXhjZXB0IHRoZTxicj4NCmNvbW1hbmQuIFRvIGxlYXZlIHRoZSBs
aXN0LCBzZW5kIHRoZSBjb21tYW5kPGJyPg0KU0lHTk9GRiBTUFNTWC1MPGJyPg0KRm9yIGEgbGlz
dCBvZiBjb21tYW5kcyB0byBtYW5hZ2Ugc3Vic2NyaXB0aW9ucywgc2VuZCB0aGUgY29tbWFuZDxi
cj4NCklORk8gUkVGQ0FSRDxicj4NCjwvZm9udD4NCjxicj4NCg==
--=_alternative 0056865D87257A2C_=--

------------------------------

Date:    Fri, 29 Jun 2012 10:41:44 -0500
From:    Kyle Weeks <[hidden email]>
Subject: Re: IBM SPSS Questions

This is a multipart message in MIME format.
--=_alternative 0056376686257A2C_=
Content-Type: text/plain; charset="US-ASCII"

There is a forum about Structural Equation Modeling.  See
http://www2.gsu.edu/~mkteer/semnet.html.




From:   Jon K Peck/Chicago/IBM@IBMUS
To:     [hidden email]
Date:   06/29/2012 09:29 AM
Subject:        Re: IBM SPSS Questions
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621




From:        Eins Bernardo <[hidden email]>
To:        [hidden email]
Date:        06/29/2012 02:41 AM
Subject:        [SPSSX-L] IBM SPSS Questions
Sent by:        "SPSSX(r) Discussion" <[hidden email]>



Three questions for IBM SPSS personnel or others:

1. Any forum on modeler/clementine?
>>>The SPSS Community forums linked from the SPSS Community site (
www.ibm.com/developerworks/spssdevcentral) include a Modeler forum.  There
are also some LinkedIn forums that cover Modeler.

2. Do you have matrix showing the comparison of capabilities/features of
AMOS across versions?
>>>I am not aware of such an item, but you might find this information in
a What's New section in the AMOS help.
3. Any forum on AMOS?

Thank you.
Eins



--=_alternative 0056376686257A2C_=
Content-Type: text/html; charset="US-ASCII"

<font size=2 face="sans-serif">There is a forum about Structural Equation
Modeling. &nbsp;See </font><a href=http://www2.gsu.edu/~mkteer/semnet.html><font size=2 face="sans-serif">http://www2.gsu.edu/~mkteer/semnet.html</font></a><font size=2 face="sans-serif">.
&nbsp;<br>
</font>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">Jon K Peck/Chicago/IBM@IBMUS</font>
<br><font size=1 color=#5f5f5f face="sans-serif">To: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">[hidden email]</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">06/29/2012 09:29 AM</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject: &nbsp; &nbsp;
&nbsp; &nbsp;</font><font size=1 face="sans-serif">Re: IBM SPSS
Questions</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Sent by: &nbsp; &nbsp;
&nbsp; &nbsp;</font><font size=1 face="sans-serif">&quot;SPSSX(r)
Discussion&quot; &lt;[hidden email]&gt;</font>
<br>
<hr noshade>
<br>
<br>
<br><font size=2 face="sans-serif"><br>
Jon Peck (no &quot;h&quot;) aka Kim<br>
Senior Software Engineer, IBM<br>
[hidden email]<br>
new phone: 720-342-5621</font><font size=3><br>
<br>
<br>
<br>
</font><font size=1 color=#5f5f5f face="sans-serif"><br>
From: &nbsp; &nbsp; &nbsp; &nbsp;</font><font size=1 face="sans-serif">Eins
Bernardo &lt;[hidden email]&gt;</font><font size=3> </font><font size=1 color=#5f5f5f face="sans-serif"><br>
To: &nbsp; &nbsp; &nbsp; &nbsp;</font><font size=1 face="sans-serif">[hidden email]</font><font size=3>
</font><font size=1 color=#5f5f5f face="sans-serif"><br>
Date: &nbsp; &nbsp; &nbsp; &nbsp;</font><font size=1 face="sans-serif">06/29/2012
02:41 AM</font><font size=3> </font><font size=1 color=#5f5f5f face="sans-serif"><br>
Subject: &nbsp; &nbsp; &nbsp; &nbsp;</font><font size=1 face="sans-serif">[SPSSX-L]
IBM SPSS Questions</font><font size=3> </font><font size=1 color=#5f5f5f face="sans-serif"><br>
Sent by: &nbsp; &nbsp; &nbsp; &nbsp;</font><font size=1 face="sans-serif">&quot;SPSSX(r)
Discussion&quot; &lt;[hidden email]&gt;</font><font size=3> <br>
</font>
<hr noshade><font size=3><br>
<br>
</font><font size=3 face="Roman"><br>
Three questions for IBM SPSS personnel or others:</font><font size=3> <br>
</font><font size=3 face="Times New Roman"><br>
1. Any forum on modeler/clementine?</font><font size=3> </font><font size=3 face="Times New Roman"><br>
&gt;&gt;&gt;The SPSS Community forums linked from the SPSS Community site
(</font><a href=www.ibm.com/developerworks/spssdevcentral><font size=3 color=blue face="Times New Roman"><u>www.ibm.com/developerworks/spssdevcentral</u></font></a><font size=3 face="Times New Roman">)
include a Modeler forum. &nbsp;There are also some LinkedIn forums that
cover Modeler.</font><font size=3> <br>
</font><font size=3 face="Times New Roman"><br>
2. Do you have matrix showing the comparison of capabilities/features of
AMOS across versions?</font><font size=3> </font><font size=3 face="Times New Roman"><br>
&gt;&gt;&gt;I am not aware of such an item, but you might find this information
in a What's New section in the AMOS help.</font><font size=3> </font><font size=3 face="Times New Roman"><br>
3. Any forum on AMOS?</font><font size=3> <br>
</font><font size=3 face="Times New Roman"><br>
Thank you.</font><font size=3> </font><font size=3 face="Times New Roman"><br>
Eins</font><font size=3> </font><font size=3 face="Times New Roman"><br>
</font><font size=3><br>
</font>
<br>
--=_alternative 0056376686257A2C_=--

------------------------------

Date:    Fri, 29 Jun 2012 08:56:37 -0700
From:    David Marso <[hidden email]>
Subject: Re: Converting Fortran to SPSS

FWIW:  I located Blossom software :
http://www.fort.usgs.gov/Products/Software/blossom/
where would one find a link for the source code?

Dates, Brian wrote

>
> Bruce,
>
> Thanks. Yes, I have copies, and it's somewhat helpful, but the blocking
> factor changes the way that all of the cumulants are calculated.  The
> Fortran code I have is from the Blossom software.  I think between the
> two, I can get through it.  I was looking for a time-saver, something
> like the "R for SPSS and SAS Users" document.  I'm very rusty on
> Fortran.  I really appreciate the suggestion.  When I'm finished I'll
> let the list know, or contact Raynald to see if he wants to post it, in
> case anyone is interested in the macro.
>
> Brian
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@.UGA] On Behalf Of
> Bruce Weaver
> Sent: Friday, June 29, 2012 9:16 AM
> To: SPSSX-L@.UGA
> Subject: Re: Converting Fortran to SPSS
>
> Have you come across Li Cai's MRPP macro?
>
>   http://lcai.bol.ucla.edu/mrpp.txt
>   http://lcai.bol.ucla.edu/programs.html
>   http://lcai.bol.ucla.edu/mrpp.pdf
>
> HTH.
>
>
>
> Dates, Brian wrote
>>
>> Thanks for the responses.  The task is the skewness of a Pearson Type
>> III distribution for Multiresponse Randomized Block Permutation
>> Procedures (MRBP), so definitely 'long and boring'.  I'll just tough
> it
>> out with the formulae I have and try to figure out the Fortran for
> some
>> assistance. Thanks again.
>>
>> Brian
>>
>>
>>
>>
>>
>> -----Original Message-----
>> From: SPSSX(r) Discussion [mailto:SPSSX-L@.UGA] On Behalf Of
>> David Marso
>> Sent: Thursday, June 28, 2012 10:26 PM
>> To: SPSSX-L@.UGA
>> Subject: Re: Converting Fortran to SPSS
>>
>> I know you would never think that I would think what would result
> should
>> be a
>> 'line by line' but a first mental pass would be and 10 lines of
> FORTRAN
>> would likely end up as a CSUM, MSUM... 50 might be CALL EIGEN...10
>> SWEEP....
>> etc (MATRIX doesn't have all that many built in linear algebra
> functions
>> per
>> se)
>> Depending upon the level of internal documentation, actual supporting
>> math
>> equations etc it could be a few spins of the Ouija board and a few
> spent
>> black candles before a blaring epiphany crafts an algorithm.
>> Of course one must also consider that MATRIX doesn't *directly*
> support
>> subroutines. OTOH I have clever ways around that.
>> In summary I agree 'translate the code to algorithms, and program the
>> algorithms.'
>> OTOH I want to add screw the code!  What is the original
> algorithm/math
>> and
>> code directly for the jugular!
>>
>>
>> Rich Ulrich-2 wrote
>>>
>>> I haven't used Fortran since they still spelled it FORTRAN -
>>> the vector operators are probably transparent; but I
>>> wonder how people use assignment of pointers.  - So, the
>>> version of Fortran might be relevant.
>>>
>>> Since the Matrix language has matrix operators, I suggest
>>> that line-by-line is an awkward way to translate old, primitive
>>> Fortran, the stuff that looks mainly like Basis.  Is that what
>>> it is?  Instead, translate the code to algorithms, and program
>>> the algorithms.
>>>
>>> --
>>> Rich Ulrich
>>>
>>>> Date: Thu, 28 Jun 2012 15:10:33 -0700
>>>> From: david.marso@
>>>> Subject: Re: Converting Fortran to SPSS
>>>> To: SPSSX-L@.UGA
>>>>
>>>> What does it do?
>>>> How long is the code?
>>>> Are there verifiable test 'data' to confirm whatever might result?
>>>> ---
>>>> No such guide exists to my knowledge.  Pretty much would need to
>> convert
>>>> line by line.
>>>> If it is short and sweet, does something interesting and has
>> verifiable
>>>> confirmation post it here and I'd be happy to look at it and post
>>>> suggestions (probably short of actually writing the code).
>>>> If it is long and boring I'd consider doing it for a reasonable
>>>> consulting
>>>> fee.
>>>> I haven't looked at FORTRAN in over 20 years but it's like writing a
>>>> tricycle.
>>>>
>>>>
>>>> Dates, Brian wrote
>>>> >
>>>> > I have a task on which I'm working in matrix mode in SPSS.  The
>> only
>>>> > solution that's available in publication regarding this task is
>> written
>>>> > in Fortran, with which I'm woefully inadequate.  Does a guide
> exist
>>>> > which assists in the conversion of Fortran code to SPSS syntax,
>> similar
>>>> > to the guides that are available comparing SPSS to SAS or R?
>> Thanks.
>>>> >
>>>> >
>>> ...
>>>
>>
>>
>> --
>> View this message in context:
>>
> http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS
>> -tp5713876p5713883.html
>> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to
>> LISTSERV@.UGA (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
>> LISTSERV@.UGA (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
>>
>
>
> -----
> --
> Bruce Weaver
> bweaver@
> http://sites.google.com/a/lakeheadu.ca/bweaver/
>
> "When all else fails, RTFM."
>
> NOTE: My Hotmail account is not monitored regularly.
> To send me an e-mail, please use the address shown above.
>
> --
> View this message in context:
> http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS
> -tp5713876p5713891.html
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> LISTSERV@.UGA (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
> LISTSERV@.UGA (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
>


--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS-tp5713876p5713903.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

------------------------------

Date:    Fri, 29 Jun 2012 09:14:23 -0700
From:    Robert Jones <[hidden email]>
Subject: Re: Spss Syntax select all values in a variable?

Alternately, you could use frequencies for the mean and suppress "display
frequency tables".  For a string field, you will just get the N and count of
missing values, while for a numeric you will get the mean but that only
occupies one line of the report.
Robert

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Spss-Syntax-select-all-values-in-a-variable-tp5713897p5713906.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

------------------------------

Date:    Fri, 29 Jun 2012 12:51:02 -0400
From:    "Dates, Brian" <[hidden email]>
Subject: Re: Converting Fortran to SPSS

David,

The source of this information is John Pezzullo's website of free
statistical software: http://statpages.org/javasta2.html . In the first
section on the left, the next to last entry is titled Statistical
Software by Paul W. Mielke Jr. The address for the software is
http://www.stat.colostate.edu/~mielke/permute.html (so you can skip
going to Johns' site). On the webpage, I used the dos/win link.  MRBP is
in the resulting PRGMS2 folder.

Brian

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
David Marso
Sent: Friday, June 29, 2012 11:57 AM
To: [hidden email]
Subject: Re: Converting Fortran to SPSS

FWIW:  I located Blossom software :
http://www.fort.usgs.gov/Products/Software/blossom/
where would one find a link for the source code?

Dates, Brian wrote
>
> Bruce,
>
> Thanks. Yes, I have copies, and it's somewhat helpful, but the
blocking
> factor changes the way that all of the cumulants are calculated.  The
> Fortran code I have is from the Blossom software.  I think between the
> two, I can get through it.  I was looking for a time-saver, something
> like the "R for SPSS and SAS Users" document.  I'm very rusty on
> Fortran.  I really appreciate the suggestion.  When I'm finished I'll
> let the list know, or contact Raynald to see if he wants to post it,
in

> case anyone is interested in the macro.
>
> Brian
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@.UGA] On Behalf Of
> Bruce Weaver
> Sent: Friday, June 29, 2012 9:16 AM
> To: SPSSX-L@.UGA
> Subject: Re: Converting Fortran to SPSS
>
> Have you come across Li Cai's MRPP macro?
>
>   http://lcai.bol.ucla.edu/mrpp.txt
>   http://lcai.bol.ucla.edu/programs.html
>   http://lcai.bol.ucla.edu/mrpp.pdf
>
> HTH.
>
>
>
> Dates, Brian wrote
>>
>> Thanks for the responses.  The task is the skewness of a Pearson Type
>> III distribution for Multiresponse Randomized Block Permutation
>> Procedures (MRBP), so definitely 'long and boring'.  I'll just tough
> it
>> out with the formulae I have and try to figure out the Fortran for
> some
>> assistance. Thanks again.
>>
>> Brian
>>
>>
>>
>>
>>
>> -----Original Message-----
>> From: SPSSX(r) Discussion [mailto:SPSSX-L@.UGA] On Behalf Of
>> David Marso
>> Sent: Thursday, June 28, 2012 10:26 PM
>> To: SPSSX-L@.UGA
>> Subject: Re: Converting Fortran to SPSS
>>
>> I know you would never think that I would think what would result
> should
>> be a
>> 'line by line' but a first mental pass would be and 10 lines of
> FORTRAN
>> would likely end up as a CSUM, MSUM... 50 might be CALL EIGEN...10
>> SWEEP....
>> etc (MATRIX doesn't have all that many built in linear algebra
> functions
>> per
>> se)
>> Depending upon the level of internal documentation, actual supporting
>> math
>> equations etc it could be a few spins of the Ouija board and a few
> spent
>> black candles before a blaring epiphany crafts an algorithm.
>> Of course one must also consider that MATRIX doesn't *directly*
> support
>> subroutines. OTOH I have clever ways around that.
>> In summary I agree 'translate the code to algorithms, and program the
>> algorithms.'
>> OTOH I want to add screw the code!  What is the original
> algorithm/math
>> and
>> code directly for the jugular!
>>
>>
>> Rich Ulrich-2 wrote
>>>
>>> I haven't used Fortran since they still spelled it FORTRAN -
>>> the vector operators are probably transparent; but I
>>> wonder how people use assignment of pointers.  - So, the
>>> version of Fortran might be relevant.
>>>
>>> Since the Matrix language has matrix operators, I suggest
>>> that line-by-line is an awkward way to translate old, primitive
>>> Fortran, the stuff that looks mainly like Basis.  Is that what
>>> it is?  Instead, translate the code to algorithms, and program
>>> the algorithms.
>>>
>>> --
>>> Rich Ulrich
>>>
>>>> Date: Thu, 28 Jun 2012 15:10:33 -0700
>>>> From: david.marso@
>>>> Subject: Re: Converting Fortran to SPSS
>>>> To: SPSSX-L@.UGA
>>>>
>>>> What does it do?
>>>> How long is the code?
>>>> Are there verifiable test 'data' to confirm whatever might result?
>>>> ---
>>>> No such guide exists to my knowledge.  Pretty much would need to
>> convert
>>>> line by line.
>>>> If it is short and sweet, does something interesting and has
>> verifiable
>>>> confirmation post it here and I'd be happy to look at it and post
>>>> suggestions (probably short of actually writing the code).
>>>> If it is long and boring I'd consider doing it for a reasonable
>>>> consulting
>>>> fee.
>>>> I haven't looked at FORTRAN in over 20 years but it's like writing
a

>>>> tricycle.
>>>>
>>>>
>>>> Dates, Brian wrote
>>>> >
>>>> > I have a task on which I'm working in matrix mode in SPSS.  The
>> only
>>>> > solution that's available in publication regarding this task is
>> written
>>>> > in Fortran, with which I'm woefully inadequate.  Does a guide
> exist
>>>> > which assists in the conversion of Fortran code to SPSS syntax,
>> similar
>>>> > to the guides that are available comparing SPSS to SAS or R?
>> Thanks.
>>>> >
>>>> >
>>> ...
>>>
>>
>>
>> --
>> View this message in context:
>>
>
http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS

>> -tp5713876p5713883.html
>> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to
>> LISTSERV@.UGA (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
>> LISTSERV@.UGA (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
>>
>
>
> -----
> --
> Bruce Weaver
> bweaver@
> http://sites.google.com/a/lakeheadu.ca/bweaver/
>
> "When all else fails, RTFM."
>
> NOTE: My Hotmail account is not monitored regularly.
> To send me an e-mail, please use the address shown above.
>
> --
> View this message in context:
>
http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS

> -tp5713876p5713891.html
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> LISTSERV@.UGA (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
> LISTSERV@.UGA (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
>


--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS
-tp5713876p5713903.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

------------------------------

Date:    Fri, 29 Jun 2012 10:42:35 -0700
From:    David Marso <[hidden email]>
Subject: Re: Spss Syntax select all values in a variable?

As Jon said AGGREGATE...
HOWEVER!!!
Violating the generally acceptable social convention of
"If you can't say anything good don't say anything at all".

I am NOT sure what 'problem' such a tool is intended/likely to solve or it's
'real' world applicability.
Is there ANY good/necessary reason that values must be consecutive?
How is it that the hypothetical 36,37 should be removed from the list of
245?  Seems to violate basic principles of data integrity, ability to track
from data origins to final deliverable(s).
----
What happens when/if you *EVER* need to merge multiple files which have
*NOT* been processed IDENTICALLY by this 'tool'.
What happens if/when multiple users hammer on the same file at the same
time?
What do you tell your client when many of the numbers they thought they had
DON'T agree?
Short of going BACK to the original source files and tracking down many tiny
annoying discrepancies such reconciliation is likely to be hopeless/futile.
Usually data is best left alone/as is/unmolested  and/or 'corrected' prior
to importation into SPSS.
Basically in a nutshell,  Such a tool permitted to run wild in any group
setting or on data of any sort of complexity (relational tables, multiple
data waves) without a precise audit trail and backup techniques promises to
create MANY more problems than it is likely to solve.
Sorry for the overall negative tone of this missive but this is one of those
potential '... where angels fear to tread' situations and you may not have
thought through the possible terrible implications.
I have a RULE:  If I can't recreate a deliverable from start to finish from
raw data sources with syntax I have failed to create a
reproducible/verifiable piece of work and have dropped the ball.

I think I will now STFU and return to our previously scheduled programming.



Tom1234 wrote

>
> Is there any way in syntax(or otherwise) to select (and count) the number
> of values in a variable?
> I understand that VALUE LABELS is to assign them, but how would I select
> already existing values/Value labels?
>
> The reason being is:
> I'm trying to write a script in SAX/WinWrap basic that allows me to
> auto-code the value labels of variables in three ways:
> 1 - Via input box: User is prompted to enter variable and then a loop
> selects the next available value and prompts the user to enter a value
> label for each value that hasn't got a label already.
> 2 - By directly copying: User is prompted to enter variable and then a
> loop reads the value, if it is a string the script puts a upper case
> letter at the start and replaces any ^s with 's (a common error when
> exporting from cati or excel) and then displays a message box saying the
> coding is complete.
> 3 - Shift the value labels by a specified amount, user is prompted to
> enter the number (positive or negative) that they want the labels to move
> (very usefull when recoding large numbers of values) i.e. if you have 245
> values and you remove number 36 and 37 from the list, you'd have to redo
> the value labels of every value after 35 so that they were 2 places closer
> if you wanted consecutive values.
>
> Here's part of my proto/pseudo code:
>
>


--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Spss-Syntax-select-all-values-in-a-variable-tp5713897p5713909.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

------------------------------

Date:    Fri, 29 Jun 2012 11:03:50 -0700
From:    David Marso <[hidden email]>
Subject: Re: Converting Fortran to SPSS

Thanks Brian,
I downloaded the source and scanned through it without going blond.
All in all it looks fairly straightforward with a single caveat.
The *entire* bloody thing uses 3 dimensional arrays.
SPSS MATRIX only understands 2 dimensions so you will need to carefully
redesign it and decide how best to factor out the additional dimension.  One
can easily map 2 dimensional array to one dimension and indeed 3->2 or 3-> 1
but I guarantee such an approach will impact performance.

1 2
3 4
5 6
--> 1 2 3 4 5 6
(i-1)*NJ + j
(NJ=2 in this case -number of columns).

--HTH--

Dates, Brian wrote

>
> David,
>
> The source of this information is John Pezzullo's website of free
> statistical software: http://statpages.org/javasta2.html . In the first
> section on the left, the next to last entry is titled Statistical
> Software by Paul W. Mielke Jr. The address for the software is
> http://www.stat.colostate.edu/~mielke/permute.html (so you can skip
> going to Johns' site). On the webpage, I used the dos/win link.  MRBP is
> in the resulting PRGMS2 folder.
>
> Brian
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@.UGA] On Behalf Of
> David Marso
> Sent: Friday, June 29, 2012 11:57 AM
> To: SPSSX-L@.UGA
> Subject: Re: Converting Fortran to SPSS
>
> FWIW:  I located Blossom software :
> http://www.fort.usgs.gov/Products/Software/blossom/
> where would one find a link for the source code?
>
> Dates, Brian wrote
>>
>> Bruce,
>>
>> Thanks. Yes, I have copies, and it's somewhat helpful, but the
> blocking
>> factor changes the way that all of the cumulants are calculated.  The
>> Fortran code I have is from the Blossom software.  I think between the
>> two, I can get through it.  I was looking for a time-saver, something
>> like the "R for SPSS and SAS Users" document.  I'm very rusty on
>> Fortran.  I really appreciate the suggestion.  When I'm finished I'll
>> let the list know, or contact Raynald to see if he wants to post it,
> in
>> case anyone is interested in the macro.
>>
>> Brian
>>
>> -----Original Message-----
>> From: SPSSX(r) Discussion [mailto:SPSSX-L@.UGA] On Behalf Of
>> Bruce Weaver
>> Sent: Friday, June 29, 2012 9:16 AM
>> To: SPSSX-L@.UGA
>> Subject: Re: Converting Fortran to SPSS
>>
>> Have you come across Li Cai's MRPP macro?
>>
>>   http://lcai.bol.ucla.edu/mrpp.txt
>>   http://lcai.bol.ucla.edu/programs.html
>>   http://lcai.bol.ucla.edu/mrpp.pdf
>>
>> HTH.
>>
>>
>>
>> Dates, Brian wrote
>>>
>>> Thanks for the responses.  The task is the skewness of a Pearson Type
>>> III distribution for Multiresponse Randomized Block Permutation
>>> Procedures (MRBP), so definitely 'long and boring'.  I'll just tough
>> it
>>> out with the formulae I have and try to figure out the Fortran for
>> some
>>> assistance. Thanks again.
>>>
>>> Brian
>>>
>>>
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: SPSSX(r) Discussion [mailto:SPSSX-L@.UGA] On Behalf Of
>>> David Marso
>>> Sent: Thursday, June 28, 2012 10:26 PM
>>> To: SPSSX-L@.UGA
>>> Subject: Re: Converting Fortran to SPSS
>>>
>>> I know you would never think that I would think what would result
>> should
>>> be a
>>> 'line by line' but a first mental pass would be and 10 lines of
>> FORTRAN
>>> would likely end up as a CSUM, MSUM... 50 might be CALL EIGEN...10
>>> SWEEP....
>>> etc (MATRIX doesn't have all that many built in linear algebra
>> functions
>>> per
>>> se)
>>> Depending upon the level of internal documentation, actual supporting
>>> math
>>> equations etc it could be a few spins of the Ouija board and a few
>> spent
>>> black candles before a blaring epiphany crafts an algorithm.
>>> Of course one must also consider that MATRIX doesn't *directly*
>> support
>>> subroutines. OTOH I have clever ways around that.
>>> In summary I agree 'translate the code to algorithms, and program the
>>> algorithms.'
>>> OTOH I want to add screw the code!  What is the original
>> algorithm/math
>>> and
>>> code directly for the jugular!
>>>
>>>
>>> Rich Ulrich-2 wrote
>>>>
>>>> I haven't used Fortran since they still spelled it FORTRAN -
>>>> the vector operators are probably transparent; but I
>>>> wonder how people use assignment of pointers.  - So, the
>>>> version of Fortran might be relevant.
>>>>
>>>> Since the Matrix language has matrix operators, I suggest
>>>> that line-by-line is an awkward way to translate old, primitive
>>>> Fortran, the stuff that looks mainly like Basis.  Is that what
>>>> it is?  Instead, translate the code to algorithms, and program
>>>> the algorithms.
>>>>
>>>> --
>>>> Rich Ulrich
>>>>
>>>>> Date: Thu, 28 Jun 2012 15:10:33 -0700
>>>>> From: david.marso@
>>>>> Subject: Re: Converting Fortran to SPSS
>>>>> To: SPSSX-L@.UGA
>>>>>
>>>>> What does it do?
>>>>> How long is the code?
>>>>> Are there verifiable test 'data' to confirm whatever might result?
>>>>> ---
>>>>> No such guide exists to my knowledge.  Pretty much would need to
>>> convert
>>>>> line by line.
>>>>> If it is short and sweet, does something interesting and has
>>> verifiable
>>>>> confirmation post it here and I'd be happy to look at it and post
>>>>> suggestions (probably short of actually writing the code).
>>>>> If it is long and boring I'd consider doing it for a reasonable
>>>>> consulting
>>>>> fee.
>>>>> I haven't looked at FORTRAN in over 20 years but it's like writing
> a
>>>>> tricycle.
>>>>>
>>>>>
>>>>> Dates, Brian wrote
>>>>> >
>>>>> > I have a task on which I'm working in matrix mode in SPSS.  The
>>> only
>>>>> > solution that's available in publication regarding this task is
>>> written
>>>>> > in Fortran, with which I'm woefully inadequate.  Does a guide
>> exist
>>>>> > which assists in the conversion of Fortran code to SPSS syntax,
>>> similar
>>>>> > to the guides that are available comparing SPSS to SAS or R?
>>> Thanks.
>>>>> >
>>>>> >
>>>> ...
>>>>
>>>
>>>
>>> --
>>> View this message in context:
>>>
>>
> http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS
>>> -tp5713876p5713883.html
>>> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>>>
>>> =====================
>>> To manage your subscription to SPSSX-L, send a message to
>>> LISTSERV@.UGA (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
>>> LISTSERV@.UGA (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
>>>
>>
>>
>> -----
>> --
>> Bruce Weaver
>> bweaver@
>> http://sites.google.com/a/lakeheadu.ca/bweaver/
>>
>> "When all else fails, RTFM."
>>
>> NOTE: My Hotmail account is not monitored regularly.
>> To send me an e-mail, please use the address shown above.
>>
>> --
>> View this message in context:
>>
> http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS
>> -tp5713876p5713891.html
>> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to
>> LISTSERV@.UGA (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
>> LISTSERV@.UGA (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
>>
>
>
> --
> View this message in context:
> http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS
> -tp5713876p5713903.html
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> LISTSERV@.UGA (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
> LISTSERV@.UGA (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
>


--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS-tp5713876p5713910.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

------------------------------

Date:    Fri, 29 Jun 2012 14:06:32 -0400
From:    Art Kendall <[hidden email]>
Subject: Re: Spss Syntax select all values in a variable?

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix"><font size="+1">Amen!<br>
        And unless you can do that you cannot pass a quality assurance
        review.<br>
        Long time list members know that one of my soapboxes is that QA
        review should be built into the very first intros to SPSS.<br>
        (In accounting "referencing" is standard practice. That is
        accounting's terminology for QA review.)<br>
        <br>
        Also without a full audit trail you cannot go back and do it
        right.<br>
      </font>
      <pre class="moz-signature" cols="72">Art Kendall
Social Research Consultants</pre>
      On 6/29/2012 1:42 PM, David Marso wrote:<br>
    </div>
    <blockquote cite="mid:[hidden email]"
      type="cite">
      <pre wrap="">I have a RULE:  If I can't recreate a deliverable from start to finish from
raw data sources with syntax I have failed to create a
reproducible/verifiable piece of work and have dropped the ball.</pre>
    </blockquote>
    <br>
    <br>
  </body>
</html>

------------------------------

Date:    Fri, 29 Jun 2012 14:17:59 -0400
From:    "Dates, Brian" <[hidden email]>
Subject: Re: Converting Fortran to SPSS

David,

You're welcome...and thank-you!!!  I'll be more specific next time. I
appreciate all the time you've spent on this.  Take care and have a nice
weekend.

Brian

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
David Marso
Sent: Friday, June 29, 2012 2:04 PM
To: [hidden email]
Subject: Re: Converting Fortran to SPSS

Thanks Brian,
I downloaded the source and scanned through it without going blond.
All in all it looks fairly straightforward with a single caveat.
The *entire* bloody thing uses 3 dimensional arrays.
SPSS MATRIX only understands 2 dimensions so you will need to carefully
redesign it and decide how best to factor out the additional dimension.
One
can easily map 2 dimensional array to one dimension and indeed 3->2 or
3-> 1
but I guarantee such an approach will impact performance.

1 2
3 4
5 6
--> 1 2 3 4 5 6
(i-1)*NJ + j
(NJ=2 in this case -number of columns).

--HTH--

Dates, Brian wrote
>
> David,
>
> The source of this information is John Pezzullo's website of free
> statistical software: http://statpages.org/javasta2.html . In the
first
> section on the left, the next to last entry is titled Statistical
> Software by Paul W. Mielke Jr. The address for the software is
> http://www.stat.colostate.edu/~mielke/permute.html (so you can skip
> going to Johns' site). On the webpage, I used the dos/win link.  MRBP
is

> in the resulting PRGMS2 folder.
>
> Brian
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@.UGA] On Behalf Of
> David Marso
> Sent: Friday, June 29, 2012 11:57 AM
> To: SPSSX-L@.UGA
> Subject: Re: Converting Fortran to SPSS
>
> FWIW:  I located Blossom software :
> http://www.fort.usgs.gov/Products/Software/blossom/
> where would one find a link for the source code?
>
> Dates, Brian wrote
>>
>> Bruce,
>>
>> Thanks. Yes, I have copies, and it's somewhat helpful, but the
> blocking
>> factor changes the way that all of the cumulants are calculated.  The
>> Fortran code I have is from the Blossom software.  I think between
the

>> two, I can get through it.  I was looking for a time-saver, something
>> like the "R for SPSS and SAS Users" document.  I'm very rusty on
>> Fortran.  I really appreciate the suggestion.  When I'm finished I'll
>> let the list know, or contact Raynald to see if he wants to post it,
> in
>> case anyone is interested in the macro.
>>
>> Brian
>>
>> -----Original Message-----
>> From: SPSSX(r) Discussion [mailto:SPSSX-L@.UGA] On Behalf Of
>> Bruce Weaver
>> Sent: Friday, June 29, 2012 9:16 AM
>> To: SPSSX-L@.UGA
>> Subject: Re: Converting Fortran to SPSS
>>
>> Have you come across Li Cai's MRPP macro?
>>
>>   http://lcai.bol.ucla.edu/mrpp.txt
>>   http://lcai.bol.ucla.edu/programs.html
>>   http://lcai.bol.ucla.edu/mrpp.pdf
>>
>> HTH.
>>
>>
>>
>> Dates, Brian wrote
>>>
>>> Thanks for the responses.  The task is the skewness of a Pearson
Type

>>> III distribution for Multiresponse Randomized Block Permutation
>>> Procedures (MRBP), so definitely 'long and boring'.  I'll just tough
>> it
>>> out with the formulae I have and try to figure out the Fortran for
>> some
>>> assistance. Thanks again.
>>>
>>> Brian
>>>
>>>
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: SPSSX(r) Discussion [mailto:SPSSX-L@.UGA] On Behalf Of
>>> David Marso
>>> Sent: Thursday, June 28, 2012 10:26 PM
>>> To: SPSSX-L@.UGA
>>> Subject: Re: Converting Fortran to SPSS
>>>
>>> I know you would never think that I would think what would result
>> should
>>> be a
>>> 'line by line' but a first mental pass would be and 10 lines of
>> FORTRAN
>>> would likely end up as a CSUM, MSUM... 50 might be CALL EIGEN...10
>>> SWEEP....
>>> etc (MATRIX doesn't have all that many built in linear algebra
>> functions
>>> per
>>> se)
>>> Depending upon the level of internal documentation, actual
supporting
>>> math
>>> equations etc it could be a few spins of the Ouija board and a few
>> spent
>>> black candles before a blaring epiphany crafts an algorithm.
>>> Of course one must also consider that MATRIX doesn't *directly*
>> support
>>> subroutines. OTOH I have clever ways around that.
>>> In summary I agree 'translate the code to algorithms, and program
the

>>> algorithms.'
>>> OTOH I want to add screw the code!  What is the original
>> algorithm/math
>>> and
>>> code directly for the jugular!
>>>
>>>
>>> Rich Ulrich-2 wrote
>>>>
>>>> I haven't used Fortran since they still spelled it FORTRAN -
>>>> the vector operators are probably transparent; but I
>>>> wonder how people use assignment of pointers.  - So, the
>>>> version of Fortran might be relevant.
>>>>
>>>> Since the Matrix language has matrix operators, I suggest
>>>> that line-by-line is an awkward way to translate old, primitive
>>>> Fortran, the stuff that looks mainly like Basis.  Is that what
>>>> it is?  Instead, translate the code to algorithms, and program
>>>> the algorithms.
>>>>
>>>> --
>>>> Rich Ulrich
>>>>
>>>>> Date: Thu, 28 Jun 2012 15:10:33 -0700
>>>>> From: david.marso@
>>>>> Subject: Re: Converting Fortran to SPSS
>>>>> To: SPSSX-L@.UGA
>>>>>
>>>>> What does it do?
>>>>> How long is the code?
>>>>> Are there verifiable test 'data' to confirm whatever might result?
>>>>> ---
>>>>> No such guide exists to my knowledge.  Pretty much would need to
>>> convert
>>>>> line by line.
>>>>> If it is short and sweet, does something interesting and has
>>> verifiable
>>>>> confirmation post it here and I'd be happy to look at it and post
>>>>> suggestions (probably short of actually writing the code).
>>>>> If it is long and boring I'd consider doing it for a reasonable
>>>>> consulting
>>>>> fee.
>>>>> I haven't looked at FORTRAN in over 20 years but it's like writing
> a
>>>>> tricycle.
>>>>>
>>>>>
>>>>> Dates, Brian wrote
>>>>> >
>>>>> > I have a task on which I'm working in matrix mode in SPSS.  The
>>> only
>>>>> > solution that's available in publication regarding this task is
>>> written
>>>>> > in Fortran, with which I'm woefully inadequate.  Does a guide
>> exist
>>>>> > which assists in the conversion of Fortran code to SPSS syntax,
>>> similar
>>>>> > to the guides that are available comparing SPSS to SAS or R?
>>> Thanks.
>>>>> >
>>>>> >
>>>> ...
>>>>
>>>
>>>
>>> --
>>> View this message in context:
>>>
>>
>
http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS

>>> -tp5713876p5713883.html
>>> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>>>
>>> =====================
>>> To manage your subscription to SPSSX-L, send a message to
>>> LISTSERV@.UGA (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
>>> LISTSERV@.UGA (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
>>>
>>
>>
>> -----
>> --
>> Bruce Weaver
>> bweaver@
>> http://sites.google.com/a/lakeheadu.ca/bweaver/
>>
>> "When all else fails, RTFM."
>>
>> NOTE: My Hotmail account is not monitored regularly.
>> To send me an e-mail, please use the address shown above.
>>
>> --
>> View this message in context:
>>
>
http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS

>> -tp5713876p5713891.html
>> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to
>> LISTSERV@.UGA (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
>> LISTSERV@.UGA (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
>>
>
>
> --
> View this message in context:
>
http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS

> -tp5713876p5713903.html
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> LISTSERV@.UGA (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
> LISTSERV@.UGA (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
>


--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Converting-Fortran-to-SPSS
-tp5713876p5713910.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

------------------------------

Date:    Fri, 29 Jun 2012 14:33:44 -0400
From:    Art Kendall <[hidden email]>
Subject: Re: Spss Syntax select all values in a variable?

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix"><font size="+1">If I understand
        correctly #3 can be done something like this, assuming that a
        value exists with the desired label.<br>
        note that variables are not written over.<br>
        <br>
        data list list/x (f2).<br>
        begin data<br>
        1<br>
        2<br>
        3<br>
        4<br>
        5<br>
        6<br>
        7<br>
        8<br>
        9<br>
        10<br>
        11<br>
        end data.<br>
        numeric y(f2).<br>
        value labels x y<br>
        1 'abc'<br>
        2 'ABC'<br>
        3 'Abc'<br>
        4 'def'<br>
        5 'DEF'<br>
        6 'DeF'<br>
        7 'dEF'<br>
        8 'GHI'<br>
        9 'ghi'<br>
        10 'Ghi'<br>
        11 'ghI'.<br>
        *recode to the value for all caps.<br>
        recode x (1 thru 3=2)(4 thru 7=5)(8 thru 11=8) into y.<br>
        execute.<br>
        autorecode variables=y /into z.<br>
        frequencies variables = x y z.<br>
        <br>
      </font>
      <pre class="moz-signature" cols="72">Art Kendall
Social Research Consultants</pre>
      On 6/29/2012 10:52 AM, Tom1234 wrote:<br>
    </div>
    <blockquote cite="mid:[hidden email]"
      type="cite">
      <pre wrap="">Is there any way in syntax(or otherwise) to select (and count) the number of
values in a variable?
I understand that VALUE LABELS is to assign them, but how would I select
already existing values/Value labels?

The reason being is:
I'm trying to write a script in SAX/WinWrap basic that allows me to
auto-code the value labels of variables in three ways:
1 - Via input box: User is prompted to enter variable and then a loop
selects the next available value and prompts the user to enter a value label
for each value that hasn't got a label already.
2 - By directly copying: User is prompted to enter variable and then a loop
reads the value, if it is a string the script puts a upper case letter at
the start and replaces any ^s with 's (a common error when exporting from
cati or excel) and then displays a message box saying the coding is
complete.
3 - Shift the value labels by a specified amount, user is prompted to enter
the number (positive or negative) that they want the labels to move (very
usefull when recoding large numbers of values) i.e. if you have 245 values
and you remove number 36 and 37 from the list, you'd have to redo the value
labels of every value after 35 so that they were 2 places closer if you
wanted consecutive values.

Here's part of my proto/pseudo code:


-----

"Lo there do I see my father. Lo there do I see my mother and my sisters and my brothers. Lo there do I see the line of my people, back to the beginning. Lo, they do call to me, they bid me take my place among them, in the Halls of Valhalla, where the brave may live...forever."
--
View this message in context: <a class="moz-txt-link-freetext" href="http://spssx-discussion.1045642.n5.nabble.com/Spss-Syntax-select-all-values-in-a-variable-tp5713897.html">http://spssx-discussion.1045642.n5.nabble.com/Spss-Syntax-select-all-values-in-a-variable-tp5713897.html</a>
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
<a class="moz-txt-link-abbreviated" href="mailto:[hidden email]">[hidden email]</a> (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

</pre>
    </blockquote>
    <br>
    <br>
  </body>
</html>

------------------------------

Date:    Fri, 29 Jun 2012 12:14:29 -0700
From:    David Marso <[hidden email]>
Subject: Re: Spss Syntax select all values in a variable?

Brings back one terrible memory from the late 90's (when I was a Sr
Consultant at SPSS in Chicago).
Urgent call from back east to Chicago from HUGE marketing research client
(MRC) who will remain nameless suggesting possible unspecified (bugs)
terrible showstopping problems with SPSS.
Flew out the same night got picked up by MRC limo and crashed in a hotel.
Arrived 8:00 AM next day ready to rock and roll...
Well, their HUGE client was unable to reconcile their reports with MRC's
reports...
I sat down with their 'analyst' and was appalled to witness her process.
She was MANUALLY copying/pasting HUGE blocks of crap from Excel into her
master SPSS data file and repeatedly saving over the same copy.  WOW!!! WTF
am I supposed to do for these people?
Well,  I tried to describe some fundamentals such as the UPDATE command but
all I got were those scary deer in the headlights zombie stare... *BRAINS* I
want BRAINS!!!
Later that day I had to go with them to an URGENT client meeting where the
goal was to explain the numerous glaring discrepancies in a 500 page report.
Being the diplomatic, restrained person I am I tried to say as little as
possible during that uncomfortable session faintly murmuring something about
'I only saw this for the first time this AM and am attempting to develop
some theories about the problem but that will take some time,.... hence I
can provide no conclusive suggestions or certifiable remedy at present blah
blah blah...snooze (GET ME OUT OF HERE!!!).
Flew home that night with a giant headache.
Next day MRC's 'analyst's' manager called something like 6 times wanting an
explanation of what the problem had been and if we had determined any
workaround.
WOW!!!  Response(s): There is NO problem with the software, there is a
problem with your analyst.
Is there anything that can be done?
1.  Sure, fly me out again and I'll train your analyst how to properly
manage data and hopefully wean her of MANY terrible habits and potentially
catastrophic practices.
2.  Fire the doofus and hire a reasonably competent person to do the job.
3.  Prepare to lose more clients if this is your process.
They went with option 1.



Art Kendall wrote

>
> Amen!
>         And unless you can do that you cannot pass a quality assurance
>         review.
>         Long time list members know that one of my soapboxes is that QA
>         review should be built into the very first intros to SPSS.
>         (In accounting "referencing" is standard practice. That is
>         accounting's terminology for QA review.)
>
>         Also without a full audit trail you cannot go back and do it
>         right.
>
>       Art Kendall
> Social Research Consultants
>       On 6/29/2012 1:42 PM, David Marso wrote:
>
>
>       I have a RULE:  If I can't recreate a deliverable from start to
> finish from
> raw data sources with syntax I have failed to create a
> reproducible/verifiable piece of work and have dropped the ball.
>
>
>
>
>
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> LISTSERV@.UGA (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
>


--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Spss-Syntax-select-all-values-in-a-variable-tp5713897p5713914.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

------------------------------

Date:    Sat, 30 Jun 2012 01:59:43 +0530
From:    Rajeshms <[hidden email]>
Subject: Importing excel

--0015173febeeef9b2204c3a24ea3
Content-Type: text/plain; charset=ISO-8859-1

Hi all,

I am facing problem while importing excel sheet data. Lets say for example,
In excel we have labels and other unwanted names and texts , so while
importing we have to clean the excel sheet and make ready to get it
imported into spss.Is there any option so that I can over come this time
consuming procedure.

thanking you for comments,

--
Rajesh M S

--0015173febeeef9b2204c3a24ea3
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi all,<div><br></div><div>I am facing problem while importing excel sheet =
data. Lets say for example, In excel we have labels and other unwanted name=
s and texts , so while importing we have to clean the excel sheet and make =
ready to get it imported into spss.Is there any option so that I can over c=
ome this time consuming procedure.</div>
<div><br></div><div>thanking you for comments,</div><div><div><br></div>-- =
<br><div><font color=3D"#666666" size=3D"1" face=3D"comic sans ms,sans-seri=
f"><span></span><span></span>Rajesh M S</font></div><div><font color=3D"#66=
6666" size=3D"1" face=3D"comic sans ms,sans-serif"><br>
</font></div><div><font color=3D"#666666" face=3D"&#39;comic sans ms&#39;, =
sans-serif" size=3D"1"><br></font></div><br>
</div>

--0015173febeeef9b2204c3a24ea3--

------------------------------

Date:    Fri, 29 Jun 2012 13:36:26 -0700
From:    "J. R. Carroll" <[hidden email]>
Subject: Re: Importing excel

--e89a8ff253aef5f19304c3a266c6
Content-Type: text/plain; charset=ISO-8859-1

I'm going to pull a David M and say:

Don't screw up your Excel?

=P

Then I'm going to pull a Justin (me) and say:

Excel is great for exporting out in csv or some other delimited format, I
always default to Python as a knee-jerk solution because I work a lot with
it and feel comfortable work in it - I know there exists Syntax solutions
for parsing - but Python could delete unwanted data and save the resulting
data to a flat file for easy importing into SPSS.  The script would take
~20 min to write (and that includes watching TV in the background), and
would take about 2 sec to run (depending on the size of your datafile).
 It's another step, but if the Excel file is being pulled from a database
with garbage in it that you dont want (or someone is preparing it for you
and cannot deliver it in the format you want) this would be a easy solution
and save you time.

-J

----


J. R. Carroll
Cell:  (650) 776-6613
Email: [hidden email]
          [hidden email]
          [hidden email]
          [hidden email]




On Fri, Jun 29, 2012 at 1:29 PM, Rajeshms <[hidden email]> wrote:

> Hi all,
>
> I am facing problem while importing excel sheet data. Lets say for
> example, In excel we have labels and other unwanted names and texts , so
> while importing we have to clean the excel sheet and make ready to get it
> imported into spss.Is there any option so that I can over come this time
> consuming procedure.
>
> thanking you for comments,
>
> --
> Rajesh M S
>
>
>
>

--e89a8ff253aef5f19304c3a266c6
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I&#39;m going to pull a David M and say:<div><br></div><div>Don&#39;t screw=
 up your Excel?=A0</div><div><br></div><div>=3DP</div><div><br></div><div>T=
hen I&#39;m going to pull a Justin (me) and say:</div><div><br></div><div>E=
xcel is great for exporting out in csv or some other delimited format, I al=
ways default to Python as a knee-jerk solution because I work a lot with it=
 and feel comfortable work in it - I know there exists Syntax solutions for=
 parsing - but Python could delete unwanted data and save the resulting dat=
a to a flat file for easy importing into SPSS. =A0The script would take ~20=
 min to write (and that includes watching TV in the background), and would =
take about 2 sec to run (depending on the size of your datafile). =A0It&#39=
;s another step, but if the Excel file is being pulled from a database with=
 garbage in it that you dont want (or someone is preparing it for you and c=
annot deliver it in the format you want) this would be a easy solution and =
save you time. =A0</div>
<div><br></div><div>-J</div><div><br clear=3D"all">----<br>
<img src=3D"http://jrcresearch.net/blog/wp-content/uploads/2010/07/sig.gif"=
 width=3D"200" height=3D"67"><br clear=3D"all"><br>
J. R. Carroll<div>
<div>Cell:=A0 (650) 776-6613</div>
<div>Email: <a href=3D"mailto:[hidden email]" target=3D"_blank">=
[hidden email]</a></div>
<div>=A0=A0 =A0 =A0 =A0 =A0<a href=3D"mailto:[hidden email]" target=
=3D"_blank">[hidden email]</a></div>
<div>=A0=A0 =A0 =A0 =A0 =A0<a href=3D"mailto:[hidden email]" target=3D"=
_blank">[hidden email]</a></div></div><div>=A0 =A0 =A0 =A0 =A0 <a href=
=3D"mailto:[hidden email]" target=3D"_blank">jcarroll@comirates=
ting.com</a></div><div><br>
</div><br>
<br><br><div class=3D"gmail_quote">On Fri, Jun 29, 2012 at 1:29 PM, Rajeshm=
s <span dir=3D"ltr">&lt;<a href=3D"mailto:[hidden email]" target=3D"=
_blank">[hidden email]</a>&gt;</span> wrote:<br><blockquote class=3D=
"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding=
-left:1ex">
Hi all,<div><br></div><div>I am facing problem while importing excel sheet =
data. Lets say for example, In excel we have labels and other unwanted name=
s and texts , so while importing we have to clean the excel sheet and make =
ready to get it imported into spss.Is there any option so that I can over c=
ome this time consuming procedure.</div>

<div><br></div><div>thanking you for comments,</div><span class=3D"HOEnZb">=
<font color=3D"#888888"><div><div><br></div>-- <br><div><font color=3D"#666=
666" size=3D"1" face=3D"comic sans ms,sans-serif"><span></span><span></span=
>Rajesh M S</font></div>
<div><font color=3D"#666666" size=3D"1" face=3D"comic sans ms,sans-serif"><=
br>
</font></div><div><font color=3D"#666666" face=3D"&#39;comic sans ms&#39;, =
sans-serif" size=3D"1"><br></font></div><br>
</div>
</font></span></blockquote></div><br></div>

--e89a8ff253aef5f19304c3a266c6--

------------------------------

Date:    Fri, 29 Jun 2012 09:43:07 -0700
From:    titopuente <[hidden email]>
Subject: Re: Offset in GEE means contrasts?

Ryan,

Thanks for running a test to verify that it works properly.

I have solved my problem. My original data are in Excel, where I did my log
transformations. I used "lg()" to transform the data, mistakenly thinking
that this returned the natural log (which is "ln()") when the "lg()" code
actually returns the log 10 in Excel. As I imagine most of you are already
aware, for the offset to work it must be the natural log of the independent
variable used as the offset (in this case area sampled to give me #
individuals/square kilometer).

Thanks again to everyone who read my post and especially to those who
replied.

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Offset-in-GEE-means-contrasts-tp5713799p5713907.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

------------------------------

Date:    Fri, 29 Jun 2012 12:49:45 -0400
From:    J Paul Grayson <[hidden email]>
Subject: Tree analysis failure

--_21ad33c8-c751-4062-bb63-029bf04275aa_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Hi=2C

I have SPSS installed on a Mac.  With the exception of 'tree
analysis'=2C functions I have tried work.  With the tree analysis=2C I'm to=
ld that
the program is running but it freezes and I must force quit the program.
I've tired several data files with the same effect.

What I would like to do if find out if this is a problem common to the Mac.
If so=2C my next steps are obvious.

Thanks=20

Professor J. Paul Grayson=2C

Department of Sociology=2C

York University=2C

4700 Keele St.=2C

Toronto=2C

Ontario=2C

Canada=2C

M3J 1P3.
                                          =

--_21ad33c8-c751-4062-bb63-029bf04275aa_
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:Tahoma
}
--></style></head>
<body class=3D'hmmessage'><div dir=3D'ltr'>
<pre>Hi=2C<br><br>I have SPSS installed on a Mac.  With the exception of 't=
ree<br>analysis'=2C functions I have tried work.  With the tree analysis=2C=
 I'm told that<br>the program is running but it freezes and I must force qu=
it the program.<br>I've tired several data files with the same effect.<br><=
br>What I would like to do if find out if this is a problem common to the M=
ac.<br>If so=2C my next steps are obvious.<br><br>Thanks <br id=3D"ecxFontB=
reak"></pre><br><br>Professor J. Paul Grayson=2C<br>
Department of Sociology=2C<br>
York University=2C<br>
4700 Keele St.=2C<br>
Toronto=2C<br>
Ontario=2C<br>
Canada=2C<br>
M3J 1P3.<br>                                      </div></body>
</html>=

--_21ad33c8-c751-4062-bb63-029bf04275aa_--

------------------------------

Date:    Fri, 29 Jun 2012 14:38:40 -0700
From:    David Marso <[hidden email]>
Subject: Re: Importing excel

I believe you need to be more specific re what it actually looks like before
and what it should look like later.  What does it look like if you don't
clean up the excel and read it straight up.
Might be somewhere between VERY easy (or a royal PIA) to clean it afterwards
within SPSS dependent upon the actual structure of the file.

Rajeshms wrote

>
> Hi all,
>
> I am facing problem while importing excel sheet data. Lets say for
> example,
> In excel we have labels and other unwanted names and texts , so while
> importing we have to clean the excel sheet and make ready to get it
> imported into spss.Is there any option so that I can over come this time
> consuming procedure.
>
> thanking you for comments,
>
> --
> Rajesh M S
>


--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Importing-excel-tp5713915p5713918.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

------------------------------

Date:    Fri, 29 Jun 2012 21:47:05 -0400
From:    R B <[hidden email]>
Subject: Re: Offset in GEE means contrasts?

--90e6ba5bb8ebf42ac204c3a6bdec
Content-Type: text/plain; charset=ISO-8859-1

As general guideline, one should first estimate the coefficient of
ln(offset); that is, you should enter ln(offset) as a covariate first. If
the coefficient of ln(offset) is near 1.0 (taking into account the standard
error) AND it makes intuitive sense to treat it as an offset, then it is
probably safe to treat it as such. Put another way, by fixing the
coefficient to 1.0, you are assuming that the response is directly
proportional to the offset (McCullagh & Nelder, 1989).

Ryan

REFERENCE: McCullagh, P. and Nelder, J. A. (1989). Generalized Linear
Models. London: Chapman and Hall.

On Fri, Jun 29, 2012 at 12:43 PM, titopuente <[hidden email]> wrote:
>
> Ryan,
>
> Thanks for running a test to verify that it works properly.
>
> I have solved my problem. My original data are in Excel, where I did my
log
> transformations. I used "lg()" to transform the data, mistakenly thinking
> that this returned the natural log (which is "ln()") when the "lg()" code
> actually returns the log 10 in Excel. As I imagine most of you are already
> aware, for the offset to work it must be the natural log of the
independent
> variable used as the offset (in this case area sampled to give me #
> individuals/square kilometer).
>
> Thanks again to everyone who read my post and especially to those who
> replied.
>
> --
> View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Offset-in-GEE-means-contrasts-tp5713799p5713907.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

--90e6ba5bb8ebf42ac204c3a6bdec
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>As=A0general guideline, one=A0should first estimate the coefficient of=
 ln(offset); that is, you should enter ln(offset) as a covariate first. If =
the coefficient of ln(offset) is=A0near 1.0 (taking into account the standa=
rd error) AND it makes intuitive sense to treat it as an offset, then it is=
 probably safe to treat it as such. Put another way, by=A0fixing the coeffi=
cient to 1.0, you are assuming=A0that the=A0response=A0is directly proporti=
onal to the offset (McCullagh &amp; Nelder, 1989).</div>
<div>=A0</div><div>Ryan</div><div>=A0</div><div>REFERENCE: McCullagh, P. an=
d Nelder, J. A. (1989). Generalized Linear Models. London: Chapman and Hall=
.</div><div>=A0</div><div>On Fri, Jun 29, 2012 at 12:43 PM, titopuente &lt;=
<a href=3D"mailto:[hidden email]">[hidden email]</a>&gt; wrote:</div>
<div>&gt;</div><div>&gt; Ryan,</div><div>&gt;</div><div>&gt; Thanks for run=
ning a test to verify that it works properly.</div><div>&gt;</div><div>&gt;=
 I have solved my problem. My original data are in Excel, where I did my lo=
g</div>
<div>&gt; transformations. I used &quot;lg()&quot; to transform the data, m=
istakenly thinking</div><div>&gt; that this returned the natural log (which=
 is &quot;ln()&quot;) when the &quot;lg()&quot; code</div><div>&gt; actuall=
y returns the log 10 in Excel. As I imagine most of you are already</div>
<div>&gt; aware, for the offset to work it must be the natural log of the i=
ndependent</div><div>&gt; variable used as the offset (in this case area sa=
mpled to give me #</div><div>&gt; individuals/square kilometer).</div><div>
&gt;</div><div>&gt; Thanks again to everyone who read my post and especiall=
y to those who</div><div>&gt; replied.</div><div>&gt;</div><div>&gt; --</di=
v><div>&gt; View this message in context: <a href=3D"http://spssx-discussio=
n.1045642.n5.nabble.com/Offset-in-GEE-means-contrasts-tp5713799p5713907.htm=
l">http://spssx-discussion.1045642.n5.nabble.com/Offset-in-GEE-means-contra=
sts-tp5713799p5713907.html</a></div>
<div>&gt; Sent from the SPSSX Discussion mailing list archive at Nabble.com=
.</div><div>&gt;</div><div>&gt; =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D</div><div>&gt; To manage your subscription to SPSSX-L=
, send a message to</div><div>&gt; <a href=3D"mailto:[hidden email].=
EDU">[hidden email]</a> (not to SPSSX-L), with no body text exce=
pt the</div>
<div>&gt; command. To leave the list, send the command</div><div>&gt; SIGNO=
FF SPSSX-L</div><div>&gt; For a list of commands to manage subscriptions, s=
end the command</div><div>&gt; INFO REFCARD</div><div>=A0</div><div>=A0</di=
v>

--90e6ba5bb8ebf42ac204c3a6bdec--

------------------------------

End of SPSSX-L Digest - 28 Jun 2012 to 29 Jun 2012 (#2012-180)
**************************************************************

=====================
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