Date: Thu, 3 Mar 2011 07:44:16 -0600
Reply-To: "Data _null_;" <iebupdte@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Data _null_;" <iebupdte@GMAIL.COM>
Subject: Re: PROC DISTANCE
In-Reply-To: <716BE81A4F37C444B8A46B517D152E9E17751BD46B@NIHMLBX03.nih.gov>
Content-Type: text/plain; charset=ISO-8859-1
What version of SAS?
On Thu, Mar 3, 2011 at 7:30 AM, Long, Stuart (NIH/NIEHS) [C]
<long3@niehs.nih.gov> wrote:
> Hi Arthur:
>
> No, the log is completely error/warning/note free. Interestingly, DATA _NULL_ says he gets a populated matrix when he runs it. I have to think about what to do next.
>
> Thanks,
>
> Stu
>
> -----Original Message-----
> From: Arthur Tabachneck [mailto:art297@ROGERS.COM]
> Sent: Thursday, March 03, 2011 8:16 AM
> To: SAS-L@LISTSERV.UGA.EDU; Long, Stuart (NIH/NIEHS) [C]
> Subject: Re: PROC DISTANCE
>
> Stuart,
>
> Did your log provide any useful messages?
>
> Art
> -------
> On Thu, 3 Mar 2011 03:22:54 -0500, Long, Stuart (NIH/NIEHS) [C] <long3@NIEHS.NIH.GOV> wrote:
>
>>Hi All:
>>
>>I have read the documentation for PROC DISTANCE and it appears that
>>what I
> show here should produce a matrix with non-missing values:
>>
>>I have the following matrix that I am inputting to PROC DISTANCE:
>> _
>> N C C C C C C C C C C C C C C C C C C C
> C C C C C C C C C C C C C C C C C C C C C C
>> A C C C C C C C C C O O O O O O O O O O O O O O O O O O O
> O O O O O O O O O O O O O O O O O O O O O O
>>O M O O O O O O O O O L L L L L L L L L L L L L L L L L L L
> L L L L L L L L L L L L L L L L L L L L L L
>>b E L L L L L L L L L 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2
> 2 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 5
>>s _ 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8
> 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0
>>
>>1 ever_malathion 1 1 1 1 1 1 0 0 0 1 1 1 0 0 1 1 1 0 1 1 1 1 1 1 1 1 1 1
> 0 1 1 1 1 1 0 1 1 0 1 1 0 1 1 1 1 1 1 1 1 1
>>2 ever_chlorpyrifos 1 1 1 1 1 0 1 1 0 1 1 0 0 1 1 1 0 0 1 1 1 0 0 1 1 0
>>1 1
> 1 1 1 1 1 1 0 1 0 0 1 0 1 1 1 1 1 1 0 1 1 0
>>3 ever_terbufos 1 0 1 1 1 1 1 1 0 1 1 0 1 1 1 1 0 1 0 1 1 1 1 1 1 0 0 0
> 0 1 1 0 0 1 1 0 0 1 1 1 0 1 0 1 0 1 1 1 1 1
>>4 ever_diazinon 0 0 1 1 1 0 0 0 0 1 0 0 1 0 1 1 1 0 1 1 0 0 0 0 0 1 0 0
> 0 0 1 1 1 0 0 0 1 0 0 0 0 0 0 1 0 1 1 0 0 1
>>5 ever_phorate 1 0 1 1 0 0 1 0 0 0 1 0 1 0 1 0 0 1 0 1 0 0 1 0 1 0 0 0
> 0 0 1 1 0 1 0 1 1 1 1 0 1 1 1 1 1 0 0 1 0 1
>>6 ever_fonofos 0 1 1 1 0 0 1 0 0 1 1 0 1 0 0 1 0 0 0 0 1 0 1 0 0 0 1 1
> 1 1 1 1 1 0 0 1 1 0 1 0 0 1 0 1 1 0 0 0 1 1
>>7 ever_ACEPHATE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
>>8 ever_parathion 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0
> 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0
>>9 ever_DDVP 0 0 1 0 1 1 0 0 1 1 1 1 0 1 1 0 0 0 0 1 0 0 0 0 0 0 0 0
> 0 1 0 1 1 1 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0
>>
>>
>>I run the code below:
>>
>>proc distance data=testmatrix out=DMATCH method=DMATCH;
>> var NOMINAL(col: ) ;
>> id _name_;
>>run;
>>
>>
>>Here is what the dataset DMATCH looks like:
>>
>> ever_ ever_ ever_
> ever_ ever_ ever_ ever_ ever_ ever_
>>Obs _NAME_ malathion chlorpyrifos terbufos
> diazinon phorate fonofos ACEPHATE parathion DDVP
>>
>> 1 ever_malathion . . . .
> . . . . .
>> 2 ever_chlorpyrifos . . . .
> . . . . .
>> 3 ever_terbufos . . . .
> . . . . .
>> 4 ever_diazinon . . . .
> . . . . .
>> 5 ever_phorate . . . .
> . . . . .
>> 6 ever_fonofos . . . .
> . . . . .
>> 7 ever_ACEPHATE . . . .
> . . . . .
>> 8 ever_parathion . . . .
> . . . . .
>> 9 ever_DDVP . . . .
> . . . . .
>>
>>All values are missing. What am I doing wrong?
>>
>>Thanks for looking...
>>
>>Stu Long
>
| 
