Date:         Mon, 18 Sep 2000 17:32:00 -0400
Reply-To:     HERMANS1 <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         HERMANS1 <HERMANS1@WESTAT.COM>
Subject:      Re: Converting Char to Numeric
Comments: To: "Deppman; Laurie M" <Laurie.Deppman@DOH.WA.GOV>
Content-Type: text/plain; charset=US-ASCII

In SAS SQL a join on matching key values does not require a common BY group; use
a function or format to convert one or both keys to a common basis.  For
example,

create table t as
select t1.date as ndate,t2.date as cdate from a as t1 inner join b as t2
                                       on t1.date=input(t2.date,mmddyy10.)
;

Sig
-----Original Message-----
From: "Deppman; Laurie M" <Laurie.Deppman@DOH.WA.GOV> at Internet-E-Mail

Sent: Monday, September 18, 2000 12:14 PM
To: SAS-L@LISTSERV.UGA.EDU at Internet-E-Mail
Subject: Converting Char to Numeric


How do I convert a character to a numeric variable in an existing SAS data
set?  I am merging three data sets.  One data set established a variable as
character and the other data sets established the same variable as numeric.
SAS will not let me merge them until all like variables are either char or
numeric.