LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (November 2004, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 23 Nov 2004 11:31:14 -0600
Reply-To:     "Dunn, Toby" <Toby.Dunn@TEA.STATE.TX.US>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Dunn, Toby" <Toby.Dunn@TEA.STATE.TX.US>
Subject:      Re: Newbie needs your help!
Comments: To: Avinash <r_avinash@CHARTER.NET>
Content-Type: text/plain; charset="us-ascii"


This should get you there:

data three; set one two (rename = (race = sex)); run;

It doesn't have the obs where sex var is 'Race' and the rest as missing.

HTH Toby

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Avinash Sent: Tuesday, November 23, 2004 11:06 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Newbie needs your help!

Hi, I am a newbie with SAS. This might be a very easy Q for you guyz..... I have concatenated two datasets (say data1 and data2) to form a third dataset(data3). Data1 is as follows: Sex Dose1 Dose2 Male 23 2 Female 34 12 Data2 is as follows: Race Dose1 Dose2 White 20 76 Asian 23 56 Upon concatenation data3 looks like this: Sex Dose1 Dose2 Race Male 23 2 Female 34 12 20 76 White 23 56 Asian But I wanna have Data3 look like this: Sex Dose1 Dose2 Male 23 2 Female 34 12 Race White 20 76 Asian 23 56 Can you please help me out!!!!!! Thanks in advance :)!

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