topic Re: IBM MAINFRAME renaming a file using sas in SAS Enterprise Guide

IBM MAINFRAME renaming a file using sas

alepage — Fri, 29 Sep 2017 17:20:42 GMT

Hello,

I have a file name courriel on the ibm mainframe.

ex:

A108.TESTING.COURRIEL

I can rename this file directly from the mainframe using the command r (stand for rename) on the left margin and give this file a new name.

As I am transfering a new courriel file (updated file) from my pc to the mainframe using a SAS code, I would like to use a sas code in order to rename my mainframe file courriel to cour2017 in order to transfert a new courriel file from my pc while keeping a copy of the original file.

Is there a way to acheive that?

Regards,

Alain

Re: IBM MAINFRAME renaming a file using sas

Astounding — Fri, 29 Sep 2017 18:24:22 GMT

Assuming this command would work on the mainframe:

r "oldname" "newname"

You should be able to achieve that in a SAS program using:

%sysexec r "oldname" "newname" ;

Re: IBM MAINFRAME renaming a file using sas

LinusH — Sun, 01 Oct 2017 13:31:32 GMT

If you are using PROC UPLOAD for the file transfer you can rename it on the fly by specifying your new file name on the OUTFILE= option.

Re: IBM MAINFRAME renaming a file using sas

alepage — Tue, 03 Oct 2017 12:08:54 GMT

Hello,

It is a nice idea but as the original file on the mainframe is courriel, I need to rename this file first, let's say to cour2017 and thereafter, transfert the updated file on the mainframe server.

Regards,

Alain

Re: IBM MAINFRAME renaming a file using sas

alepage — Tue, 03 Oct 2017 12:09:30 GMT

I have try your solution but nothing appends.

Regards,

Alain

Re: IBM MAINFRAME renaming a file using sas

Tom — Tue, 03 Oct 2017 14:11:21 GMT

You didn't describe what type of Mainframe you are using. Are you running on MVS, VM/CMS? From the format of the filename it looks like MVS to me. Not sure what you mean by R before the filename, perhaps you are using some type of screen list of file names? Are you using ISPF? Does that still exist? I doubt you are using ROSCOE or WYLBER.

Anyway did you try the RENAME() function in SAS?

Here is the example from the manual. Just put in your filenames.

/*
Example 3: Renaming a Directory
The following example renames a directory in the UNIX operating environment.
*/
data _null_;
rc=rename('/local/u/testdir/', '/local/u/oldtestdir', 'file');
run;

Re: IBM MAINFRAME renaming a file using sas

bhandari9 — Thu, 14 Jun 2018 16:29:13 GMT

Did you figure out how to rename mainframe file using SAS? Please share your solution.

Thanks and best regards.

Rajesh.

Re: IBM MAINFRAME renaming a file using sas

alepage — Wed, 04 Jul 2018 19:05:35 GMT

unfortunately,

I have switch to another job and the working environment is different. I can't test myself the proposed code.

I might ask a colleague to do so.

I will let your know if it works.

Regards,

Alain.