Two variables in the same column aren't like to work within proc report. Is the 'report' supposed to count or summarize a variable to the the "# provided" value? Depending on your data structure I think it might be possible to get something like this using proc tabulate as it treats nesting differently. But the summary values would have to come from the same function (n or sum) and getting a label like "# provided" in a summary column takes a bit of extra work. And a pretty complete description of the input data would be needed.
... View more
Thanks so much for this! It worked, and specifying the file as xml, rather than xls, meant that the excel file opened right up rather than me having to tell excel to open it.
... View more