topic Re: input function is failing to covert in to numeric in SAS Programming

input function is failing to convert in to numeric

vaidas — Tue, 25 Feb 2020 16:30:07 GMT

Input function is failing to convert in to numeric:

Field :Len=3, $CHAR3.

Using input function I am getting '.' for characters 1 to 99 and conversion works only for characters 100 to 999.

What could be done for this large data set analysis?

Proc SQL ;
Create Table Test As
Select distinct
input(A.Field,8.) as Field1,
count(A.ID) as Field2

From &Source_Curr as A

group by A.ID
HAVING Field1 <> Field2

Field values:

1
10
11
12
13
14
15
159
16
17
18
19
2
20
228
24
243
25
26
27
29
3
33
37
4
46
5
55
59
6
7
78
8
82
9
?

Above mentioned values are part of the large existing data set that is part of SAS library.

Re: input function is failing to covert in to numeric

PaigeMiller — Tue, 25 Feb 2020 15:30:56 GMT

Please show us your actual code. Please show us a portion of the actual input data.

Re: input function is failing to covert in to numeric

data_null__ — Tue, 25 Feb 2020 15:31:26 GMT

Yes seem to have omitted the important part from your post.

Re: input function is failing to covert in to numeric

vaidas — Tue, 25 Feb 2020 15:43:12 GMT

Proc SQL ;
Create Table Test As
Select distinct
input(A.Field,8.) as Field1

Multiple input versions were used. Neither of them is working.

Re: input function is failing to covert in to numeric

PaigeMiller — Tue, 25 Feb 2020 15:54:47 GMT

@vaidas

You have to show us a portion of your data in variable A

Re: input function is failing to covert in to numeric

vaidas — Tue, 25 Feb 2020 16:01:25 GMT

It is updated.

Re: input function is failing to covert in to numeric

vaidas — Tue, 25 Feb 2020 16:02:07 GMT

It was updated.

Re: input function is failing to covert in to numeric

PaigeMiller — Tue, 25 Feb 2020 16:06:04 GMT

@vaidas wrote:
It is updated.

I don't see where you provide a portion of your data set

Re: input function is failing to covert in to numeric

vaidas — Tue, 25 Feb 2020 16:10:33 GMT

1
10
11
12
13
14
15
159
16
17
18
19
2
20
228
24
243
25
26
27
29
3
33
37
4
46
5
55
59
6
7
78
8
82
9
?

Re: input function is failing to convert in to numeric

Krueger — Tue, 25 Feb 2020 16:19:28 GMT

Are you seeing any issues with the data you provided? I ran the below and it's converting to numeric without issue?

data have;
	input Field1 $3.;
	datalines;
1
10
11
12
13
14
15
159
16
17
18
19
2
20
228
24
243
25
26
27
28
29
3
33
37
4
46
5
55
59
6
7
78
8
82
9
?
;
run;

data want;
	set have;
	test = input(field1,8.);
run;

Re: input function is failing to covert in to numeric

PaigeMiller — Tue, 25 Feb 2020 16:21:00 GMT

Works for me.

data have; 
input field $;
cards;
1
10
11
12
13
14
15
159
16
17
18
19
2
20
228
24
243
;
proc sql;
	create table want as select input(field,8.) as field1 from have;
quit;

Of course, when you type the data into your message as plain old text, maybe that doesn't give us the exact same result as using your actual SAS data set named &source_curr. Could you please provide that data set following these instructions: How to create a data step version of your data AKA generate sample data for forums

Re: input function is failing to covert in to numeric

vaidas — Tue, 25 Feb 2020 16:26:45 GMT

Thanks. The data already exist in the SAS library I am not inputing these values. Therefore I can't see how it would work in my case.

data have; 
input field $;
cards;

Re: input function is failing to convert in to numeric

Tom — Tue, 25 Feb 2020 16:33:26 GMT

Your values LOOK fine (other than the question mark). Perhaps the data is not what it looks like? Try printing the data with $HEX6. format attached to that variable. Does the value '10' show as either '313020' or '203130'? If that non digit character is not '20'x (aka space) then you will need to clean the field first.

For example you could use the compress function and only keep the digits.

input(compress(A.field,,'dk'),8.)

Re: input function is failing to covert in to numeric

PaigeMiller — Tue, 25 Feb 2020 16:31:52 GMT

I have to create a data set to run code, that's why I have to input the data from the text you typed. But when I do that, I get the expected results and not the results you stated.

You have a SAS data set already so you don't have to do that.

But my dataset probably doesn't match yours in some important way, which is why I asked you to follow these instructions and provide us the data set: How to create a data step version of your data AKA generate sample data for forums

Re: input function is failing to convert in to numeric

vaidas — Tue, 25 Feb 2020 16:36:33 GMT

Thanks a lot Tom. It works.