Re: OUTPUT Command in SPSS

[Ben Pfaff]

subhasree <address@hidden> writes:

>  GET
>   FILE='C:\Analytic Reporting\Data\SAV_MARKET_200910_SAM_03_SSC.sav'.
> COMPUTE DUMMY=1.
> EXECUTE.
>
>
> AGGREGATE
>    /OUTFILE = DUMMY

Do you mean /OUTFILE=#DUMMY?  I am not certain what you are
trying to do here, so I'm not sure what to suggest.

>    /BREAK=DUMMY
>   /RC_LAPSED_PERIOD_mean=MEAN(RC_LAPSED_PERIOD) 
>   /FRE_VISIT_mean=MEAN(FRE_VISIT) 
>   /SAL_SALES_mean=MEAN(SAL_SALES)
>   /BAS_SALES_mean=MEAN(BAS_SALES).
>
> FILE HANDLE 
>     /NAME = ' AGG_SSC7'
>     /MODE = SCRATCH

You can omit this FILE HANDLE command.

> AGGREGATE
>   /OUTFILE='AGG_SSC7'

Just write this as /OUTFILE=#AGG_SSC7.

>   /BREAK=SSC7
>   /SAL_SALES_mean=MEAN(SAL_SALES) 
>   /SAL_SALES_base=FIRST(SAL_SALES_mean) 

This use of FIRST on a variable created by AGGREGATE won't work.
(Does it work in SPSS?)

>   /BAS_SALES_mean=MEAN(BAS_SALES) 
>   /BAS_SALES_base=FIRST(BAS_SALES_mean) 
>   /RC_LAPSED_PERIOD_mean=MEAN(RC_LAPSED_PERIOD) 
>   /RC_LAPSED_PERIOD_base=FIRST(RC_LAPSED_PERIOD_mean) 
>   /FRE_VISIT_mean=MEAN(FRE_VISIT) 
>   /FRE_VISIT_base=FIRST(FRE_VISIT_mean) 
>   /SAL_SALES_sum=SUM(SAL_SALES)
>   /N_BREAK=N.
-- 
"...dans ce pays-ci il est bon de tuer de temps en temps un amiral
 pour encourager les autres."
--Voltaire, _Candide_