Date:         Thu, 15 Sep 2011 14:30:59 -0700
Reply-To:     mlhoward@avalon.net
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary <mlhoward@AVALON.NET>
Subject:      Re: Negative paren format with dollar sign?
Comments: To: Yu Zhang <zhangyu05@gmail.com>
Content-Type: text/plain; charset="UTF-8"

This did work.  Thanks!

-Mary

--- zhangyu05@gmail.com wrote:

From: Yu Zhang <zhangyu05@gmail.com>
To: mlhoward@avalon.net
Cc: SAS-L@listserv.uga.edu
Subject: Re: Negative paren format with dollar sign?
Date: Thu, 15 Sep 2011 13:52:56 -0500

Not i am aware of. however, you can define an user-defined picture format,
something like this:

proc format;
picture negdollar (default=20)
   low-<0='000009.99)' (prefix='($')
   other=[dollar8.2];
run;
data test;
input amount;
put amount negdollar.;
cards;
12
12.45
-2312.34
0
;
run;

HTH

Yu


On Thu, Sep 15, 2011 at 1:19 PM, Mary <mlhoward@avalon.net> wrote:

> Does anyone know if there is a format like this?
>
> ($68.12)
>
> I want the dollar sign along with the parenthesis for negative values; I
> see negparen10.2 but that doesn't give me the dollar sign.
>
>
> -Mary
>