SAS Infrastructure of Risk Management: How to use the "Extended Custom Mapping Definition" ?

atsen92 — Tue, 23 Oct 2018 20:11:13 GMT

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

Re: SAS Infrastructure of Risk Management: How to use the "Extended Custom Mapping Definition&q

ArnoldP — Tue, 18 Jun 2019 13:27:51 GMT

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

topic Re: SAS Infrastructure of Risk Management: How to use the "Extended Custom Mapping Definition&q in SAS Risk Management

SAS Infrastructure of Risk Management: How to use the "Extended Custom Mapping Definition" ?

Re: SAS Infrastructure of Risk Management: How to use the "Extended Custom Mapping Definition&q