BookmarkSubscribeRSS Feed
kwu
SAS Employee kwu
SAS Employee
when I define a numeric variable (or attrib) in a dataset,and try to insert a value greater than 2500k, it starts having the round off error, SAS does not complian the overflow (no warning or error) but just insert it with round off error.
I am trying to understand how sas stores the numeric value with different length and how to calculate the safe data range for a specified length? which doc?

I checked in the help and find that I can add a check constraint. I wonder how much overhead it is when adding this type of constrain to a table? Would it be more efficient by checking the cloumn in the code before inserting the data into the dataset ?

Any suggestion would be high appreciated.
1 REPLY 1

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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