Thanks for noting, but it's not the cause. I've corrected the typo and still get the error message data have; input year country $:1. value; datalines; 2000 A 1 2001 A 0 2000 B 1 2001 B 1 ; run; proc expand data=have out=want from=year to=qtr; convert value; id year; by country; run; ERROR: Duplicate time interval found at observation number 2 in the data set WORK.HAVE, according to the FROM=YEAR option and the ID variable values. The current ID is year=2001 and the previous is year=2000, which are within the same YEAR interval. Check that FROM=YEAR is correct for this data set, and that the ID variable year contains SAS date or datetime values that correctly identify the observations. NOTE: Execution is aborted because of invalid ID values or invalid FROM= option. NOTE: The above message was for the following BY group: country=A ERROR: Duplicate time interval found at observation number 4 in the data set WORK.HAVE, according to the FROM=YEAR option and the ID variable values. The current ID is year=2001 and the previous is year=2000, which are within the same YEAR interval. Check that FROM=YEAR is correct for this data set, and that the ID variable year contains SAS date or datetime values that correctly identify the observations. NOTE: Execution is aborted because of invalid ID values or invalid FROM= option. NOTE: The above message was for the following BY group: country=B NOTE: There were 4 observations read from the data set WORK.HAVE. NOTE: The data set WORK.WANT has 0 observations and 3 variables. NOTE: PROCEDURE EXPAND used (Total process time): real time 0.03 seconds cpu time 0.03 seconds
... View more