Hi Mark,

It is two different sets of rows and all variables are unique. So how do I get these data sets together..

Cards; 1 2 3 4 5 2 3 4 5 6 3 4 5 6 7 ;

Cards; 2 3 4 3 4 5 3 4 5 ;

the output to be like this

1 2 3 4 5 2 3 4 2 3 4 5 6 3 4 5 3 4 5 6 7 3 4 5

Please Advise

Allie

In article <B0562E2B5957D411A42800D0B782284005D15A07@dshsmsgf1-a.dshs.wa.gov>, Terjeson, Mark says... > >Hi Allie, > >Will something like this do? > > >data table1; > input a b c d e; >cards; >1 2 3 4 5 >2 3 4 5 6 >3 4 5 6 7 >; >run; > >data table2; > input f g h i j; >cards; >2 3 4 5 6 >2 3 4 5 6 >4 5 6 7 8 >; >run; > >data table3; > set table1; > set table2; >run; > > >You don't mention some of your criterium, >i.e. same number of rows in both sets? >is it okay that row1 from each file gets >glued together, and row2 in each, etc. > >If you have the same number of rows, this >will work fine. You will have to make sure >no variable names are duplicated. NOTE: >this will truncate any extra rows left over >on either side. It will stop when ever either >table is done. > >Hope this is helpful, >Mark Terjeson >Washington State Department of Social and Health Services >Division of Research and Data Analysis (RDA) >mailto:terjemw@dshs.wa.gov > > > >-----Original Message----- >From: Allie [mailto:nospam@NEWSRANGER.COM] >Sent: Monday, July 09, 2001 1:35 PM >To: SAS-L@LISTSERV.UGA.EDU >Subject: Newbie and needs your help... very simple > > >Hi Everybody... > >If I have 2 sets of card and want to put it together... how do I do that? > >cards; >1 2 3 4 5 >2 3 4 5 6 >3 4 5 6 7 > >cards; >2 3 4 5 6 >2 3 4 5 6 >4 5 6 7 8 > >Wants the output to be like this >1 2 3 4 5 2 3 4 5 6 >2 3 4 5 6 2 3 4 5 6 >3 4 5 6 7 4 5 6 7 8 > >Please Advise > >Allie