I am trying to print the address as a main group header of my report from data and want the lines to wrap up properly.
I have different fields for address in data that i have concatenated to get 1 field
for example:
name, address1, address2,city,state,zip ----->cats(name,address1,city,state,zip) as new_add in my table
eg: one of new_place data value is ---> Mcdonald's,100 newyork Ave,Queens,NY,56432
reports prints it out as 1 line on bygroup header : Mcdonald's,100 newyork Ave,Queens,NY,56432 (i am using byvar(new_add) on title to print on different pages)
But i want to be broken and text wrraped as below :
Mcdonald's
100 newyork Ave
Queens NY 56432
what options in proc report can be used to do so.
here's my code
TITLE1 bold f= Calibri h=14pt wrap j=c "reportTitle"; TITLE4 " "; TITLE5 f= Calibri j=l h=9pt "#byval(new_add)"; proc report nofs data = rep nowd spanrows split='~' headline missing by new_add ; column new_add var1 var2 var3; ; define new_add /group noprint '' format=$place. left style = {cellwidth=70mm rules=none };
define var1/group left style = {cellwidth=70mm rules=none };
define var2/group left style = {cellwidth=70mm rules=none };
define var3/group left style = {cellwidth=70mm rules=none };
run;
break after new_add / skip dul; run;
... View more
