Go Premium for a chance to win a PS4. Enter to Win


SAS Formatting question

Posted on 2006-06-09
Medium Priority
Last Modified: 2010-05-18

I need some SAS formatting help, currently a have a monetary field formating like so:


Whats the easiest and fastest way to format it like:


Question by:const71
1 Comment

Accepted Solution

tobydavid earned 2000 total points
ID: 16878560
Use PROC FORMAT to create your own format

PICTURE myformat
low -< 0  = '000,000,000.99-' (prefix='$')
0 - high = '000,000,000.99 ' (prefix='$');

.... you can then use "myformat" like any other format.  Be sure to remember that formats end with a period.  I do not have SAS installed on this computer so I cannot test it, but this will get you there or very close.  if you get 2 minus signs (before and after) you should be able to fix that by adding ",mult=-1" in the before the first parenthesis.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you are a mobile app developer and especially develop hybrid mobile apps then these 4 mistakes you must avoid for hybrid app development to be the more genuine app developer.
When you discover the power of the R programming language, you are going to wonder how you ever lived without it! Learn why the language merits a place in your programming arsenal.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
Six Sigma Control Plans

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question