SAS data to NAS/SAN

[senu188]

Hi,

I have lib name defined as %MKC_SSO;libname MANIT "\\neovia.prv\sas2\tables\ManitowocKC"; . we are getting the data from sap source . i have few questions on it.

1) how we received the data through macro ( %MKC_SSO;)? please correct me .

2) once data received it will build in application server work area and transfered to NAS ?

3) how it transfered to NAS through SAS services? if yes which services?

[Kurt_Bremser]

%MKC_SSO;
/* without seeing the code of this macro, we cannot tell what it does;
its name suggests that it does something concerning Single Sign On */

libname MANIT "\\neovia.prv\sas2\tables\ManitowocKC";
/* this is a very basic libname statement, associating a logical name with a resource.
Since no specific engine is supplied, this will be a BASE libname, meaning that 
SAS expects (and will create) files with the extensions .sas7bdat, .sas7bvew,
.sas7bcat, .sas7bndx.
To SAS, this is just a directory; how the data is written to/read from there, is
handled by the operating system. Since the pathname is a UNC, the connection
will be made through TCP/IP over the network */

[senu188]

hi,

Thanks for reply.
%macro MKC_SSO;

libname MAN_B R3 ashost=neoh1p02 sysnr=00 Batch=1 trace=0 DESTGROUP=SASDEST
language=EN Client=210
user=.... password=.......
TRANSERRORCOMPATMODE=Y;

%mend MKC_SSO;

Still i want know how data is transfering from to NAS with the of SAS

[Kurt_Bremser]

So the macro

%macro MKC_SSO;

libname MAN_B R3 ashost=neoh1p02 sysnr=00 Batch=1 trace=0 DESTGROUP=SASDEST
language=EN Client=210
user=.... password=.......
TRANSERRORCOMPATMODE=Y;

%mend MKC_SSO;

contains a libname statement that points to a remote SAP R/3.

And the second libname points to a network share identified by a UNC. In both cases, the data will be moved over the network, using the TCP/IP protocol as transport. With R/3, by using a local SAP commandline client, with the UNC share, the Windows networking protocol.

To SAS, the library pointing to the network share is no different than one pointing to a local disk. Both are part of your computer's filesystem, which handles the data transfer.

[senu188]

Hi,

ok thanks . If i ask question different way may be i can get answer i want.
We have time job which i mention early and our jobs kicks off. We see data running work drive in application server and after sometimes it updates NAS drive.
so i want know how data transfers between work drive and NAS drive

[Tom · Accepted solution]

You need to show some of the code actually tries to  write to the library to get a better answer.

If your code is not explicitly writing data to the WORK library then most likely what you are seeing SAS staging the output of the data read from the SAP library to the SASUTIL location on the work disk. 

[Kurt_Bremser]

As soon as your SAS program uses a library that points to a remote physical location for reading and/or writing, the operating system (or the Database client used by SAS/ACCESS for Relational Databases) will route the accesses over the network. So if you want to know which steps use the NAS, you need to scan your program for the library name that points to the NAS.