DATA Step, Macro, Functions and more

about length of a numeric varaible in dataset

Reply
SAS Employee kwu
SAS Employee
Posts: 34

about length of a numeric varaible in dataset

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.
Regular Contributor
Posts: 241

Re: about length of a numeric varaible in dataset

Ask a Question
Discussion stats
  • 1 reply
  • 114 views
  • 0 likes
  • 2 in conversation