Tip of the Day
From sasCommunity
sasCommunity Tip of the DaySome users want to have a percentage sign in the PROC TABULATE RESULTS when they are using PCTN and PCTSUM measures. Below is a suggestion to getting the symbols into the table. DATA COMPREV; INPUT COUNTRY COMPUTER REV90 REV91 REV92; DATALINES; 1 1 788.8 877.6 944.9 1 2 12538.1 9855.6 8527.9 1 3 9815.8 6340.3 8680.3 1 4 3147.2 3474.1 3722.4 1 5 18660.9 18428.0 23531.1 2 1 469.9 495.6 448.4 2 2 5697.6 6242.4 5382.3 2 3 5392.1 5668.3 4845.9 2 4 1511.6 1875.5 1924.5 2 5 4746.0 4600.8 4363.7 ;RUN; PROC FORMAT; PICTURE PCTFMT LOW-HIGH='009 %'; RUN; PROC TABULATE DATA = COMPREV; CLASS COUNTRY COMPUTER/MISSING; TABLE COUNTRY*COMPUTER,PCTN*F=PCTFMT9.; RUN; Submitted by Murphy Choy. Contact me at my Discussion Page.
Feel free to comment on this tip. |
Prior tip - Next tip -- Random Tip
Tips Index by Status |
Search Tips: |
The Tip of the Day Project
A new technical Tip of the Day related to SAS software will be shown on this page and the sasCommunity.org main page every day. Before getting started, you can Browse and Search the current list of tips contributed by users.
Anyone can participate. We hope you do! Here's how:
- Submit a Tip by posting a SAS tip that you think others might find useful
- Review a Tip prior to publishing
