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?

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Discussion stats
  • 1 reply
  • 1848 views
  • 0 likes
  • 2 in conversation