Hi I want to add line while concatenating variables. tried a few things. Dont seem to get it done. The code is DATA Y;
SET result;
INFORMAT R $100.;
format R $100.;
R = CATX(":" ,"CDE" , cde_name, "Attribute", attrib_name);
where total_record_count gt 10.00 or total_record_count lt -10.00;
RUN;
PROC PRINT;
title 'Y';
RUN;
proc sql;
select (catx("^{newline 1}",R)) into :var separated by '^{newline 1}' from y
where total_record_count gt 10.00 or total_record_count lt -10.00;
run; Now I only get CDE:PRODUCT HIERARCHY:Attribute:PRD_HRCHY_LVL_2_CDE^{newline 1}CDE:PRODUCT
... View more