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: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 499 views
  • 0 likes
  • 2 in conversation