DATA Step, Macro, Functions and more

Global/Environment Variable that can be set by Management Console

Reply
SAS Employee
Posts: 10

Global/Environment Variable that can be set by Management Console

A BI/GRID deployment with a different environment for (DEV, QA and PROD). Each environment has it's own Teradata database. The problem I'm trying to overcome is the when doing explicit sql pass-through in EG 5.1 the database name is not inserted. So we have to manually insert the name as an option in the sql definition. This means we have to re-code every program and recreated the stored processes as we move from environment to environment.

What I want to do is have a golbal/environment variable that I can control within the MC and then use that in the EG/SQL code

Ask a Question
Discussion stats
  • 0 replies
  • 125 views
  • 0 likes
  • 1 in conversation