| Date: | Tue, 28 Jan 2003 16:26:36 -0500 |
|---|
| Reply-To: | Jimmy <xiiro@YAHOO.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Jimmy <xiiro@YAHOO.COM> |
|---|
| Subject: | Merge/Combine question |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
This may be easy , but could get it! Could someone out there give me a
hand?
File1 File2
ID a1 a2 a3 a4 ID b1 b2 b3 b4
232 BAH GAH MOG SEF 232 BAH SAH MOG SEF
232 BAH GAH SEF HOH 232 BAH SAH MOG HOH
..
233
. 233
.
FILE3
ID ID1
232 707
FILE4
ID1 c1 c2 c3 c4 c5 c6
707 BAH MOG SEF JAH NUN BYT
UOT1 OUT2
FILE1āFILE3āFILE4 FILE2āFILE3āFILE4
ID A CNT ID B CNT
232 GAH 2 232 SAH 2
232 HOH 1
Finally, we want something like this in a flat file:
OUTFINAL(OUT1 &OUT2)
ID A CNT B CNT
232 GAH 2 GAH 0
232 HOH 1 HOH 1
232 SAH 0 SAH 1
Any help would be greatly appreciated.
Jimmy.
| 
