|Date: ||Fri, 5 Sep 2008 15:19:24 -0400|
|Reply-To: ||"Horne, Jim - James S" <Jim.S.Horne@LOWES.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Horne, Jim - James S" <Jim.S.Horne@LOWES.COM>|
|Subject: ||Merging two datasets with missing values in one|
|Content-Type: ||text/plain; charset="us-ascii"|
I have two datasets as follows:
DATA1 has variables TIME, INIT and DATA1JOBS.
DATA2 has variables TIME, INIT, SYSTEM and DATA2JOBS.
DATA1 has one observation for all possible values of INIT and all possible values of TIME.
DATA2 has one observation per SYSTEM for individual values of TIME and INIT.
I need DATA3, to have TIME, INIT, SYSTEM, DATA1JOBS and DATA2JOBS for all possible values of INIT, TIME and SYSTEM.
I have tried sorting and merging and that did not work. I got missing values for SYSTEM when DATA2 did not have an observation for it. I suspect SQL can help but I know virtually nothing about it. Can someone please help me with this? (For anyone familiar with MVS, I'm writing a map of all the JES2 initiators in multiple systems in one minute intervals over a day.)
Large Systems Engineering & Messaging IS7-5
Lowe's Companies, Inc.
401 Elkin Highway
North Wilkesboro, NC 28659