75 76 * Log/List Options *; 77 options ls=120 ps=42 missing=' ' nocenter validvarname=upcase compress=binary; 78 * Output SAS Library *; 79 libname etl 'D:\Medicare\05_etl_output\'; NOTE: Libref ETL was successfully assigned as follows: Engine: V9 Physical Name: D:\Medicare\05_etl_output 80 81 82 proc sql; 83 create table cohort2 as 84 select * 85 from etl.inp_claims_lds2013_2014_lejr etl.inp_claims_lds2015_2016_lejr _ 22 200 ERROR 22-322: Syntax error, expecting one of the following: ;, ',', ANSIMISS, CROSS, EXCEPT, FULL, GROUP, HAVING, INNER, INTERSECT, JOIN, LEFT, NATURAL, NOMISS, ORDER, OUTER, RIGHT, UNION, WHERE. ERROR 200-322: The symbol is not recognized and will be ignored. 86 where etl.inp_claims_lds2015_2016_lejr.desy_sort_key in (select _ 22 76 ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, EXCEPT, GE, GET, GROUP, GT, GTT, HAVING, IN, INTERSECT, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ORDER, OUTER, UNION, ^, ^=, |, ||, ~, ~=. ERROR 76-322: Syntax error, statement will be ignored. 87 desy_sort_key from etl.inp_claims_lds2013_2014_lejr); NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 88 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.04 seconds cpu time 0.01 seconds
... View more