Re: OUTPUT Command in SPSS

[subhasree]

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.