Date:         Mon, 19 Apr 2010 12:39:57 -0400
Reply-To:     Carol Thurman <erbcjt@LANGATE.GSU.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Carol Thurman <erbcjt@LANGATE.GSU.EDU>
Subject:      Re: How to show the % symbol after 0
Comments: To: snoopy369@GMAIL.COM
Content-Type: text/plain; charset=US-ASCII

Thanks but I'm still not getting the desired result.

Carol

>>> Joe Matise <snoopy369@GMAIL.COM> 04/19/10 10:58 AM >>>
If DATA _NULL_'s suggestion doesn't work, could you add
. = '0%'
to the picture format (in the PROC FORMAT statement)?

-Joe

On Mon, Apr 19, 2010 at 9:29 AM, Carol Thurman <erbcjt@langate.gsu.edu>wrote:

> Murphy,
>
> Thanks for responding. I tried what you suggested but it didn't work.  I
> was able to get the percent symbol to show up for the calculated percent
> values by this command: picture pct(round)low-high= '009.9%'; but I can't
> get the % symbol to show up after the 0's that have been put in the blank
> cells.
>
> If anyone has any more ideas on how to accomplish this, please let me know.
>
> Thanks!
>
> Carol
>
>
>
> >>> Murphy Choy <goladin@GMAIL.COM> 04/19/10 10:21 AM >>>
> Hi,
>
> Maybe this will help. Below is an example of getting % signs in the
> tabulate
> 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;
>
>
> On Mon, Apr 19, 2010 at 10:00 PM, Carol Thurman <erbcjt@langate.gsu.edu
> >wrote:
>
> > Hi All,
> >
> > I am using proc tabulate.
> > I have inserted zeroes in blank cells using the options missing = 0
> command
> > but how do I get the % symbol after the zeroes?  All the other values in
> the
> > table cells are percentages.
> >
> > Thanks for your help,
> >
> > Carol
> >
>
>
>
> --
> Regards,
> Murphy Choy
>
> Certified Advanced Programmer for SAS V9
> Certified Basic Programmer for SAS V9
> DataShaping Certified SAS Professional
>