Conditionally create macro variable

Babloo — Mon, 16 Sep 2019 12:53:06 GMT

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;

%let etls_jobName = IF_04_J_PRC_TRA_INSURANCE_RECORD_DELIVERY;

%let etls_jobName = IF_04_J_PRT_LOA_INSURANCE_RECORD_DELIVERY;

%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.

Re: Conditionally create macro variable

PaigeMiller — Mon, 16 Sep 2019 12:56:46 GMT

Example:

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

topic Re: Conditionally create macro variable in SAS Programming

Conditionally create macro variable

Re: Conditionally create macro variable