Hi,   The short answer to your question is that generally, people generate this type of demographic report using PROC REPORT or using a DATA step program. Proc TABULATE will not "merge" cells the way you want for 2 separate statistics (a count and a percent). Both of these approaches are outlined in my paper called Creating Complex Reports, where I have 3 examples of this type of demographic report. To find a link to the paper and the download of programs, go to this site Technical Papers and Presentations made by SAS staff and look for the 2008 presentations. You will need to search for the paper title "Creating Complex Reports" to find the links. cynthia ... View more

It sounds to me like using Excel to capture your manually-entered data might be the easiest. How does this sound? 1. Using your automated system, select your set of eligible cases, and associated data, as a SAS dataset. 2. Using one of the many options available, copy these columns to an Excel spreadsheet on your PC. 3. Using Excel, add your new variables. I've had really good luck going from Excel to SAS with the 28APR2014 date format. 4. Again, using one of the many options for this, transfer your completed spreadsheet back into SAS for further processing. Tom P.S. Another option would be to use the Add-in for MS Office to handle the Excel conversion part. ... View more