[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: OUTPUT Command in SPSS
From: |
subhasree |
Subject: |
Re: OUTPUT Command in SPSS |
Date: |
Mon, 19 Jul 2010 19:25:25 -0700 (PDT) |
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 <address@hidden> 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
> address@hidden
> 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.
- OUTPUT Command in SPSS, subhasree, 2010/07/14
- 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 <=
- 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, 2010/07/21
- Message not available
- Re: OUTPUT Command in SPSS, Ben Pfaff, 2010/07/22