Date: Tue, 12 Aug 2003 16:57:52 +0300
Reply-To: Arto Raiskio <arto.raiskio@SUOMENPOSTI.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Arto Raiskio <arto.raiskio@SUOMENPOSTI.COM>
Subject: Re: merge by produces missing values
"kristian albert" wrote
> BY TIME;
do a small test on a subset (1000 obs)
create a character variable in each sample data set with the time value,
like "12:10:30"
ie. x = put(thetimevar,time.);
merge by the new character var, ie. 'x'
if the times are precisely the same (including the seconds), they will merge
|