06-13-2012 03:09 AM
Forlder Path :
Now, here data/env1/new/ is the common Path , so i want to Paramterize this Path name. How do i implement it in SAS-DI.
In Informatica, We did data/env1/new/=$$PMRootDir
In SAS, How to implement ?? As we are New to SAS-DI, unable to explore much needed guidance asap....!!
06-13-2012 06:10 AM
There are tons of ways to this.
One of simplest (maybe not the best from a administrational view) is to use a macro variable.
There are as well tons of ways to assign it a value, the easiest is to set it in the appserver_autoexec_usermods.sas file in SASApp directory.
06-14-2012 10:20 AM
I am not getting,what u r trying to say.Can u elaborate more so that it is more understandable to be and i am able to implement.the solution provided
by you.Ur guidance will be more helpul for me.
06-14-2012 11:26 AM
If your not familiar with the concept of macro variables, it might be a bit shaky for you to implement this. Nevertheless, here goes:
In the appserver_autoexec_usermods.sas:
%let PMRootDir = /data/env1/new;
In the Externa Fileobject - File Location
Be sure to check the option "Double quotes around file name"