Date: Fri, 14 Mar 2003 18:22:55 -0700
Reply-To: Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject: Re: ERROR: INPUT function requires a character argument. ??
Content-Type: text/plain; charset=us-ascii
You get a similar message in the data step; it tells you that numeric
values have been converted to character (the implicit conversion messag
which is frequently mentioned here).
You created an informat with the INVALUE DOSLEV statement, and an input
format *always* expects to read a character value. In the data step,
your numeric 5 is being converted to a character "5", and then that
character "5" is being run through the informat.
SQL won't do that implicit conversion for you; instead, it gives an
I'd like SAS to add an option which treats implicit conversions in the
data step as errors.
Manager, Technical Development
Metrics Department, First Health
West Sacramento, California USA
>>> "Huang, Ya" <yhuang@AMYLIN.COM> 03/14/2003 4:50 PM >>>
It seems to me that input function behaves differently
between data step and sql:
1,2,3 = 0.02
4,5,6 = 0.04
put a= b=;
select a, input(a, doslev.) as b
For the data step, everything seems OK,
but for the sql, I got the following error message:
ERROR: INPUT function requires a character argument
Isn't it strange?