topic Re: How to use a proc datasets move statement but with a password in SAS Enterprise Guide

How to use a proc datasets move statement but with a password

alepage — Tue, 06 Jan 2026 21:16:20 GMT

/* 1. Define LIBNAMEs for your folders */

LIBNAME source spde '/Temp/Alain/OP/dim/';
LIBNAME target spde '/Temp/Alain/OP/dim/old2/';

/* 2. Use PROC DATASETS to move the dataset */

PROC DATASETS LIBRARY=source;
  COPY IN=source OUT=target MOVE;                                                                                               /* MOVE copies and deletes original */
  SELECT dim_calendrier_v1 jourouvrableprovds jourouvrablenatds jourouvrableetdprovds jourouvrableetdnatds;                     /* Specify the dataset to move */
  QUIT;
RUN;

/* 3. Verify the move (optional) */

proc contents data=source._all_ nods;
run;                                      /* Check if it's gone from source */

proc contents data=target._all_ nods;
run;                                   /* Check if it's there in target */

How to modify this script if all the tables has the same password (write=po alter=po)

Please provide a working example

Re: How to use a proc datasets move statement but with a password

SASKiwi — Tue, 06 Jan 2026 22:17:37 GMT

You need to provide the ALTER password on the MOVE option:

Here's the link to the SAS doc with the above COPY statement.

Re: How to use a proc datasets move statement but with a password

alepage — Wed, 07 Jan 2026 03:26:15 GMT

Please provide an example

Re: How to use a proc datasets move statement but with a password

SASKiwi — Wed, 07 Jan 2026 03:58:07 GMT

PROC DATASETS LIBRARY=source;
  COPY IN=source OUT=target MOVE alter = 'Mypassword';                                                                                               /* MOVE copies and deletes original */
  SELECT dim_calendrier_v1 jourouvrableprovds jourouvrablenatds jourouvrableetdprovds jourouvrableetdnatds;                     /* Specify the dataset to move */
  QUIT;
RUN;

Re: How to use a proc datasets move statement but with a password

Kurt_Bremser — Wed, 07 Jan 2026 08:34:49 GMT

Consider using the external command (mv on UNIX) to move the files. If the move happens within the same physical filesystem, mv will only move the directory entries, which is much faster.

Re: How to use a proc datasets move statement but with a password

Ksharp — Thu, 08 Jan 2026 07:32:58 GMT

Kurt,
OP used SPDE engine, that means a sas dataset is consist of several small file which extension name is .spds9 .
If using OS command to move these .spds9 file, then this sas dataset might be ruined or corrupted.