topic Re: SAS Office Addin rdbms issue in Microsoft Integration with SAS

SAS Office Addin rdbms issue

KMWWN156 — Wed, 13 Mar 2024 13:06:55 GMT

Hi,

I have attempted to use the SAS Addin for the first time and are receiving the following error when running code within excel. I am a very basic user and imagine the answer will also, hopefully, be very simple.

18 proc sql;
19 connect to &rdbms as biw(&dbc_info);
_ _
22 79
200 200
WARNING: Apparent symbolic reference RDBMS not resolved.
WARNING: Apparent symbolic reference DBC_INFO not resolved.
ERROR 22-322: Expecting a name.

ERROR 79-322: Expecting a ).

ERROR 200-322: The symbol is not recognized and will be ignored.

I have code set to run each time I use SAS EG 8.3 and see rdbms refers to my auto Teradata log on.

How or what do I need to do within the Addin to get this to run?

Re: SAS Office Addin rdbms issue

ballardw — Wed, 13 Mar 2024 18:45:23 GMT

Statements like this in the log:

WARNING: Apparent symbolic reference RDBMS not resolved.

mean that no value has been assigned to the macro variable RDBMS (or what ever name the warning references).

Typically either you would have a statement prior similar to

%let RDBMS= some text goes here that is used in place of the macro variable.

Or perhaps a macro parameter was left off of a call.

Note: if you place your LOG entries into a text box opened on the forum using the </> icon above the message window things like the underscore characters will appear where they should.

Re: SAS Office Addin rdbms issue

Kurt_Bremser — Wed, 13 Mar 2024 18:58:43 GMT

This is not an issue with the addin, this is an issue with your SAS code. The macro variables have to be defined before you use them.

Re: SAS Office Addin rdbms issue

KMWWN156 — Thu, 14 Mar 2024 08:36:28 GMT

Thanks all, there is some code stored within SAS EG which assigns my libraries and Macro - It appears that this needs to be run within the Addin before any code can be ran as the Addin doesn't run this automatically like EG does.