Re: OUTPUT Command in SPSS

[Ben Pfaff]

I still don't understand.

Here is the important part of the AGGREGATE command:
 AGGREGATE
   /BREAK=SSC7
   /SAL_SALES_mean=MEAN(SAL_SALES) 
   /SAL_SALES_base=FIRST(SAL_SALES_mean)

Suppose that our input has the following rows:

SSC7    SAL_SALES
----    ---------
   1         1000
   1         1251
   1         2000
   2          900
   2          950
   2         1750
   2         1800

The output would look like this:

SSC7    SAL_SALES_mean    SAL_SALE_base
----    --------------    -------------
   1              1417                ?
   2              1350                ?

Can you fill in the ? entries for me?

Thanks,

Ben.

"CHOWDARY SUBHASREE KOSARAJU" <address@hidden> writes:

> For example the 
> Sal_sales_mean = 4688,2456,3450
> The base average which is first(sal_sales_mean) = 1000
> -----Original Message-----
> From: Ben Pfaff [mailto:address@hidden 
> Sent: Tuesday, July 20, 2010 11:43 AM
> To: CHOWDARY SUBHASREE KOSARAJU
> Cc: address@hidden
> Subject: Re: OUTPUT Command in SPSS
>
> "CHOWDARY SUBHASREE KOSARAJU" <address@hidden> writes:
>
>> Yes in SPSS FIRST on a variable created by AGGREGATE will work.  The FIRST
>> is something similar to the MIN function in oracle.  Do we have something
>> similar in PSPP ?
>
> Can you explain what taking the FIRST of a MEAN does, with an
> example?  I would expect that, within a break group, there is
> only one mean, so the "first" over that mean is the same as the
> mean.  But I guess that cannot be the case or you would not
> express it that way.

-- 
Ben Pfaff 
http://benpfaff.org