topic how to copy spde file from on path1 to another path in SAS Enterprise Guide

how to copy spde file from on path1 to another path

alepage — Thu, 15 May 2025 18:08:12 GMT

One way to copy a dataset from let's say path1 to path2 is to use the libname and data statement as below

%let path1= something;
%let path2=something else;
%let fname=be_auto_prmjun2024;

libname source spde  "&path1.";
libname dest     spde  "&path2";

data dest.&fname.;
set source.&fname;
run;

if we have many files, we coud use a filelist and a call execute and repeat the above script

What will be the unix command that we could use to copy spde file containing only the string prm (stand for premium) from many subfolders to other subfolders and of course only spde file.

Please provide the good unix command

Please p

Re: how to copy spde file from on path1 to another path

Tom — Thu, 15 May 2025 18:54:12 GMT

Did you try PROC COPY?

Re: how to copy spde file from on path1 to another path

alepage — Thu, 15 May 2025 19:08:44 GMT

I have many folders such as

sas2000

sas2001

...

sas2025

and in each sas????, I have other subfolder

What I would like to do is to copy only the premium dataset containg the string _prm

Is it possible to do that with proc copy

Re: how to copy spde file from on path1 to another path

Tom — Thu, 15 May 2025 22:46:20 GMT

@alepage wrote:

I have many folders such as

sas2000

sas2001

...

sas2025

and in each sas????, I have other subfolder

What I would like to do is to copy only the premium dataset containg the string _prm

Is it possible to do that with proc copy

If you only want to copy some of the datasets use the SELECT statement. Let SAS worry about what files are used by which dataset.

proc copy inlib=in outlib=out;
  select premium ;
run;

Re: how to copy spde file from on path1 to another path

LinusH — Fri, 16 May 2025 11:03:20 GMT

You cannot copy/move SPDE data using OS tools.

This is because the directory path is coded into the table metadata.

See answers above for ways of copying within SAS: