SAS Formatting question

Posted on 2006-06-09
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment

Accepted Solution

tobydavid earned 500 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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
In this post we will learn different types of Android Layout and some basics of an Android App.
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…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

695 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