11-28-2013 06:11 AM
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'.
set SICDATA.CCSV9_SIC END=EOF;
Please suggest some option to resolve this error. it would be really helpful.
11-28-2013 07:35 AM
11-28-2013 07:56 AM
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.
11-28-2013 08:06 AM
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.
11-28-2013 08:15 AM
yes i could see that procedure. but dont know how to relate to my two environments
libname source 'SAS-data-library'; filename tranfile 'transport-file' host-option(s)-for-file-characteristics;
proc cport data=source.times file=tranfile; run;
can u please provide me the specific example
11-28-2013 09:07 AM
It's been a while since I've done it, but try:
1) On MVS create a transport file with the attributes specified in
2) Allocate the file to your SAS session:
filename cpfile 'my-file-name';
3) CPORT the file using:
proc cport lib=mylibref
11-28-2013 08:57 AM
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
Uma Shanker Saini
11-28-2013 09:00 AM
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...
Uma Shanker Saini