You are getting an error in the second example because you included an ORDER BY clause in your sub-query. The first one does not generate an error since the sub-query doesn't have the ORDER BY clause.  As the third example shows you do not need to use a sub-query in a CREATE TABLE statement, so don't. ... View more

Is this a test?   SAS normally stops a data step when it reads past the end of the input data set or text file. Run this little example to see what I mean.   data _null_; put 'BEFORE INPUT' _n_= ; input ; put 'AFTER INPUT' _n_ = ; cards; 1 2 3 ;   In your second data step the conditions on your DO loops prevent it from reading past the end of the data. So on iteration 1 it does DO MONTH=9,10,11 and then on iteration 2 it does it again, ad infinitum.  Add a STOP statement before the RUN statement.     ... View more

As an alternative you could loop through your data set yourself and add the mean: data have; input grade; datalines; 1.4 3.2 3.4 2.1 4.3 5.4 ; Run; Data Want (Drop=Obs i Total);   Do Obs=1 By 1 Until (Eof);     Set Have End=Eof; Total=Sum(Total,Grade);   End;   Mean=Total/Obs;   Do i=1 To Obs;     Set Have; Output;   End; Run; ... View more

Change your data structure to ID Type Value 1 Reported 1234 1 Modeled 1234 Then use proc npar1way with TYPE as your class variable. ... View more