data ae1;
input ATCClass $1-22 Drug $23-32 Medname $33-42;
length term $110;
term=catx("/^n ",ATCClass,Drug,Medname);
keep term;
datalines;
SOFTENERS, EMOLLIENTS DOCUSATE Docusate
HYDANTOIN DERIVATIVES PHENYTOIN Phenytoin
run;
title1 j=c "How to wrap the text in the column header and also values";
ods escapechar='^';
ods listing close;
ods pdf file="\\tgenbkup\users\PSanam\Desktop\New folder\test.pdf" style=styles.tr_tnr1 NOBOOKMARKGEN;
proc report data=ae1 split='|' headskip missing style(report)={rules=none frame=void cellpadding=2};
column term;
define term / 'ATC Class / |Drug / |Medication Name' order style(column)={cellwidth=5 in just=l} style(header)={textdecoration=underline just=l};
compute before term;
line put " ";
endcomp;
run;
ods pdf close;
ods listing; Please help me how to get the output as follows: ATC Class / Drug / Medication Name HYDANTOIN DERIVATIVES/ PHENYTOIN/ Phenytoin SOFTENERS, EMOLLIENTS/ DOCUSATE/ Docusate
... View more