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"

Avinash,

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 :)!