topic Re: Assistance in reading Numeric column with Exponent signs in SAS Programming

Assistance in reading Numeric column with Exponent signs

Khutjo — Tue, 21 Apr 2020 04:21:15 GMT

Can I please get assistance on reading a numeric field

I'm trying to read field two and it needs to appear with the "E" sign

20	2.00E+11	154430	1	4
20	2.00E+11	154430	1	4
20	2.00E+11	154430	1	4
20	3.00E+11	62713	5	4
20	3.00E+11	100115	2	4
20	3.00E+11	100512	4	4
20	5.00E+11	151925	2	4
20	5.00E+11	152145	6	4
20	5.00E+11	152303	2	4
20	5.00E+11	153572	6	4
20	5.00E+11	154990	1	4
20	6.00E+11	153283	9	4

Re: Assistance in reading Numeric column with Exponent signs

andreas_lds — Tue, 21 Apr 2020 04:52:01 GMT

Appearance of data is controlled by assigning the appropriate format to the variable. Please be a bit more specific: post the code and log you used to read the data (as text using running-man-icon), so that we can see what happens.

Re: Assistance in reading Numeric column with Exponent signs

ChrisNZ — Tue, 21 Apr 2020 06:28:55 GMT

You mean you are trying to write that number so that it can be read in full.

The way numbers are displayed is controlled by formats. It looks like your format is too short.

Use a longer format such as comma20. for example.

Re: Assistance in reading Numeric column with Exponent signs

Kurt_Bremser — Tue, 21 Apr 2020 07:51:10 GMT

SAS provides a format and informat for scientific notation:

data want;
infile datalines dlm='09'x dsd truncover;
input
  f1
  f2 :e8.
  f3
  f4
  f5
;
format f2 e9.;
datalines;
20	2.00E+11	154430	1	4
20	2.00E+11	154430	1	4
;

The display format needs an additional byte for length because it needs to accomodate an eventual sign.

Re: Assistance in reading Numeric column with Exponent signs

FreelanceReinh — Tue, 21 Apr 2020 11:18:08 GMT

@Kurt_Bremser wrote:

SAS provides a format and informat for scientific notation:

But the informat Ew.d is just an alias of the default informat w.d, so it can be omitted.

Re: Assistance in reading Numeric column with Exponent signs

ballardw — Tue, 21 Apr 2020 14:59:58 GMT

Details are important.

If the "data" is the appearance in Excel then that is just the result of the Excel display showing something that may be numeric (or not, it does this with Phone numbers, social security and account ids as well) when the display column is narrower than needed to display all of the digits.

HOW are you attempting to "read" this? SAS does so pretty easily with no coaching IF that is what you want:

data junk;
   input a b c d e;
datalines;
20	2.00E+11	154430	1	4	 
20	2.00E+11	154430	1	4	 
20	2.00E+11	154430	1	4	 
20	3.00E+11	62713	5	4	 
20	3.00E+11	100115	2	4	 
20	3.00E+11	100512	4	4	 
20	5.00E+11	151925	2	4	 
20	5.00E+11	152145	6	4	 
20	5.00E+11	152303	2	4	 
20	5.00E+11	153572	6	4	 
20	5.00E+11	154990	1	4	 
20	6.00E+11	153283	9	4	
;

I strongly suggest expanding the width of the column and probably changing how you are reading the data as I suspect that value should not be numeric to begin with.

Re: Assistance in reading Numeric column with Exponent signs

Khutjo — Wed, 22 Apr 2020 08:21:57 GMT

I got it right

data Risk_Detail;

infile "file name',' MISSOVER DSD lrecl=32767 firstobs=2 ;

informat Name $100.;

informat registration_number $50.;

informat number best32.;

informat Service_Provider_No best32.;

format Name $100.;

format registration_number $50.;

format number best32.;

format Service_Provider_No best32.;

input

Name $

registration_number $

number

Service_Provider_No

;

run;