08-26-2015 01:58 PM
sorry for not providing more detail. I'm planning on using Proc Report. Currently the report is going to Excel but I don't know if that's a hard-and-fast requirement. If we could get it to RTF that might work just as well.
08-26-2015 02:11 PM
I tried to attach an example in Word but it said the file was too large. In any case imagine the SASHELP.CLASS file with a header that spans the entire table with the text 'Table 1. SASHELP.Class'. Underneath that are two spanned headers entitled 'First two variables' that span the Age and Sex columns and another header 'The other 3 variables' that span name, height and weight. THen there'd be a row with Sex, Age, Name, Height and Weight with the actual data values following them.