topic Re: Result of input(var1,10.) displaying 3-length values in New SAS User

Result of input(var1,10.) displaying 3-length values

Masande — Mon, 07 Jan 2019 17:57:06 GMT

Considering the following code,

data belg;
	set belg ;
	days=input(date,10.);
run;

where date is a numeric, 8 length variable with DDMMYY10. as format/informat.

When I run it, days values are displayed in the dataset as 3-digits values. Changing the 10. to 12. allows to display the correct SAS date values (5 digits ones). Why do I need to use a 12. informat while the initial variable is DDMMYY10. and the expected variable have 5-length values ?

Re: Result of input(var1,10.) displaying 3-length values

Astounding — Mon, 07 Jan 2019 18:00:00 GMT

The first parameter to the INPUT function should always be a character string. But here, you are using a numeric value. So the question and answer hinge around how SAS handles that situation.

SAS takes the numeric value and converts it to character, so that the INPUT function can work. You would already have received a note on the log about a numeric to character to conversion taking place, but didn't realize the implications.

When making a numeric to character conversion, SAS typically uses 12 characters to hold the result. In this case, that would be 7 blanks, followed by 5 digits. When you apply the 10. informat to that result, SAS reads 10 characters (7 blanks, plus the first 3 digits). That's where your 3-digit numbers come from.

Re: Result of input(var1,10.) displaying 3-length values

Tom — Mon, 07 Jan 2019 19:19:48 GMT

What are you trying to actually do?

If the variable has the format MMDDYY10. then it should already have a number of days. SAS date formats work on numbers that represent the number of days since 1960, with 0 meaning 01JAN1960.

Re: Result of input(var1,10.) displaying 3-length values

Masande — Mon, 07 Jan 2019 19:57:40 GMT

I was just trying to manipulate date and conversion. No real objective, just SAS learning.