LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2001, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 10 Jul 2001 13:09:34 GMT
Reply-To:   Allie-Reply <nospam@NEWSRANGER.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Allie-Reply <nospam@NEWSRANGER.COM>
Organization:   http://www.newsranger.com
Subject:   Re: Newbie and needs your help... very simple

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


Back to: Top of message | Previous page | Main SAS-L page