BookmarkSubscribeRSS Feed
atsen92
Calcite | Level 5

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

 

 

 

 

 

 

1 REPLY 1
ArnoldP
Obsidian | Level 7

Maybe stupid question, but do you really have named STATIC in uppercase on your path?