Examples (ADD FILES command)

ADD FILES FILE="/data/school1.sav" 
         /FILE="/data/school2.sav".

• ADD FILES concatenates cases from the IBM® SPSS® Statistics data files school1.sav and school2.sav. All cases from school1.sav precede all cases from school2.sav in the resulting file.

  SORT CASES BY LOCATN DEPT.
  ADD FILES  FILE="/data/source.sav" /FILE=* /BY LOCATN DEPT
   /KEEP AVGHOUR AVGRAISE LOCATN DEPT SEX HOURLY RAISE /MAP.
  SAVE OUTFILE="/data/prsnnl.sav".

• SORT CASES sorts cases in the active dataset in ascending order of their values for LOCATN and DEPT.
• ADD FILES combines two files: the external IBM SPSS Statistics data file source.sav and the sorted active dataset. The file source.sav must also be sorted by LOCATN and DEPT.
• BY indicates that the keys for interleaving cases are LOCATN and DEPT, the same variables used on SORT CASES.
• KEEP specifies the variables to be retained in the resulting file.
• MAP produces a list of variables in the resulting file and the two input files.
• SAVE saves the resulting file as a new IBM SPSS Statistics data file named prsnnl.sav.