Date: Thu, 30 Mar 2006 17:49:55 -0500
Reply-To: "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject: Re: Formatting Issue With Currency
Use the left alignment spec, as in
put dollaramount 8.2-L;
See
http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a000175758.htm
On Wed, 29 Mar 2006 06:15:49 -0800, The_Grudge <BarberD@GMAIL.COM> wrote:
>I have a program that exports a fixed length text file.
>
>One of the variables in this file is a dollar amount, but the specs
>require that I do not show a dollar sign.
>
>Using the SAS format "6.2" I have successfully been able to create a
>field 8 characters long to hold a dollar amount with no dollar sign.
>
>However, what I think I'm after is a floating decimal point. Here is my
>problem.
>We know that my field length is 8 characters long right? Well here is
>what one of my values looks like in the textfile (underscores being
>blanks).
>
>_23.66_ _
>
>That's no good...I need the value to always be left justified...like
>this
>
>23.66 _ _ _
>and
>123.66_ _
>
>Basically, there cannot be leading blanks.
>
>I tried using the "Left" function to move it left but no dice...any
>idears?
|