You are not defining your variable long enough for the strings you trying to store in it. 332 data test; 333 length outcome $100; 334 outcome='The Number of Cases Assigned for an Investigation (%)' ; 335 outcome=catx(' ',outcome,'~{super 2}'); 336 len=length(outcome); 337 put (_all_) (=/); 338 339 340 run; outcome=The Number of Cases Assigned for an Investigation (%) ~{super 2} len=64 ... View more

%macro psubpop; ODS TAGSETS.EXCELXP file="T:\Folder\Outcomes 2019 &region..xml " style=Htmlblue ; ods tagsets.ExcelXP options (embedded_titles='yes' embedded_footnotes='yes' ORIENTATION='Landscape' autofit_height='yes' sheet_interval='none' sheet_name="700");; footnote; title1 height=10pt bold justify=left "Outcomes ~(super 1) January-December 2019 "; PROC REPORT DATA=All_Sti3 nowd headline headskip; where DIAGNOSIS='ES' and pop='M'; COLUMN outcomes outcome upstate &region. ; define outcomes/display ' ' order style(HEADER)={just=center font_weight=bold fontsize=2.8 vjust=bottom cellwidth=1.8in cellheight=30}; define outcome/display 'Outcome' order order=DATA style(HEADER)={just=center font_weight=bold fontsize=2.8 vjust=bottom cellwidth=4in cellheight=30}; define upstate/display 'UPSTATE' style(HEADER)={just=center font_weight=bold fontsize=2.8 vjust=bottom cellwidth=1.2in cellheight=30}; define &region./display "&region." style(HEADER)={just=center font_weight=bold fontsize=2.8 vjust=bottom cellwidth=1.4in cellheight=30}; RUN; footnote1 height=8pt justify=left "~{super 1}OP's "; footnote2 height=8pt justify=left "~{super 2}Number and percent of case assignments are based on report year "; footnote3 height=8pt justify=left "~{super 3}Testing "; footnote4 height=8pt justify=left "~{super 4}PrEP:Referral are calculated by excluding Current "; PROC REPORT DATA=All_Sti3 nowd headline headskip; where DIAGNOSIS='ES' and pop='F'; COLUMN outcomes outcome upstate &region. ; define outcomes/display ' ' group style(HEADER)={just=center font_weight=bold fontsize=2.8 vjust=bottom cellwidth=1.8in cellheight=30}; define outcome/display 'Outcome' order order=DATA style(HEADER)={just=center font_weight=bold fontsize=2.8 vjust=bottom cellwidth=4in cellheight=30}; define upstate/display 'UPSTATE' style(HEADER)={just=center font_weight=bold fontsize=2.8 vjust=bottom cellwidth=1.2in cellheight=30}; define &region./display "&region." style(HEADER)={just=center font_weight=bold fontsize=2.8 vjust=bottom cellwidth=1.4in cellheight=30}; title1 height=10pt bold justify=left "Outcomes2 ~{super 8} January-December 2019"; RUN; ods tagsets.excelxp close; %mend; %psubpop; Something like this should work for you. ... View more