topic Re: How to write format for numeric in SAS Programming

How to write format for numeric

thanikondharish — Mon, 10 Jun 2019 08:07:19 GMT

I have one value 234782617327.23456
How to write informat and format for above value

Re: How to write format for numeric

ChrisNZ — Mon, 10 Jun 2019 09:21:59 GMT

SAS numbers have a precision of 16 digits maximum.

So you will not be able to read or store this number and keep all the exact digits.

You can split the number if you still want to store as a number.

For example:

data _null_;
  file 'path\example.txt';
  put '234782617327.23456';
 run;

data WANT;
  infile 'path\example.txt';
  input;
  INT=input(      scan(_infile_,1,'.'),best16.);
  DEC=input('0.'||scan(_infile_,2,'.'),best16.);
run;

Re: How to write format for numeric

thanikondharish — Mon, 10 Jun 2019 09:25:59 GMT

Data ex1;
Input number $30.;
Cards;

234782617327.23456

;

How to convert character to numeric

Note: value should be same 234782617327.23456

#- Please type your reply above this line. No attachments. -##

Re: How to write format for numeric

ChrisNZ — Mon, 10 Jun 2019 10:19:44 GMT

@thanikondharish

> value should be same

To repeat:

SAS numbers have a precision of 16 digits maximum.

You can read this page if you want to know more.

https://en.wikipedia.org/wiki/Floating-point_arithmetic

This sentence is the relevant part:

Double precision, usually used to represent the "double" type in the C language family (though this is not guaranteed). This is a binary format that occupies 64 bits (8 bytes) and its significand has a precision of 53 bits (about 16 decimal digits).

Re: How to write format for numeric

Kurt_Bremser — Mon, 10 Jun 2019 12:50:00 GMT

@thanikondharish wrote:

Note: value should be same 234782617327.23456

You should work on your reading skills. You have already been told that this is not possible.