Hello, I was wondering if anyone could help me find a solution to this problem. This is the code I'm trying to execute in SAS 9.3: proc sql; create table BE (drop=CUSIP PRC shrout) as select a.*, b.*, b.me as size from comp1 as a LEFT JOIN msex2(drop=RET)as b on a.cusip=b.cusip where (a.fyear+1)=year(b.date)and month(b.date) = 6; run; And when I run it, I get: NOTE: Invalid (or missing) arguments to the YEAR function have caused the function to return a missing value. NOTE: Invalid (or missing) arguments to the MONTH function have caused the function to return a missing value. I've checked the table, I did the summary listing all the available dates and also checked for the missing values. The DATE field in the table has no missing or invalid values. I just can't figure out, why it's giving my this error, Thank you in advance for anyone's input!
... View more