DATA Step, Macro, Functions and more

Error with %include statement with password file

Reply
Occasional Contributor
Posts: 10

Error with %include statement with password file

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 !

Super User
Posts: 6,542

Re: Error with %include statement with password file

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

 

Add them and that should take care of the problem.

Occasional Contributor
Posts: 10

Re: Error with %include statement with password file

Posted in reply to Astounding

Thank you very much @Astounding ! Much appreciated. 

Ask a Question
Discussion stats
  • 2 replies
  • 99 views
  • 2 likes
  • 2 in conversation