topic Re: INPUT Function unexpectedly producing missing values in SAS Programming

INPUT Function unexpectedly producing missing values

PaigeMiller — Fri, 22 Jun 2018 20:07:42 GMT

Simple problem, I have received a SAS data set where dates are not SAS date values, but are integers of the form 20180621, meaning June 21, 2018. I thought a simple use of the INPUT Function would turn these into SAS date values, but apparently not.

SAS code to reproduce (a small part of) the data set I received:

data a;
    input date;
	cards;
20180621
20180504
;
run;

So, I have received the data, it looks like 20180621, and now I want to use the INPUT function

data b;
	set a;
	date1=input(date,yymmdd8.);
run;

but this produces missing values instead of SAS Date values. Why? And how do I fix it?

Re: INPUT Function unexpectedly producing missing values

novinosrin — Fri, 22 Jun 2018 20:13:58 GMT

Sir, are you missing the first convert to char from num?

data a;
    input date;
	new_date=input(put(date,8.),yymmdd8.);
	format new_Date yymmdd10.;
	cards;
20180621
20180504
;
run;

data a;
input date;
cards;
20180621
20180504
;
run;

data b;
set a;
new_date=input(put(date,8.),yymmdd8.);
format new_Date yymmdd10.;
run;

Re: INPUT Function unexpectedly producing missing values

Reeza — Fri, 22 Jun 2018 20:13:52 GMT

INPUT requires a character input, but it would be nice if could be directly converted for sure.
http://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p19en16vskd2vhn1vwmxpxnglxxs.htm&docsetVersion=9.4&locale=en

Re: INPUT Function unexpectedly producing missing values

Astounding — Fri, 22 Jun 2018 20:14:59 GMT

If you have control over this part of the process, the program would work if you add a $:

input date $;

Re: INPUT Function unexpectedly producing missing values

PaigeMiller — Fri, 22 Jun 2018 20:17:42 GMT

Thanks, @novinosrin and @Reeza, I knew it was something simple.

But you don't have to call me "sir"

Re: INPUT Function unexpectedly producing missing values

novinosrin — Fri, 22 Jun 2018 20:23:09 GMT

"But you don't have to call me "sir" "

When I do, I really mean it and value those special few here. I seriously follow the highly accomplished yet humble personalities like you here and I shamelessly and openly admit to being biased to read their(you in the list) posts only. Thank you!

Re: INPUT Function unexpectedly producing missing values

ballardw — Fri, 22 Jun 2018 21:57:56 GMT

@Astounding wrote:

If you have control over this part of the process, the program would work if you add a $:

input date $;

@Astounding I suspect Paige actually received a .sas7bdat and wasn't reading an external file from scratch.

Re: INPUT Function unexpectedly producing missing values

novinosrin — Fri, 22 Jun 2018 22:09:06 GMT

@Everybody,, Some BOT seems to trigger LIKE for every post if you may have noticed or not. lol. I am not complaining though but so weird

Re: INPUT Function unexpectedly producing missing values

Reeza — Fri, 22 Jun 2018 22:11:20 GMT

@novinosrin @Sas_XXXX user name?

Re: INPUT Function unexpectedly producing missing values

novinosrin — Fri, 22 Jun 2018 22:12:01 GMT

yes @Reeza That's right

Re: INPUT Function unexpectedly producing missing values

Reeza — Fri, 22 Jun 2018 22:12:26 GMT

Definitely a bot, less than a second after the post. Interesting thing is they're not even showing online.

Re: INPUT Function unexpectedly producing missing values

novinosrin — Fri, 22 Jun 2018 22:13:58 GMT

@ChrisHemedinger or @AnnaBrown may help fix this ? Thanks @Reeza for immediate attention. Much needed and appreciated from my end.

Re: INPUT Function unexpectedly producing missing values

ChrisHemedinger — Sat, 23 Jun 2018 13:32:00 GMT

Hi all - thanks for bringing this to our attention. I've removed the Likes (regardless of how deserving your posts might have been) and we're looking into the cause.