I need help figuring out how to add this SQL code to SAS using proc sql. I get the error messages that are listed below the code. AND lh.CreateDate >= CAST(CONVERT(VARCHAR(8),GETDATE()-1,1) as DATETIME) ERROR: Function VARCHAR could not be located. ERROR: Function GETDATE could not be located. ERROR: Expression using subtraction :smileyminus: requires numeric types. ERROR: Function CONVERT could not be located. ERROR: Function CAST could not be located. ERROR: Expression using greater than or equal (>=) has components that are of different data types. ERROR: The following columns were not found in the contributing tables: DATETIME.
... View more