topic Re: fcopy with directory paths in SAS Programming

fcopy with directory paths

Taliah — Mon, 20 Mar 2023 09:06:57 GMT

Hello,

I need to copy a text file from one directory to another (in linux). I am using the following code -

filename infile "/cifs/test1/test2/test3/test.txt";

filename outfile "/cifs//test10/test20/test30/test.txt";

data _null_ ;

rc = fcopy(infile, outfile);

run;

I get rc 2004, and the file isn't copied. All help will be appreciate, Thank you.

Re: fcopy with directory paths

BrunoMueller — Mon, 20 Mar 2023 10:14:14 GMT

The arguments to the FCOPY functions are character values, so they must be quoted, see example below. I would also recommend to use the SYSMSG function to get the proper error message back that corresponds to the return code.


data msg;
  rc=fcopy("infile", "outfile");
  length msg $ 1024;
  msg=sysmsg();
  putlog _all_;
run;

Re: fcopy with directory paths

Taliah — Mon, 20 Mar 2023 11:09:47 GMT

Works great, Thank you!

Re: fcopy with directory paths

Hdababs — Wed, 30 Aug 2023 20:08:55 GMT

Greetings,

I just trued this solution:

data msg;
rc=fcopy("C:\My Documents\schedule.txt", "C:\My Documents\Reports\schedule.txt");
length msg $ 1024;
msg=sysmsg();
putlog _all_;
run;

And received this SAS EG output:

rc msg
20004 ERROR: No logical assign for filename C:\MY.

Re: fcopy with directory paths

Tom — Wed, 30 Aug 2023 20:40:45 GMT

@Hdababs wrote:

Greetings,

I just trued this solution:

data msg;
rc=fcopy("C:\My Documents\schedule.txt", "C:\My Documents\Reports\schedule.txt");
length msg $ 1024;
msg=sysmsg();
putlog _all_;
run;

And received this SAS EG output:

rc msg
20004 ERROR: No logical assign for filename C:\MY.

That cannot work because that is not what FCOPY wants as INPUT. It wants the names of the FILEREF you created with the FILENAME statement or FILENAME() function. Instead you gave it the actual path to the file. The error message is clearly saying there is no fileref named "C:\MY" (and there never could be since : and \ are not valid characters to use in a fileref).

Re: fcopy with directory paths

Hdababs — Wed, 30 Aug 2023 22:09:46 GMT

Thank you. If I understand correct, I need to declare infile and outfile variables for the directory path for the source and destination.

Re: fcopy with directory paths

Tom — Wed, 30 Aug 2023 22:43:49 GMT

@Hdababs wrote:

Thank you. If I understand correct, I need to declare infile and outfile variables for the directory path for the source and destination.

Kind of.

You need to DEFINE two filerefs. You can use INFILE and OUTFILE for them if you want (make sure you aren't already using those names for some other files that you still need to reference.). Or you can use any other valid SAS names that is 8 characters or less as the filerefs.