Menu: Found in the DATA menu
Use the Sort command to sort the current table in ascending or descending order based on specified key fields. Sort creates a new file that has been physically reorganized. Sort works on both fixed-length and variable-length data files.
Note: The Sort command cannot be used within a Group command in a procedure.
To change the folder location for local temporary sort files use the Set Sort command. For more information see Set Sort.
Analyzer offers the ability to automatically invoke a 64 Bit Sort which may significantly enhance sort speeds. The requirements for automatically invoking the 64 Bit Sorting are:
• | using a 64 Bit Version of Windows |
• | having at least 16 GB of RAM installed |
If unable to use 64 Bit Sorting, Analyzer will revert to 32 Bit Sorting.
Maximum performance benefits will occur when working with large files (over 1 GB) on machines with at least 16 GB of RAM – otherwise the sorting performance will be equivalent to 32 Bit Sorting.