Split File / Descriptive

[Carol Jones]

I am trying to process 304,747 record using the following syntax:

sort cases by location level account.
split file separate by location level account.
desc var = fte / stat=sum .

The file processes for a few minutes; however, it aborts.  It there a
different way to split a file and summarize a variable?

[Maguin, Eugene]

Carol,

Why not use Aggregate?

sort cases by location level account.
Aggregate outfile=* mode=replace/presorted/break=location level account/
   fte=sum(fte).

List location level account fte.


Gene Maguin

[Marks, Jim]

Does the sort complete before the abort?

What kind of error message do you get when the proceess ends?

OLAP cubes can provide a summary by break variable:

OLAP CUBES
  fte   BY location level account
  /CELLS=SUM
  /TITLE='Your report'.

Note this is a single table solution (as opposed to separate tables).

--jim

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Carol Jones
Sent: Thursday, October 19, 2006 3:39 PM
To: [hidden email]
Subject: Split File / Descriptive

I am trying to process 304,747 record using the following syntax:

sort cases by location level account.
split file separate by location level account.
desc var = fte / stat=sum .

The file processes for a few minutes; however, it aborts.  It there a
different way to split a file and summarize a variable?

[Dominic Lusinchi]

Carol,

I'm kind of guessing here but does the fact that you do not use the command
"SPLIT FILE
  OFF."
at then end of the syntax, be the problem?

Dominic Lusinchi
Statistician
Far West Research
Statistical Consulting
San Francisco, California
415-664-3032
www.farwestresearch.com

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Carol Jones
Sent: Thursday, October 19, 2006 1:39 PM
To: [hidden email]
Subject: Split File / Descriptive

I am trying to process 304,747 record using the following syntax:

sort cases by location level account.
split file separate by location level account.
desc var = fte / stat=sum .

The file processes for a few minutes; however, it aborts.  It there a
different way to split a file and summarize a variable?

[Oliver, Richard]

Use Means or Summarize or OLAP Cubes. All provide the Sum function and allow multiple grouping variables -- and they don't require that you sort the data first!

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Carol Jones
Sent: Thursday, October 19, 2006 3:39 PM
To: [hidden email]
Subject: Split File / Descriptive

I am trying to process 304,747 record using the following syntax:

sort cases by location level account.
split file separate by location level account.
desc var = fte / stat=sum .

The file processes for a few minutes; however, it aborts.  It there a different way to split a file and summarize a variable?