Skip to main content

Clone

Syntax​

Clone               new_database_name

Parameters​

  • new_database_name: The name for the new database to be created (e.g., 5K\FEMALE). This defines the name for the new .DTA and .FRM files.

Description​

Creates a new database by "cloning" the structure of the current one, populating it only with records that match the preceding Select commands.

Remarks​

This is used to create a new database containing a subset of the original data (e.g., only female runners). The command requires a .FRM file that describes the new database structure, which is typically a copy of the original .FRM file. The Destination command must be used to specify the name of the new data file (.DTA). Note: Cloning a database will render any existing event (results) files useless for the new database, as the internal record pointers will no longer match.

Examples​

To create a new database named FEMALE in the 5K directory containing only female runners:

Select              SEX
=                   F
Clone               5K\FEMALE
Destination         5K\FEMALE.DTA