Hey
I am connecting through ODBC to oracle DB
This is the error msg
NOTE: Due to the PRESERVE_TAB_NAMES=NO libname option setting, 954
table(s) have not been displayed/returned.
1 proc sql;
2 CREATE TABLE FMEA_BASE AS
3 select orgid,siteid , location,description,assetnum,problemcode,
3 ! FAILURECODE,
4 to_char(faildate,'MM/DD/YYYY') AS FAILDATE,
5 to_char(actstart,'MM/DD/YYYY') AS ACTSTART,
6 to_char(ACTFINISH,'MM/DD/YYYY') AS ACTFINISH,
7 trunc(to_char(faildate- lag(faildate,1) over (partition by assetnum
---- --
22 76
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &,
*, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND,
BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET,
LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
7 ! trunc(to_char(faildate- lag(faildate,1) over (partition by assetnum
--
22
7 ! order by faildate)),2) as TBF_Days,
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &,
(, ), *, **, +, ',', -, '.', /, <, <=, <>, =, >, >=, ?,
AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN,
IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^,
^=, |, ||, ~, ~=.
8 (trunc(to_char(faildate- lag(faildate,1) over (partition by
8 ! assetnum order by faildate)),2))*24 as TBF_Hrs,
9 (trunc(actfinish-actstart,2))*24 as
9 ! TTR_Hrs,(actmatcost+actlabcost+acttoolcost) as FAILURECOST
10 from tva.workorder
11 where classstructureid is not null
12 and location is not null
13 and assetnum is not null
14 and faildate is not null
15 and actstart is not null
16 and actfinish is not null
17 order by assetnum;
18 quit;
I have read a document where i came to know that lag function cannot me used in proc sql;
... View more