sorry i attached a wrong dataset, please see this one instead ... View more

I have put sample data and desired output. I do not understand you said about "dataset as your data step". I cannot put two files at one time, so I have to attached one by one I have generated first table  and need to calculate the total number of each column, and then the percentage is the number of each cell devided by the total number ... View more

In fact, each disease has a different dataset. It is so huge so I do not analyze these together. Agegroups also have different huge datasets. In stead, I am required to report with each different table, with each different disease category, as always. Othe than that, my sample data is like the one I have provided. ... View more

  The first part of macro code is to generate six tables, for patients with ADHD, anxiety, and depression. Each disease has two tables, first year, and second year. Each table includes year from 2006-2008 and 2009. Each table also includes child, adult, and senior. Svc1 has value 1. Child, svc2 has value child2. With this part, we can generate six tables. A sample table is attached. But I need to calculate the total number of patients, and the percentage to have a second table. That is what I am asking for. In reality, the table is complicated and has many rows and columns with many obs. So it is very time consuming to calculate one by one. ... View more

Thanks. Without a sample sas code, without an example, it is hard for me to do. Plus, I saw "You can set the PDFPASSWORD option at any time, but it is ignored until the PDFSECURITY system option is set to either LOW or HIGH. When the PDFSECURITY option is set to NONE, passwords for a PDF document are not needed."   Would you please provide sas code? or an example with code? Thanks. ... View more

thanks the original table that I work on is generated by SAS macro. It is hard for me to combine transpose and macro. It would be helpful if you have sample sas code that works with transpose and macro   ... View more