topic Re: File Movement in SAS Programming

File Movement

aashi77 — Wed, 16 Oct 2024 11:06:28 GMT

i need the sas code to move a file from a folder to another.

Re: File Movement

yabwon — Wed, 16 Oct 2024 11:11:04 GMT

filename in "</path/for/input/file.ext>" lrecl=1 recfm=n;
filename out "</path/for/output/file.ext>" lrecl=1 recfm=n;

data _null_;
  rc = fcopy("in","out");
  rctxt=sysmsg();
  if rc then
    put rctxt;
run;

Re: File Movement

Ksharp — Thu, 17 Oct 2024 02:12:59 GMT

data _null_;
rc=rename('c:\temp\want.sas','c:\temp\a\want.sas','file');
run;

Re: File Movement

aashi77 — Mon, 21 Oct 2024 04:37:04 GMT

not working

Re: File Movement

Kurt_Bremser — Mon, 21 Oct 2024 06:01:06 GMT

"not working" on its own is a completely useless message. Describe in detail what does not work to your expectation, post the complete log of the failing step in a window opened with this button:

Re: File Movement

Ksharp — Mon, 21 Oct 2024 06:03:23 GMT

?? I tested it before,no problem.
Is your OS Linux/Unix ,not Windows?
if it is Linux you need change your path from \ into /

data _null_;
rc=rename('/usr/tmp/want.sas','/root/sas/want.sas','file');
run;

Re: File Movement

aashi77 — Mon, 21 Oct 2024 06:26:42 GMT

I am not obtaining any error, but the file is still in the same location.
The OS is windows.

Re: File Movement

Ksharp — Mon, 21 Oct 2024 06:32:56 GMT

1)You must use absolute path(d:\saspret\fit\fit1\corm.csv ) not relative path (\saspret\fit\fit1\corm.csv) .

2)you can not use general mathed character(star) with filename like 'cram*.csv' , you need to specify it with total filename 'cram_1.csv' or 'cram_2.csv'.

Re: File Movement

Kurt_Bremser — Mon, 21 Oct 2024 07:56:34 GMT

The RENAME function handles one file at a time. To move multiple files, do not use wildcard characters. Use a DATA step with DOPEN, DNUM and DREAD to obtain filenames, and use RENAME for each item you find.

Use absolute path names; in Windows, this means they must start with a drive letter.

Post code as text in a code box ("little running man"), so we can use it in examples; do not post pictures.

Re: File Movement

yabwon — Mon, 21 Oct 2024 09:00:42 GMT

To what @Ksharp and @Kurt_Bremser have already wrote, if you want to see more information about "why it didn't work?", use the following trick:

data _null_;
  rc = rename(...);
  rctxt=sysmsg();
  if rc then
    put rctxt;
run;

As a side note, if you need to get the files list but do not feel confident with the "DOPEN()"-family of functions , you can use the BasePlus SAS package and the %dirsAndFiles() macro to do the "give-me-the-list-of-files" job for you.

Bart