1 + proc sql noprint;
1 + create table test1 as select distinct LBTESTCD as testcd length=8, "LB"
as dataset length=8,"LBCAT" as catvar length=8,"LBSCAT" as scatvar length=8,"LBTESTCD" as
testvar length=8,"LBORRES" as resultvar length=8,LBCAT as cat
2 + length=200,LBSCAT as scat length=200,LBTEST as test length=40,
max(length(strip(LBORRES))) as length, case when max(compress(LBORRES)) eq ' ' then 'All
missing' when compress(LBORRES,'1234567890') eq '.' then 'float' when
compress(LBORRES,'1234567890')
3 + eq ' ' then 'integer' when input(LBORRES,anydtdte12.) ne . then 'datetime' else 'text'
end as type, case when calculated type='float' then length(scan(strip(LBORRES),2,'.')) else .
end as sigdig, case when calculated type='float' then (strip(put(length
NOTE: Line generated by the CALL EXECUTE routine.
4 +(LBORRES),best.)) ||"."||strip(put(calculated sigdig,best.)),best.) else . end as format
-
22
76
4 !+from Sdtmdev.LB group by LBCAT,LBSCAT,LBTESTCD,LBTEST; quit;
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, ^, ^=, |, ||, ~, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds Can you please look into log and suggest something to resolve flagged errors? Thanks in advance!
... View more
