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" <[email protected]> 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:[email protected]] > Sent: Tuesday, July 20, 2010 11:43 AM > To: CHOWDARY SUBHASREE KOSARAJU > Cc: [email protected] > Subject: Re: OUTPUT Command in SPSS > > "CHOWDARY SUBHASREE KOSARAJU" <[email protected]> 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 _______________________________________________ Pspp-users mailing list [email protected] http://lists.gnu.org/mailman/listinfo/pspp-users
