Mainframe SAS to UNIX SAS Migration

Reply
New Contributor
Posts: 3

Mainframe SAS to UNIX SAS Migration

Hi,

I am trying to access Mainframe SAS permanent dataset in UNIX and getting the below error which is attached as image file.

Followed the below procedure:

1) Ftp'ed the SAS dataset from Mainframe to below specified UNIX in binary mode

2) location /dnbusr1/kurubaa/SAStoUNIX/SICDATA/CCSV9_SIC.sas7bdat

3) Inside my SAS module defined the libname as libname SICDATA /dnbusr1/kurubaa/SAStoUNIX/SICDATA

4) when i am trying to access the dataset in the below code i am getting this error 'File SICDATA.CCSV9_SIC.DATA does not exist'.

    DATA FINAL;

    set SICDATA.CCSV9_SIC END=EOF;    

    RUN;

Please suggest some option to resolve this error. it would be really helpful.

Thanks,

Bhuvana.



error.png
Super Contributor
Posts: 282

Re: Mainframe SAS to UNIX SAS Migration

Hi,

Did you use the CPORT / CIMPORT procedure?:

Base SAS(R) 9.3 Procedures Guide, Second Edition

Base SAS(R) 9.3 Procedures Guide, Second Edition

Can you see that the library has been allocated to your session and is readable?

Can you view the data in the data set?

Regards,

Amir.

New Contributor
Posts: 3

Re: Mainframe SAS to UNIX SAS Migration

Hi Amir,

Thanks for your valuable reply. i just did a manual ftp from Mainframe as sas7bdat file and placed it in unix location.

provided that path as libname and used it. but getting error.

Thanks,

Bhuvana.


Super Contributor
Posts: 282

Re: Mainframe SAS to UNIX SAS Migration

Hi,

In that case I suggest you try the CPORT and CIMPORT procedures as documented in the links provided.

These procedures are supplied for the purpose moving SAS libraries etc between different environments.

Regards,

Amir.

New Contributor
Posts: 3

Re: Mainframe SAS to UNIX SAS Migration

Hi,

yes i could see that procedure. but dont know how to relate to my two environments

libname source 'SAS-data-library';  filename tranfile 'transport-filehost-option(s)-for-file-characteristics;
Note about code
proc cport data=source.times file=tranfile;  run;

can u please provide me the specific example

Thanks,

Bhuvana.

Super Contributor
Posts: 282

Re: Mainframe SAS to UNIX SAS Migration

Hi,

It's been a while since I've done it, but try:

1) On MVS create a transport file with the attributes specified in

Base SAS(R) 9.3 Procedures Guide, Second Edition

2) Allocate the file to your SAS session:

filename cpfile 'my-file-name';

3) CPORT the file using:

proc cport lib=mylibref                     

           file=cpfile;                    

quit;                                      

4) FTP the file to Unix in binary mode.
5) On Unix follow the instructions in the example:
Regards,
Amir.
Frequent Contributor
Posts: 118

Re: Mainframe SAS to UNIX SAS Migration


Hi Bhuvana,

Try to use SCP commands in unix to copy.

SCP - scp allows files to be copied to , from or between different hosts.

The syntax for the scp command is:

scp [options] username1@source_host:directory1/filename1 username2@destination_host:directory2/filename2

Syntax :

(1) $ scp your_username@remotehost.eduSmiley Very HappySN.sas7bdatyour_username@remotehost.eduSmiley Very HappySN.sas7bdat/some/local/directory/some/local/directory

Regards

Uma Shanker Saini

Frequent Contributor
Posts: 118

Re: Mainframe SAS to UNIX SAS Migration

Hi Bhuvana,

you can also use "TUMBLEWEED".

it is a ftp tool, which could directly put mainframe dataset to the specific path on unix or vice vers...

Regards

Uma Shanker Saini

Ask a Question
Discussion stats
  • 7 replies
  • 1037 views
  • 0 likes
  • 3 in conversation