subhasree <[email protected]> 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_ _______________________________________________ Pspp-users mailing list [email protected] http://lists.gnu.org/mailman/listinfo/pspp-users
