https://communities.sas.com/t5/SAS-Programming/about-length-of-a-numeric-varaible-in-dataset/m-p/74042#M15980 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.<BR /> 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? <BR /> <BR /> 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 ? <BR /> <BR /> Any suggestion would be high appreciated. Wed, 22 Sep 2010 19:16:42 GMT kwu 2010-09-22T19:16:42Z https://communities.sas.com/t5/SAS-Programming/about-length-of-a-numeric-varaible-in-dataset/m-p/74042#M15980 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.<BR /> 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? <BR /> <BR /> 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 ? <BR /> <BR /> Any suggestion would be high appreciated. Wed, 22 Sep 2010 19:16:42 GMT https://communities.sas.com/t5/SAS-Programming/about-length-of-a-numeric-varaible-in-dataset/m-p/74042#M15980 kwu 2010-09-22T19:16:42Z https://communities.sas.com/t5/SAS-Programming/about-length-of-a-numeric-varaible-in-dataset/m-p/74043#M15981 See this sas-l posting and the link in it.<BR /> <A href="http://tinyurl.com/2c8939j" target="_blank">http://tinyurl.com/2c8939j</A> or<BR /> <A href="http://www.listserv.uga.edu/cgi-bin/wa?A2=ind1009C&amp;L=sas-l&amp;D=1&amp;H=0&amp;O=D&amp;T=1&amp;m=291216&amp;P=11759" target="_blank">http://www.listserv.uga.edu/cgi-bin/wa?A2=ind1009C&amp;L=sas-l&amp;D=1&amp;H=0&amp;O=D&amp;T=1&amp;m=291216&amp;P=11759</A> Wed, 22 Sep 2010 20:28:32 GMT https://communities.sas.com/t5/SAS-Programming/about-length-of-a-numeric-varaible-in-dataset/m-p/74043#M15981 chang_y_chung_hotmail_com 2010-09-22T20:28:32Z