Issue with PROC Expand (EG 8.2)

[illmatic]

proc sort data=have;
by date group subgroup partner product;
run;


PROC EXPAND DATA=have OUT=want FROM = DAY TO = WEEK;
	BY group subgroup partner product;
	ID date;
	CONVERT cnt / 
	; 

ERROR: There is only 1 usable input observation. At least 2 are required. (Some observations may have been ignored because of 
previous errors.)

I'm trying to do a simple convert of daily data to weekly for forecast.

Bonus question, anybody know how I can roll it up to Sundays?

Thank you!

[ballardw]

Why do you have date on the BY statement in proc sort twice?

[illmatic]

oops! That was a typo. Fixed.