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. )

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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