Hello, I am trying to do a seasonal adjustment on a data set using procX12.  My error is as follows: ERROR: Interval of date variable does not match INTERVAL=YEAR The data set is an excel document that was properly imported (I know this because I have made a time series plot with the data).   The year is a 4 digit year such as 1999.   My code is as follows: data seasonlogsun; set logsunspots; date=year; format date Year; run; proc x12 data=seasonlogsun date=date interval=year; var logsun; x11; ods select d11; run; Any help would be greatly appreciated. ... View more

I am trying to import a file into SAS.  This is an excel file and I believe my problem is in my filename path, but I do not know how to correct this.  Can anyone help me?  I am going to copy and paste my code and error message.   PROC IMPORT OUT= WORK.B6 DATAFILE= "C:\Users\yakit\OneDrive\Documents\STAT 672 DATA SETS\Data Set B6.xlsx"  DBMS=xlsx REPLACE; GETNAMES=YES; DATAROW=2;  RUN;   Here is my error message: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 62 PROC IMPORT OUT= WORK.yourfile 63 DATAFILE= "C:\Users\yakit\OneDrive\Documents\STAT 672 DATA SETS\Data Set B6.xlsx" 64 DBMS=xlsx REPLACE; 65 GETNAMES=YES; 66 DATAROW=2; 67 RUN;   ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/C:\Users\yakit\OneDrive\Documents\STAT 672 DATA SETS\/Data Set B6.xlsx. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds   68 69 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 82 ... View more