Hello all I have inherited SAS code that has approx. 20 steps and the code had errors throughout. I have been successful in cleaning it up until the last two steps. This is the code for the first one PROC SQL;
CREATE TABLE WORK.AllClaims1 (DROP= Discharge Date Rename= (Discharge Date1= Discharge Date)) AS
SELECT *
,INPUT(Discharge Date,5.) - 21916 AS Discharge Date1 FORMAT= mmddyy10.
FROM WORK.AllClaims
;QUIT; This is the error message I get: 22 76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, -, '.', /, <, <=, <>, =, >, >=, ?, AND, CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=. ERROR 76-322: Syntax error, statement will be ignored. The is the code for the other step DATA AllClaims_Updated;
SET hphc_EOL_FY20 WORK.AllClaims;
RUN; This the error message that I get: ERROR: Variable Age has been defined as both character and numeric. ERROR: Variable BMT has been defined as both character and numeric. These are the two columns that are effected and their types. work.EOL_COHORT Age = Type Numeric, Length 8 BHM = Type Character, Length Character 1 AllCohorts1 Age = Type Character, Length Character 1 BHM = Type Numeric, Length 8 Any assistance with these would be greatly appreciated.
... View more
