FILE Subcommand (ADD FILES command)

FILE identifies the files to be combined. A separate FILE subcommand must be used for each input file.

  • An asterisk may be specified on FILE to indicate the active dataset.
  • Dataset names instead of file names can be used to refer to currently open datasets.
  • The order in which files are named determines the order of cases in the resulting file.

PASSWORD Keyword

The PASSWORD keyword specifies the password required to open an encrypted IBM® SPSS® Statistics data file. The specified value must be enclosed in quotation marks and can be provided as encrypted or as plain text. Encrypted passwords are created when pasting command syntax from the Save Data As dialog. The PASSWORD keyword is ignored if the file is not encrypted.

Example

GET DATA /TYPE=XLS  /FILE='/temp/excelfile1.xls'.
DATASET NAME exceldata1.
GET DATA /TYPE=XLS  /FILE='/temp/excelfile2.xls'.
ADD FILES FILE='exceldata1' 
         /FILE=*
         /FILE='/temp/mydata.sav'.