Desktop productivity for business analysts and programmers

SAS formatting values

Frequent Contributor
Posts: 125

SAS formatting values


i have below values which I got in SAS . I need to convert those values .

8206830622.6 value to 8,206,830,623

-74661564.97 to (74,661,564)

19.682897626 - 19.68290

0.0005251792 to 0.1%

can anyone pls help

Super User
Posts: 10,530

Re: SAS formatting values

Posted in reply to chennupriya

For the first, use the commaN. format, with N sufficient to display all the digits. 15 worked with your example.

For the second, use negparen15.

For the third, simply use 10.5

For the fourth, use percent7.1

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 1 reply
  • 1 like
  • 2 in conversation