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?

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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