Syntax: MIGRATE Procedure


Restriction: Data set options are not allowed.

Restriction: Only SAS 6.12 libraries and later can be migrated by the MIGRATE procedure. SAS files created before SAS 6.12 must be converted to SAS 6.12 before they can be migrated to SAS 9.1.

Restriction: PROC MIGRATE requires the source and target libraries to be different.

PROC MIGRATE IN= libref-2 OUT= libref-1 <BUFSIZE= n > <MOVE>

  • <SLIBREF= libref > <KEEPNODUPKEY>;

PROC MIGRATE Statement

PROC MIGRATE IN= libref-2 OUT= libref-1 <BUFSIZE= n > <MOVE>

  • <SLIBREF= libref > <KEEPNODUPKEY> ;

Required Arguments

IN= libref-2

  • names the source SAS data library from which to migrate members .

  • Requirement: If you are using a server, such as SAS/SHARE or SAS/CONNECT, the server must be a SAS 9.1 or later version.

OUT= libref-1

  • names the target SAS data library to contain the migrated members.

  • Requirement: If you are using a server, such as SAS/SHARE or SAS/CONNECT, the server must be a SAS 9.1 or later version.

  • Recommendation: The target SAS data library to contain the SAS 9.1 members should be an empty location that will contain only the SAS 9.1 members. If a member already exists in the target library that has the same name and member type as one in the source library, the member will not be migrated. An error message is written to the SAS log and the MIGRATE procedure will continue with the next member. Note that members in a sequential library are an exception because the MIGRATE procedure will not read the entire tape to determine existence.

Options

BUFSIZE= n nK nM nG hexX MAX

  • determines the buffer page size .

  • n nK nM nG hexX MAX

    • specifies the buffer page size of the members that are being written to the target library. n specifies the page size in multiples of 1 (bytes); 1,024 (kilobytes); 1,048,576 (megabytes); or 1,073,741,824 (gigabytes). For example, a value of 8 specifies a page size of 8 bytes, and a value of 4k specifies a page size of 4096 bytes.

    • Default: the original buffer page size used to create the source library member.

  • hex X

    • specifies the page size as a hexadecimal value. You must specify the value beginning with a number (0-9), followed by an X. For example, the value 2dx sets the page size to 45 bytes.

  • MAX

    • sets the page size to the maximum possible number in your operating environment, up to the largest four-byte, signed integer, which is 2 ,. -1, or approximately 2 billion bytes.

MOVE

  • moves SAS members from the source library to the target library and deletes the original members from the source library. Specifying MOVE reduces the scope of the validation tools. For more detailed information about using the MOVE option, see Using the MOVE Option Using the MOVE Option on page 604.

  • Restriction: The MOVE option can be used to delete a member of a SAS library only if the IN= engine that is associated with the source library supports the deletion of tables. A sequential engine does not support table deletion.

  • Recommendation: Use the MOVE option only if your system is space-constrained. It is preferable to verify the migration of the member before it is deleted.

SLIBREF= libref

  • specifies a libref that is assigned through a SAS/SHARE or SAS/CONNECT server to use for migrating catalogs with the following conditions:

    • the IN= source library is 32-bit and the OUT= target library is 64-bit

    • you must specify SLIBREF through a SAS 8 server when an OpenVMS Alpha or OpenVMS VAX source library that was created prior to SAS 9 is being migrated to a SAS 9 or later OpenVMS Alpha target library.

  • For more information on using the SLIBREF= option and SAS/SHARE or SAS/ CONNECT, see Using Remote Library Services (RLS) to Migrate Catalogs Using Remote Library Services (RLS) to Migrate your Library on page 595.

KEEPNODUPKEY

  • specifies to retain the NODUPKEY sort assertion. For more detailed information, see "Migrating a Data Set with NODUPKEY Sort Assertion" Migrating a Data Set with NODUPKEY Sort Assertion on page 594.




Base SAS 9.1.3 Procedures Guide (Vol. 1)
Base SAS 9.1 Procedures Guide, Volumes 1, 2, 3 and 4
ISBN: 1590472047
EAN: 2147483647
Year: 2004
Pages: 260

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net