Date:         Fri, 19 Sep 2008 12:28:05 -0700
Reply-To:     "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Subject:      Re: merging databases with dates
In-Reply-To:  <200809191832.m8JGmu8G016267@malibu.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Are the dates character variables or numeric variables with different
formats?

If the latter, then you can use them as is.

If the former, use the appropriate informat to convert each to a SAS
date and then do the merge.

-----Original Message-----
From: Dennis Tomashek
Sent: Friday, September 19, 2008 11:33 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: merging databases with dates

I have to sas databases that I need to merge. It is a many-to-many
merge, and thus need to use dates as two of the matching variables. The
problem is that one database has a $8 format (yyyymmdd), and the other
has a $7 format (yyyydaycount). SO Feb 5, 2008 would look like
'20080205' in the first database, and 2008036 in the second. Can I
reformat one of the databases, or convert both using an extraction and
mdy process? Any clues would be greatly appreciated.