SORT CASES with Other Procedures (SORT CASES command)

  • In AGGREGATE, cases are sorted in order of the break variable or variables. You do not have to use SORT CASES prior to running AGGREGATE, because the procedure does its own sorting.
  • You can use SORT CASES in conjunction with the BY keyword in ADD FILES to interleave cases with the same variables but from different files.
  • With MATCH FILES, cases must be sorted in the same order for all files that you combine.
  • With UPDATE, cases must be sorted in ascending order of the key variable or variables in both the primary file and all transaction files.
  • You can use the PRINT command to check the results of a SORT CASES command. To be executed, PRINT must be followed by a procedure or EXECUTE.