SAS IRM 3.5
I am trying to utilize the extended custom mapping definition feature in my project. Basically, this method allows you to embed a macro variable in your libref declaration in libnames.txt. The macro variable value is declared in a static table which is saved in a static folder. However, all of my attempts failed. This is what I did:
In my libnames.txt, I have :
STPF=%LA/BASE/%CS/STATIC
MACHAI=%LA/%BD/%MV(STPF.MAKLUMAT3.AA)
Macrovarload.txt:
stpf.maklumat3=local
(place in my federated area)
Supposedly, "MACHAI" will be resolved to "%LA/%BD/one", as the value for macro variable "aa" in the macrovarload/static table is "one".
I have included the files needed to replicate the simple job flow which I created to test this feature.
The files consist of
- config folder
- sas folder which you paste it into your source folder
- base folder which you paste it into your landing area; contain the static table "maklumat3"
- 10102018, base folder. which contain the input for the tasks in the job flow.
- job flow file which creates and saves my job flow
https://drive.google.com/open?id=1vJAgbIpA9TqiKRY03AO8472SXdz0yOcs