Date: Mon, 8 Feb 2010 16:02:18 -0500
Reply-To: Nathaniel Wooding <nathaniel.wooding@DOM.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Nathaniel Wooding <nathaniel.wooding@DOM.COM>
Subject: Re: Error with Variables
In-Reply-To: <15aa5d7a-3268-49f1-9d45-674c39c58d56@g28g2000prb.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"
This message suggests that you are concatenating data sets and that at least one of them has date stored as a numeric variable and at least one has it as a character variable.
Were these data sets, by chance, read from Excel files? One of the problems in concatenating multiple sets that came from Excel is that if a normally numeric variable is blank for more than the number of guessing rows, it will be set to character.
Please tell us (the list) a little more about what you are doing.
Nat Wooding
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Raj
Sent: Monday, February 08, 2010 3:41 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Error with Variables
Hi,
I got a en error message when im testing a prog.
error was
ERROR : Date was declare as both numeric and character
This is when reading the files for input. date is just a variable
name.
The problem is i have 26 input files and i want to know in which data
set or file the problem is.
is it possible??? For this i have manually checked and found it.
Please let me know.
Regards,
CONFIDENTIALITY NOTICE: This electronic message contains
information which may be legally confidential and or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect. The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful. If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it. Thank you.
