Thank you so much! I also just figured that I can merge all the datasets and it will give me my desired dataset. ... View more

Hi:   You could do this easily in PROC REPORT, either with STYLE(SUMMARY) override or with a CALL DEFINE. But with TABULATE, you'd have to investigate the use of <PARENT> in a style override, as shown here:  http://support.sas.com/kb/25/401.html -- except in your case, you'd limit the parent inheritance only to the TOTAL lines.     But, without data to test on, nobody can run your code. And, it's hard to make fake data without understanding what YOUR data looks like.   Cynthia ... View more

"The government has specific specifications and the field must be 80 characters long." That means 80 Chinese Characters? So you need $160. to print it. Or try $varying. , I am not sure if it could work. P.S. I stil don't know about your unalign ,can you post a picture ?   len=80; put ........ @238 ENT_NATL_LANG_NM $varying200. len  ... View more

XLS engine is not support for Chinese/Japanese character. Try XLSX or EXCEL engine:   dbms=excel    or   dbms=xlsx ... View more