Date:         Thu, 15 May 2003 14:56:29 -0400
Reply-To:     Ed Heaton <EdHeaton@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ed Heaton <EdHeaton@WESTAT.COM>
Subject:      Re: merging two tables
Comments: To: Nick Paszty <paszty@XOMA.COM>
Content-Type: text/plain; charset="iso-8859-1"

Nick,

This will do exactly what you asked for.  But does it do what you want?

Proc sql ;
    Create table both as
        select *
        from dset1 , dset2(drop=subjid)
    ;
Quit ;

Ed

Edward Heaton, Senior Systems Analyst,
Westat (An Employee-Owned Research Corporation),
1600 Research Boulevard, Room RW-3541, Rockville, MD 20850-3195
Voice:  (301) 610-4818                    Fax:  (301) 610-5128
mailto:EdHeaton@westat.com                http://www.westat.com



-----Original Message-----
From: Nick Paszty [mailto:paszty@XOMA.COM]
Sent: Thursday, May 15, 2003 2:11 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: merging two tables


hello.

solaris sas v8.2.

i have two data sets whose structure are as follows.

dset1
subjid  var1
1189    xxxx1
1189    xxxx2

dset2
subjid  var2
1189    d0
1189    d0
1189    d14
1189    d28

i would like to merge these two to produce the following structure

dset3
subjid  var1   var2
1189    xxxx1  d0
1189    xxxx1  d0
1189    xxxx1  d14
1189    xxxx1  d28
1189    xxxx2  d0
1189    xxxx2  d0
1189    xxxx2  d14
1189    xxxx2  d14

any simple/clever means of doing this?

thanks,

nick