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?
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
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.
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 */
28
29 libname Q31 r3 user=TEST password=XXXXXXXXXX client=100 language=EN
30
31 ashost=host.biz.server.com sysnr=01;
ERROR: The R3 engine cannot be found.
ERROR: Error in the LIBNAME statement.
32
33
34 GOPTIONS NOACCESSIBLE;
35 %LET _CLIENTTASKLABEL=;
36 %LET _CLIENTPROJECTPATH=;
37 %LET _CLIENTPROJECTNAME=;
38 %LET _SASPROGRAMFILE=;
39
40 ;*';*";*/;quit;run;
41 ODS _ALL_ CLOSE;
42
43
44 QUIT; RUN;
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
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.