Conditionally create macro variable

[Babloo]

I want to create one macro variable called 'LIBRARY' which I want to use it to the next step to query the permanent table. Assume I've a Job Name as below.

%let etls_jobName = IF_04_J_PRT_TRA_INSURANCE_RECORD_DELIVERY;

or

%let etls_jobName = IF_04_J_PRC_TRA_INSURANCE_RECORD_DELIVERY;

or

%let etls_jobName = IF_04_J_PRT_LOA_INSURANCE_RECORD_DELIVERY;

or

%let etls_jobName = IF_04_J_PRC_LOA_INSURANCE_RECORD_DELIVERY;

And

If the Job Name contains PRT_TRA then I want the macro variable to resolve to IFPRTEXT

If the Job Name contains PRC_TRA then I want the macro variable to resolve to IFPRCEXT

If the Job Name contains PRT_LOA then I want the macro variable to resolve to IFPRTTRA

If the Job Name contains PRC_LOA then I want the macro variable to resolve to IFPRCTRA

I never created the macro variable with some conditions. Appericiate if someone of you shed some light on this.

[PaigeMiller · Accepted solution]

Example:

data _null_;
    if find("&etis_jobname",'PRT_TRA')>0 then call symputx('library','IFPRTEX');
    /* additional if statements here as needed */
run;