HOW TO STORE A NUMERIC VALUE IN SAS WITH 22 DIGITS INCLUDES DECIMAL

[ANIRBAN2]

I wanted to create table numeric which can store 22 digits and with decimals.

I need to create a table in proc sql only

and run insert query to enter the data.

Eg=123456789987654321.999

this is the numeric value.

[Ksharp]

NO. You can't .
But you could try PROC FEDSQL ,there is a BIGINT type variable.

[Kurt_Bremser]

You can store the number, but only with precision down to the 15th digit (overall). The imprecision is statistically insignificant.

[ballardw]

What exactly does that "number" represent with that many digits where a decimal is important?

[ANIRBAN2]

That number is used at some where to calculate the VAR at retail banking. That I am not actually aware totally.

[jklaverstijn]

You could try and use explicit SQL pass-through. That way you use the SQL of the target DBMS. But that would only work if the large number is hardcoded in plain text or coming from another dbms table. It could not come from a SAS dataset. SAS' 8-byte numeric is either large magnitude or high precision but not both. Compare that to the 17-byte decimal in SQL Server. Can't fit round pins in square holes.

FedSQL may also be viable here but I have little experience go offer there.

Regards,

- Jan.

[jklaverstijn]

Ah you want it in SAS. Sorry my brain was talking database to me. 😉

[Tom]

You cannot store that many digits of precision as a single number in a SAS dataset.  SAS has two variable types, fixed length character strings and 64 bit floating point numbers.  The maximum number of decimal digits you can store without lose of precision is 15.

Can you just store the value as a string of 22 (or perhaps 23 with the period?) characters?

string='123456789987654321.999';

Is the maximum absolute value just 10E18 like in your example and you only need three digits to the right of the decimal point?  Then you could store the first 11 to 15 digits in one number and the rest in another number. 

For example split the value into X and Y such that X+Y gets the desired value (if done in an environment that supports such precision).

x=123456789987000000.000;
y=000000000000654321.999;

[ANIRBAN2]

I have the data in a excel I will write a insert query to upload the data into SAS datasets
So this method how will it work??
Already defined the table its variable name and datatype struggling when using insert query to upload the data. That time I wanted to change the length of the numerical variable so that i could fit the value with precision but I failed.

[SASKiwi]

Are you referring to retail banking Value at Risk (VaR) ? If so there is no way you need 22 digits of precision for this. At the very least this would be calculated as a whole number (no decimals) and 10 digits can accurately store up to $9,999,999,999. Please post the SAS log of your program so we can advise further.

[ANIRBAN2]

I just hope you can see as template provided by the company(Integrated)

[SASKiwi]

That screenshot shows no numbers more than 10 digits long. As others have said, SAS numeric variables can accurately hold 15 digits so I don't see what your problem is. You need to provide a log of your SAS program if it is producing errors and you want help with that.

[ANIRBAN2]

I am in position of inputting sample data. Logs I cannot provide. Please view the snip.

[SASKiwi]

Surely you can run your program with fake data to produce the same errors? There shouldn't be anything confidential about that. 

[Kurt_Bremser]

Excel has the same precision limits as SAS, as it uses the same 8 byte floating point storage. So you can't precisely store a number with 22 digits in both environments.