BookmarkSubscribeRSS Feed
CarlangA
Calcite | Level 5

Hi there,

 

I'm currently working with a data base that contains negative currency values like this.

 

s1.png

 

The problem is when i display the table on SAS those values displays as a super big number.

 

s2.png

 

I've tried several formatting options but the results are useless, SAS is reading the number in that way. Any help will be welcome.

 

 

1 REPLY 1
ballardw
Super User

What format are you applying to the variable? In the first picture and the second picture?

And is the first picture from an external data base? If so you may have a conversion issue based on the display rules from the data base.

 

What value to expect to see?

 

What is the actual value of the number? (May have to display as best32. )

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 874 views
  • 0 likes
  • 2 in conversation