| Date: | Wed, 11 Jun 1997 05:29:23 GMT |
|---|
| Reply-To: | David Michael Wright <david@CATS.UCSC.EDU> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU> |
|---|
| From: | David Michael Wright <david@CATS.UCSC.EDU> |
|---|
| Organization: | University of California, Santa Cruz |
|---|
| Subject: | Re: Match Merging without SQL |
|---|
It was suggested by a number of posters to use Proc Transpose with a
Tom Abernathy <tga1@columbia.edu> explained:
Did you look at PROC TRANSPOSE?
One nice feature for this problem of proc transpose is that
it will make the variable names from the value of a column.
You will need to add a dummy column to put in the VAR statement for
PROC TRANSPOSE. And your resulting matrix will most likely have
missings where you seem to want zeros.
NAME TEST DUMMY
John AA 1
John AB 1
Sam AA 1
Sam AC 1
PROC TRANSPOSE data=in out=out ;
BY NAME;
ID TEST;
VAR DUMMY;
RUN;
NAME AA AB AC
John 1 1 .
Sam 1 . 1
Good Luck,
- Tom Abernathy (tga1@columbia.edu)
| 
