OUTPUT CLOSE ALL.
FILE HANDLE D /NAME='E:\Doc\2013T1\51108\W8'.
DATASET CLOSE ALL.
NEW FILE. 
SET UNICODE=YES /WIDTH=255  /LENGTH=NONE. 
GET DATA /TYPE=XLS
  /FILE='D\W8.2Spss.xls'
  /SHEET=name 'Count.2Spss'
  /CELLRANGE=range 'A1:K16'
  /READNAMES=on .
EXECUTE . 
SELECT IF InUse.
EXECUTE . 
DELETE VARIABLES InUse.
EXECUTE . 
MISSING VALUES ALL (-9).
EXECUTE . 
VARIABLE WIDTH all (5).
COUNT C1=A(SYSMIS).
COUNT C2=A B(MISSING).
COUNT C3=A to J(LO thru hi).
COUNT C4=A to J (1 thru 3).
COUNT C5=A(6 thru HI).
COUNT C7=A(1 thru 4) A(1 2).
VARIABLE WIDTH all (5).
FORMATS all (f3.0).
list.

COMPUTE V1=A.
COMPUTE V2=A > 4.
COMPUTE V3=(A>4) AND (B>4).
COMPUTE V4=(A>4) OR (B>4).
COMPUTE V5=0.
IF (V2) V5=1.
COMPUTE V6=0.
IF (A>4) V6=V6+1.
IF (B>4) V6=V6+1.
IF (C>4) V6=V6+1.
IF (D>4) V6=V6+1.
IF (E>4) V6=V6+1.
COMPUTE V7=SYSMIS(A).
COMPUTE V8=MISSING(A).
COMPUTE V9=NMISS(A to E).
COMPUTE V10=SUM(A to E).
VARIABLE WIDTH all (5).
FORMATS all (f3.0).
List A to E V1 to V10.

GET DATA /TYPE=XLS
  /FILE='D\W8.2Spss.xls'
  /SHEET=name 'OneWay.2Spss'
  /CELLRANGE=range 'A1:C16'
  /READNAMES=on .
MISSING VALUES ALL (-9).
VALUE LABELS Factor 1 'זכר' 2 'גברת' 3 'דנה'.
VARIABLE LABELS Factor 'Sex A.K.A. מגדר'.
EXAMINE VARIABLES=Dep BY Factor
  /PLOT BOXPLOT
  /STATISTICS NONE
  /NOTOTAL .
ONEWAY Dep BY Factor
  /POSTHOC=TUKEY ALPHA(0.05) .
ONEWAY Dep BY Factor
  /STATISTICS DESCRIPTIVES 
  /PLOT MEANS.
ONEWAY Dep BY Factor
  /CONTRAST=-.5 -.5 1 
  /CONTRAST=0 -1 1 .
OUTPUT EXPORT  /XLS
  DOCUMENTFILE='D\W8.FromSpss.xls'
  SHEET = 'FromSpss' .