Hi Experts, I have following data in rule column: s_no rule 1 Security_type in("GSEC", "SSEC") 2 Security_type = "OAS" AND Guaranteer = "Cent_govt" 3 Security_type = "OAS" AND Guaranteer = "State_govt" AND Residual_maturity LE 0.5 4 Security_type = "OAS" AND Guaranteer = "State_govt" AND Residual_maturity GT 0.5 LE 2 5 Security_type = "OAS" AND Guaranteer = "State_govt" AND Residual_maturity GT 2 I want to create 5 macro variable var1 var2 . . var5 which contains var1: Security_type in("GSEC", "SSEC") var2: Security_type = "OAS" AND Guaranteer = "Cent_govt" . . and so on. sample code is here: %macro mymacro; proc sql noprint; select count(rule) into :count from MRCC_SMM.SMM_report_rules where s_no is not null; quit; proc sql noprint; select rule into:var separated by '@' from MRCC_SMM.SMM_report_rules where s_no is not null; quit; %do i=1 %to &count; data _null_; call symput("var&&i.",%sysfunc(scan("&&var.", &&i., "@"))); run; %end; %mend; %mymacro; Please give any idea how I can do that?. Thanks In advance.
... View more