No But I did have a format of the form: value YEAR_f.
1980 = '1980'
..... other years......
2010 = '2010'
; which I didn't suspect to cause troubles since other "by" statements used in other procedures worked without any problems. However, after deleting the format and using unformatted variable"year" in panelby statement, PROC SGPANEL worked fine. Another observation I made is that once the PROC SGPANEL was unsuccessfully run once, it created a temporary file in "WORK" library, which I couldn't delete manually. I had to reopen SAS to have it deleted. I think this was causing the error that says "Your dataset was not sorted" even though it runs the proc sort simultaneously with PROC SGPANEL when I tried to run the SGPANEL again. Bottom line, PROC SGPANEL and especially panelby is very sensitive to the format used and once run with error will not be able to run again without closing SAS. I am still confused when the original values and when the formatted values are used when executing "by" "group" "category" "panelby" statements. Thank you all for help!
... View more