Issue with PROC Expand (EG 8.2)

illmatic — Thu, 15 Dec 2022 01:31:56 GMT

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!

Re: Issue with PROC Expand (EG 8.2)

ballardw — Thu, 15 Dec 2022 01:04:49 GMT

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

Re: Issue with PROC Expand (EG 8.2)

illmatic — Thu, 15 Dec 2022 01:32:17 GMT

oops! That was a typo. Fixed.

topic Re: Issue with PROC Expand (EG 8.2) in SAS Programming

Issue with PROC Expand (EG 8.2)

Re: Issue with PROC Expand (EG 8.2)

Re: Issue with PROC Expand (EG 8.2)