| Date: | Sun, 16 Nov 2003 15:55:29 -0500 |
|---|
| Reply-To: | tin-shun-jimmy chan <jimmy.chan@HEC.CA> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | tin-shun-jimmy chan <jimmy.chan@HEC.CA> |
|---|
| Subject: | merging two dataset |
|---|
| Content-Type: | text/plain; charset=us-ascii |
|---|
Hi,
I want to merge two dataset (let say dataset1 and dataset2) according
to a variable named CODE, the first one has 75 observations and the
second one has 1477 observations. Here is the following codes i used,
proc sql;
create table newdataset as
select a.*, b.*
from dataset1 as a left join dataset2 as b
on a.code=b.code;
quit;
although i succeded to merge the two datasets, instead of having 75
observations, now i have more than 2000 observations (the desired
results appear only at the end of the sheet with the precedent
observations = .). So, could someone tell me why ? (I just think there
is nothing wrong with my codes).
Thank you so much.
Jim
|
