Help using Base SAS procedures

Error importing Excel data of type = distance

Reply
N/A
Posts: 0

Error importing Excel data of type = distance

I am trying to import an excel file of a distance matrix for use with Proc Cluster. It looks like this: However, I get an error that says the number of observations (6) needs to be the same as the number of groups (4). No matter what size of matrix I try to read in, SAS always thinks I only have 4 groups. Any suggestions?

Group A B C D E F
A 0 . . . . .
B 1.5 0 . . . .
C 0.333333333 0.333333333 0 ..
D 0.2 0.2 0.5 0 . .
E 0.5 0.5 1.5 1.5 0 .
F 0.333333333 1 1.5 1.5 1 0
Ask a Question
Discussion stats
  • 0 replies
  • 177 views
  • 0 likes
  • 1 in conversation