[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: OUTPUT Command in SPSS
From: |
Ben Pfaff |
Subject: |
Re: OUTPUT Command in SPSS |
Date: |
Wed, 21 Jul 2010 13:07:54 -0700 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/23.2 (gnu/linux) |
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
- Re: OUTPUT Command in SPSS, (continued)
- Re: OUTPUT Command in SPSS, Ben Pfaff, 2010/07/14
- Re: OUTPUT Command in SPSS, subhasree, 2010/07/14
- Re: OUTPUT Command in SPSS, Ben Pfaff, 2010/07/15
- Re: OUTPUT Command in SPSS, subhasree, 2010/07/15
- Re: OUTPUT Command in SPSS, Ben Pfaff, 2010/07/15
- Re: OUTPUT Command in SPSS, subhasree, 2010/07/15
- Re: OUTPUT Command in SPSS, Ben Pfaff, 2010/07/16
- Re: OUTPUT Command in SPSS, subhasree, 2010/07/19
- Re: OUTPUT Command in SPSS, Ben Pfaff, 2010/07/19
- Message not available
- Re: OUTPUT Command in SPSS, Ben Pfaff, 2010/07/20
- Message not available
- Re: OUTPUT Command in SPSS,
Ben Pfaff <=
- Message not available
- Re: OUTPUT Command in SPSS, Ben Pfaff, 2010/07/22