I have this string: "Cdtr":{"Nm":"DEUTSCHE BANK"} How can I implement this in SAS like the function regexp_extract(fulltxinf_intx, '"Cdtr":."Nm":"([^"]+)', 1) as String_Ort   Thanks ... View more

why are my macro variables not resolved? Do you know it?  Thanks.   options mprint mlogic; %macro test; proc sql; select count(*) into :pstn_cc from ueberschrift_lesen; %let pstn_cc = &pstn_cc; select pstn into :pstn_cn1-:pstn_cn&pstn_cc from ueberschrift_lesen; quit; %do i=1 %to &pstn_cc; %put &pstn_cn&i; %end; %mend; %test;   my log: MLOGIC(TEST): %DO loop beginning; index variable I; start value is 1; stop value is 4; by value is 1. MLOGIC(TEST): %PUT &pstn_cn&i WARNING: Apparent symbolic reference PSTN_CN not resolved. &pstn_cn1 MLOGIC(TEST): %DO loop index variable I is now 2; loop will iterate again. MLOGIC(TEST): %PUT &pstn_cn&i WARNING: Apparent symbolic reference PSTN_CN not resolved. &pstn_cn2 MLOGIC(TEST): %DO loop index variable I is now 3; loop will iterate again. MLOGIC(TEST): %PUT &pstn_cn&i WARNING: Apparent symbolic reference PSTN_CN not resolved. &pstn_cn3 MLOGIC(TEST): %DO loop index variable I is now 4; loop will iterate again. MLOGIC(TEST): %PUT &pstn_cn&i WARNING: Apparent symbolic reference PSTN_CN not resolved. &pstn_cn4 ... View more