LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (September 2011, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 >


Back to: Top of message | Previous page | Main SAS-L page