Interesting. Did you run that on the desktop version or in sas studio? Using SAS Studio I ran this... FILENAME REFFILE "/folders/myfolders/roaddata1.csv" TERMSTR=CR;
PROC IMPORT DATAFILE=REFFILE
DBMS=CSV
OUT=roaddata1;
GETNAMES=YES;
RUN;
PROC CONTENTS DATA=roaddata1; RUN;
%web_open_table(WORK.IMPORT);
proc distance data=roaddata1 out=distmatrix method=Euclid;
var interval (FACT_AADT/ std=std);
id SEGMENT_ID;
run;
proc cluster data=distmatrix outtree=trees
method=ward noprint;
id SEGMENT_ID;
run;
proc tree data=trees noprint out=Final n=10;
id SEGMENT_ID; and got this.... (I'm thinking it is a SAS Studio Problem) NOTE: The data set WORK.DISTMATRIX has 8000 observations and 8001 variables.
NOTE: PROCEDURE DISTANCE used (Total process time):
real time 17.06 seconds
cpu time 0.80 seconds
91
92 proc cluster data=distmatrix outtree=trees
93 method=ward noprint;
94 id SEGMENT_ID;
95 run;
NOTE: The input data set is a TYPE=DISTANCE data set. For such a data set, the procedure requires that the order of the rows match
the order of the variables.
ERROR: Missing values are not allowed in the lower triangle of a distance data set.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.TREES may be incomplete. When this step was stopped there were 0 observations and 11 variables.
NOTE: PROCEDURE CLUSTER used (Total process time):
real time 58.22 seconds
cpu time 1.48 seconds
96
97 proc tree data=trees noprint out=Final n=10;
98 id SEGMENT_ID;
99
100 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
WARNING: The data set WORK.FINAL may be incomplete. When this step was stopped there were 0 observations and 3 variables.
112
... View more