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 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of 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
  • 529 views
  • 0 likes
  • 2 in conversation