Desktop productivity for business analysts and programmers

dynamic username and password while using infomap in Enterprise Guide

Reply
N/A
Posts: 0

dynamic username and password while using infomap in Enterprise Guide

can any one tell me when i create stored process of my process flow in which i have opened an infomap and created a SAS dataset and this process flow i have created a stored process.
so in the stored process a libname statement of infomap is auto generated

libname _egmle sasioime
user="&_InfoMapUser"
pw="&_InfoMapPassword"

metaport=8561
metarepository="Foundation"
mappath="/BIP Tree/ReportStudio/Maps"
PRESERVE_TAB_NAMES=YES;

so when i want to run this stored process in another server where that infomap also exists.So i want that it should take the username and password from that server infomap..
how should i go forward
Community Manager
Posts: 2,691

Re: dynamic username and password while using infomap in Enterprise Guide

What you see is that the user and password have been added as hidden parameters on the stored process. To allow different user/pw to be specified at runtime, you will need to change those parameters so that they appear as prompts, and the values are then supplied within the stored process.

It's not ideal, but the INFOMAPS engine has this limitation in SAS 9.1.3.

Chris
Ask a Question
Discussion stats
  • 1 reply
  • 92 views
  • 0 likes
  • 2 in conversation