Chapter 29: The MIGRATE Procedure

Overview: MIGRATE Procedure

What Does the MIGRATE Procedure Do?

The MIGRATE procedure migrates members in a SAS data library forward to SAS 9.1. It will migrate:

• a library from SAS 6.09E (OS/390 or zOS) or SAS 6.12 (UNIX, Windows, OpenVMS Alpha) and later to SAS 9.1

• a 32-bit library to a 64-bit library within the same operating environment family

• data files including the indexes, integrity constraints, and audit trails

• generations

• data sets with deleted observations in place

• data sets retaining all attributes, such as compression, encryption, and passwords

• the SAS internal date and time of when the source library member was created and was last modified

• views, catalogs, item stores, and MDDBs.

Why Use Validation Macros with PROC MIGRATE?

The validation tools, migrate_macros.sas and migrate_template.sas, contain all the validation macros needed for the migration process. The validation macros provide an easy, automated way to document the migration of all your libraries. The validation macros are used before PROC MIGRATE to determine the expected behavior of the migration of a particular library. Then, after the migration, the validation macros are used to prove that the migration produced the expected results. For details, see Validation Macros Overview on page 598.