topic SAP R3 LIB Statement in SAS Enterprise Guide

SAP R3 LIB Statement

air_dedman — Wed, 06 Aug 2014 20:58:57 GMT

I have my SAP R3 info:

authdomain=

client=

language=

ashost=

sysnr=

...and obviously my usrnm and psswd, but for some reason I'm getting a connection fail, does any one know have a sample LIB statement to connect SAS EG to SAP R3?

Re: SAP R3 LIB Statement

SASKiwi — Wed, 06 Aug 2014 22:39:19 GMT

It would be helpful if you could supply your LIBNAME statement too. Also what SAS/ACCESS product are you using to connect to R3? If you are not sure use check in EG SAS Server Properties or PROC SETINIT or PROC PRODUCT_STATUS statement to confirm.

Re: SAP R3 LIB Statement

air_dedman — Thu, 07 Aug 2014 13:49:03 GMT

OK so my SAS/ACCESS types are:

---SAS/ACCESS Interface to PC Files

---SAS/ACCESS Interface to ODBC

the libname statement i think i should be using is...

libname example r3 user=Test password=pwd client=100 language=EN

ashost=host.biz.server.com sysnr=01;

-------------------------------------------------------

Error I Get, It can't find my R3 engine....

NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR

22 GOPTIONS ACCESSIBLE;

23 /*authdomain= biz.server.com

24 client= 100

25 language= EN

26 ashost= host.biz.server.com

27 sysnr= 01 */

29 libname Q31 r3 user=TEST password=XXXXXXXXXX client=100 language=EN

31 ashost=host.biz.server.com sysnr=01;

ERROR: The R3 engine cannot be found.

ERROR: Error in the LIBNAME statement.

34 GOPTIONS NOACCESSIBLE;

35 %LET _CLIENTTASKLABEL=;

36 %LET _CLIENTPROJECTPATH=;

37 %LET _CLIENTPROJECTNAME=;

38 %LET _SASPROGRAMFILE=;

40 ;*';*";*/;quit;run;

41 ODS _ALL_ CLOSE;

44 QUIT; RUN;

Re: SAP R3 LIB Statement

jakarman — Thu, 07 Aug 2014 15:19:42 GMT

No r3 sas/access license present no surprise the engine is failing SAS/ACCESS(R) 9.4 Interface to R/3: User's Guide, Second Edition

Re: SAP R3 LIB Statement

air_dedman — Thu, 07 Aug 2014 15:43:09 GMT

Thank you, I'll see what my IT department can do about enabling the correct SAS/ACCESS or at the very least setting up an ODBC. That link you sent me, doesn't explain a whole lot to me, if I were to write an ODBC LIBNAME, what would that code look like?

Thanks for the help

Re: SAP R3 LIB Statement

jakarman — Thu, 07 Aug 2014 15:56:54 GMT

This is the ODB part. It is just basic RDBMS SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Fifth Edition you won't be happy with that as all metadata objects of SAP will be missing.

It that low level access of accessing basic tables. Having the r3 interface you can hope for more information. Still Sap is a complex environment.