Error with %include statement with password file

renanm — Fri, 04 May 2018 20:44:07 GMT

Hello,

I'm trying to set up a password file in a folder in the server so that I don't have to reference my log-in credentials directly in the query

when connecting to Teradata.

Here's what I've done:

1) Saved a file named login.sas in a folder in the server with the following details:

%let tduser='myusername'
%let tdpass='mypassword'

2) Reference the file with a %include statement in my SAS program as follows:

%include "/intl/ipath/foldername/foldername/login.sas";

3) Run a query to connect to Teradata as follows:

Proc SQL;
Connect To teradata (server=edw user=&tduser password=&tdpass mode=teradata connection=global);
create table CUSTBASE as
select * from connection to teradata
(

select distinct....

4) I get an ERROR and a WARNING as follows:

%include "/intl/ipath/foldername/foldername/login.sas";
ERROR: Open code statement recursion detected.

28 Connect To teradata (server=edw user=&tduser password=&tdpass mode=teradata connection=global);
WARNING: Apparent symbolic reference TDPASS not resolved.
WARNING: Apparent symbolic reference TDPASS not resolved.

Any help on how to resolve this would be greatly appreciated.

Thanks !

Re: Error with %include statement with password file

Astounding — Fri, 04 May 2018 20:52:19 GMT

%LET statements (each of them) require a semicolon to end the statement.

Add them and that should take care of the problem.

Re: Error with %include statement with password file

renanm — Tue, 08 May 2018 14:46:51 GMT

Thank you very much @Astounding ! Much appreciated.

topic Re: Error with %include statement with password file in SAS Programming

Error with %include statement with password file

Re: Error with %include statement with password file

Re: Error with %include statement with password file