| Date: | Fri, 2 Mar 2007 12:04:08 -0500 |
| Reply-To: | mesecca L katram <mesecca@YAHOO.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | mesecca L katram <mesecca@YAHOO.COM> |
| Subject: | Re: Formating with Put function |
|---|
On Fri, 2 Mar 2007 12:00:48 -0500, mesecca L katram <mesecca@YAHOO.COM>
wrote:
>Hi all
>I am trying to format my report, here I am quoting the example so every
>body can run
>
>data xxy;
>input draw abc ;
>datalines;
>2 56.2
>3 -79.09
>4 88.90
>5 -90.00
>;
>run;
>
>data xxy1;
>set xxy;
>abc=left(trim(put(sdc, 8.2)));
>bbc=left(trim(put(sdc/100,percent8.2)));
>run;
>
>once you run it the results looks
>draw abc bbc
>2 56.2 56.20%
>3 -79.09 (79.09%)
>4 88.9 88.90%
>5 -90 (90.00%)
>
>some how puct function is putting bracket for negative value
>how do I make it look as follows....
>
>
>but I need them
>draw abc bbc
>2 56.2 56.20%
>3 -79.09 -79.09%
>4 88.9 88.90%
>5 -90 -90.00%
>
>
>thanks
The results look like this
draw abc bbc
2 56.2 56.20%
3 -79.09 (79.09%)
4 88.9 88.90%
5 -90 (90.00%)
but I want them
draw abc bbc
2 56.2 56.20%
3 -79.09 -79.09%
4 88.9 88.90%
5 -90 -90.00%
|