| Date: | Mon, 19 Jan 2009 15:56:15 -0800 |
|---|
| Reply-To: | jasonm@UCLA.EDU |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | J M <jasonm@UCLA.EDU> |
|---|
| Subject: | Merging Problem |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1; DelSp="Yes"; format="flowed" |
|---|
Does anyone know why these two datasets aren't merging correctly based
on the following information.
Should not having an Informat or Label make a difference?
I have sorted both datasets by cat.
In dataset Y cat is a unique identifier.
# Variable Type Len Format Informat Label
3 cat Num 8 5.
In dataset X cat is not a unique identifier.
# Variable Type Len Format Informat Label
4 cat Num 8 5. 5. cat_NO
I used the following code to merge
data new;
merge x y;
by cat;
run;
Thanks.
| 
