topic Re: Why is the numeric value getting converted to character while using input statement? in SAS Programming

Why is the numeric value getting converted to character while using input statement?

Tommer — Tue, 03 Nov 2020 21:30:21 GMT

Hello,

Below is the program. When I apply format to max it works perfectly as expected, but I was trying to use input statement and the results did not look right at all. One of my colleagues also suggested I can re-write it as max1= input(put((n1/n2),4.1),best.); but I still did not understand why input is converting numeric values to character in the first place. Any help?

data dryrun;
input n1 n2;
max = n1/n2;
max1= input((n1/n2),4.1);

format max 4.1;
datalines;
37 53
40 52
39 52
;
run;

Re: Why is the numeric value getting converted to character while using input statement?

ballardw — Tue, 03 Nov 2020 21:50:01 GMT

The input function requires a character value. So when you feed it a numeric value it converts it into a character value, usually using some form of BEST format. Then "inputs" the result.

The question is why would you even attempt an input of such a thing? What do you expect to result?

Generally the approach would be to do a numeric calculation and round the result if you don't want more than one decimal.

Perhaps

max = round( n1/n2, 0.1);

Or show us the explicit result you are expecting/wanting.

Re: Why is the numeric value getting converted to character while using input statement?

Tommer — Wed, 04 Nov 2020 00:14:11 GMT

thanks @ballardw I was fixing a lengthy existing program where I came across using input function throughout the program in this way and noticed the conversion and that the values did not look right. I am assuming it was used to display it in 4.1 format using input function and numeric to numeric conversion. But I was not clear as why it did not work. Now, I get it. It was looking for a character value and thus, the automatic conversion occurred.