Hi, Ben,
sorry for the late reply.
Here is the code
GET
FILE='C:\Analytic Reporting\Data\SAV_MARKET_200910_SAM_03_SSC.sav'.
COMPUTE DUMMY=1.
EXECUTE.
AGGREGATE
/OUTFILE = DUMMY
/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
AGGREGATE
/OUTFILE='AGG_SSC7'
/BREAK=SSC7
/SAL_SALES_mean=MEAN(SAL_SALES)
/SAL_SALES_base=FIRST(SAL_SALES_mean)
/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.
The following is the error:
GET
GET
FILE='C:\Analytic Reporting\Data\SAV_MARKET_200910_SAM_03_SSC.sav'.
COMPUTE
COMPUTE DUMMY=1.
EXECUTE
EXECUTE.
AGGREGATE
AGGREGATE
/OUTFILE = DUMMY
/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
FILE HANDLE
/NAME = ' AGG_SSC7'
C:\Analytic Reporting\Syntax\Profiling_RFV.sps:17: error: FILE HANDLE:
Syntax error expecting identifier at `/'.
/MODE = SCRATCH
AGGREGATE
AGGREGATE
/OUTFILE='AGG_SSC7'
/BREAK=SSC7
/SAL_SALES_mean=MEAN(SAL_SALES)
/SAL_SALES_base=FIRST(SAL_SALES_mean)
C:\Analytic Reporting\Syntax\Profiling_RFV.sps:23: error: AGGREGATE:
SAL_SALES_mean is not a variable name.
/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.
could you please help. Thanks in advance.
Regards
Subhasree
Ben Pfaff wrote:
>
> subhasree <[email protected]> writes:
>
>> AGGREGATE
>>
>> /OUTFILE=* MODE=ADDVARIABLES
>>
>> C:\Analytic Reporting\Syntax\Profiling_RFV.sps:14: error: AGGREGATE:
>> Syntax error expecting BREAK at `MODE'.
>
> MODE=ADDVARIABLES isn't yet supported on AGGREGATE.
>
>> Could you please help me in this.Tried using scratch file. But could not
>> succeed.
>
> How did you try using scratch files? The syntax you showed tries
> to use DATASET commands, not scratch files.
> --
> Ben Pfaff
> http://benpfaff.org
>
> _______________________________________________
> Pspp-users mailing list
> [email protected]
> http://lists.gnu.org/mailman/listinfo/pspp-users
>
>
--
View this message in context:
http://old.nabble.com/OUTPUT-Command-in-SPSS-tp29168606p29210574.html
Sent from the Gnu - PSPP - Users mailing list archive at Nabble.com.
_______________________________________________
Pspp-users mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/pspp-users
