FROM subcommand (STAR JOIN command)

The FROM subcommand specifies the name of the case data file (fact table). It is followed by the keyword AS, followed by the alias used to identify the file source when specifying fields.

  • The FROM subcommand is required and must immediately follow the SELECT subcommand.
  • The data file name can be an external data file in IBM® SPSS® Statistics format or a dataset in the current session.
  • External data file names must be quoted.
  • An asterisk can be used to specify the currently active dataset.
  • Alias names must follow standard variable naming rules. See the topic Variable Names for more information.
  • Only one FROM subcommand is allowed.

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.