The date variable in excel is named Year. When i want plot the data using this variable i got the message: "ERROR: Duplicate time interval found at observation number 2 in the data set WORK.DATA, according to the INTERVAL=YEAR option and the ID variable values. The current ID is Year=1984 and the previous is Year=1983, which are within the same YEAR interval. Check that INTERVAL=YEAR is correct for this data set, and that the ID variable Year contains SAS date or datetime values that correctly identify the observations" So i created new variable date named date using code in ancient post and i used the code to plot data i got "ERROR: The data set WORK.DATA is not sorted by the ID variable. At observation number 36, date=1983, but date=2017 for the previous observation." I sorted the variable by date but when i used code to plot it i got "ERROR: Observation with duplicate ID value found. The value of the ID variable, date=1983, at observation number 2 in data set WORK.DATA is the same as the previous observation."
... View more