Hi
I am getting this error, please advise.
My code is:
proc sql;
create table tk.Summary_allcat as
select
app_type_flag as app_type , AppSystem , State , proposed_ccr as CCR , datestamp
, final_decision as f_decision , F_Medico , SI_Final , FranchiseFlag_F as f_chise_f
, drawn_down_flag as d-downflag
, capacity_refer as capacity ,
collatoral_refer as collatoral , policy_refer as policy , character_refer as character
, ast , bureau , collatoral , affordability as afford , fraud , general ,
internalconduct as int_conduct , purpose , borrower, forcerefer, expense, ac11
, db21, ra03 , db23 , ra01 , rb21 , rb91 , rb95 , rb96 , rc01 , rfxx
, re51, rg01 , rg18 , rg19 , rg15 , rg16, rg17 , ri01, ri02 , ri03 , ri04 ,
ri25, ri31, ri33 , ri45 , ri46 , rp03 , rp06 , rp07 , rp08 , rp10 , rp12 , avxx ,
count(*) as num_apps
,sum(case when final_decision = 'Approved' then 1 else 0 end) as num_appr ,
sum(AMOUNT) as amt_apps,
sum(case when final_decision = 'Approved' then AMOUNT else 0 end) as amt_appr ,
sum(capacity_refer) as Cap_R,
sum(collatoral_refer) as Coll_R,
sum(policy_refer) as Pol_R,
sum(character_refer) as Char_R
,sum(case when final_decision = 'Approved' and ast = 1 then 1 else 0 end) as AST_appr
,sum(case when final_decision = 'Approved' and bureau =1 then 1 else 0 end) as BUREU_appr
,sum(case when final_decision = 'Approved' and collatoral =1 then 1 else 0 end) as COLAT_appr
,sum(case when final_decision = 'Approved' and affordability =1 then 1 else 0 end) as AFORD_appr
,sum(case when final_decision = 'Approved' and fraud =1 then 1 else 0 end) as FRAUD_appr
,sum(case when final_decision = 'Approved' and general =1 then 1 else 0 end) as GEN_appr
,sum(case when final_decision = 'Approved' and internalconduct =1 then 1 else 0 end) as INCON_appr
,sum(case when final_decision = 'Approved' and purpose =1 then 1 else 0 end) as PUR_appr
,sum(case when final_decision = 'Approved' and borrower =1 then 1 else 0 end) as BOROW_appr
,sum(case when final_decision = 'Approved' and forcerefer =1 then 1 else 0 end) as F_FER_appr
,sum(case when final_decision = 'Approved' and expense =1 then 1 else 0 end) as EXPEN_appr
,sum(ast) as Total_AST
,sum(bureau) as T_BUREAU
, sum(collatoral) as T_COLLAT
, sum(affordability) as T_AFFORD
, sum(fraud) as T_FRAUD
, sum(general) as T_GENERAL
, sum(internalconduct) as T_I_CONDT
, sum(purpose) as T_PURPOSE
, sum(borrower) as T_BORROWER
, sum(forcerefer) as T_F_REFER
, sum(expense) as T_EXPENSE
from
tk.SBOS_final1
group by
app_type_flag , capacity_refer , collatoral_refer , policy_refer , character_refer,
ast, bureau , collatoral, affordability, fraud , general , internalconduct , purpose ,
borrower, forcerefer, expense, ac11, db21, ra03 , db23 , ra01 , rb21 , rb91 , rb95 ,
rb96 , rc01 , rfxx , re51, rg01 , rg18 , rg19 , rg15 , rg16, rg17 , ri01, ri02 , ri03
, ri04 , ri25, ri31, ri33 , ri45 , ri46 , rp03 , rp06 , rp07 , rp08 , rp10 , rp12
, avxx, datestamp, final_decision , F_Medico , SI_Final , FranchiseFlag_F ,
AppSystem, State, proposed_ccr, drawn_down_flag
;
quit;
************************************
log error:
GOPTIONS ACCESSIBLE;
15 proc sql;
16 create table tk.Summary_allcat as
17 select
18 app_type_flag as app_type , AppSystem , State , proposed_ccr as CCR , datestamp
19 , final_decision as f_decision , F_Medico , SI_Final , FranchiseFlag_F as f_chise_f
20 , drawn_down_flag as d-downflag
_
78
76
ERROR 78-322: Expecting a ','.
ERROR 76-322: Syntax error, statement will be ignored.
21 , capacity_refer as capacity ,
22 collatoral_refer as collatoral , policy_refer as policy , character_refer as character
23 , ast , bureau , collatoral , affordability as afford , fraud , general ,
24 internalconduct as int_conduct , purpose , borrower, forcerefer, expense, ac11
25 , db21, ra03 , db23 , ra01 , rb21 , rb91 , rb95 , rb96 , rc01 , rfxx
26 , re51, rg01 , rg18 , rg19 , rg15 , rg16, rg17 , ri01, ri02 , ri03 , ri04 ,
27 ri25, ri31, ri33 , ri45 , ri46 , rp03 , rp06 , rp07 , rp08 , rp10 , rp12 , avxx ,
28
29 count(*) as num_apps
30 ,sum(case when final_decision = 'Approved' then 1 else 0 end) as num_appr ,
31 sum(AMOUNT) as amt_apps,
32 sum(case when final_decision = 'Approved' then AMOUNT else 0 end) as amt_appr ,
33
34 sum(capacity_refer) as Cap_R,
35 sum(collatoral_refer) as Coll_R,
36 sum(policy_refer) as Pol_R,
37 sum(character_refer) as Char_R
38
39 ,sum(case when final_decision = 'Approved' and ast = 1 then 1 else 0 end) as AST_appr
40 ,sum(case when final_decision = 'Approved' and bureau =1 then 1 else 0 end) as BUREU_appr
41 ,sum(case when final_decision = 'Approved' and collatoral =1 then 1 else 0 end) as COLAT_appr
42 ,sum(case when final_decision = 'Approved' and affordability =1 then 1 else 0 end) as AFORD_appr
43 ,sum(case when final_decision = 'Approved' and fraud =1 then 1 else 0 end) as FRAUD_appr
44 ,sum(case when final_decision = 'Approved' and general =1 then 1 else 0 end) as GEN_appr
45 ,sum(case when final_decision = 'Approved' and internalconduct =1 then 1 else 0 end) as INCON_appr
46 ,sum(case when final_decision = 'Approved' and purpose =1 then 1 else 0 end) as PUR_appr
2 The SAS System 16:31 Friday, February 23, 2018
47 ,sum(case when final_decision = 'Approved' and borrower =1 then 1 else 0 end) as BOROW_appr
48 ,sum(case when final_decision = 'Approved' and forcerefer =1 then 1 else 0 end) as F_FER_appr
49 ,sum(case when final_decision = 'Approved' and expense =1 then 1 else 0 end) as EXPEN_appr
50
51 ,sum(ast) as Total_AST
52 ,sum(bureau) as T_BUREAU
53 , sum(collatoral) as T_COLLAT
54 , sum(affordability) as T_AFFORD
55 , sum(fraud) as T_FRAUD
56 , sum(general) as T_GENERAL
57 , sum(internalconduct) as T_I_CONDT
58 , sum(purpose) as T_PURPOSE
59 , sum(borrower) as T_BORROWER
60 , sum(forcerefer) as T_F_REFER
61 , sum(expense) as T_EXPENSE
62
63
64 from
65 tk.SBOS_final1
66
67
68 group by
69 app_type_flag , capacity_refer , collatoral_refer , policy_refer , character_refer,
70 ast, bureau , collatoral, affordability, fraud , general , internalconduct , purpose ,
71 borrower, forcerefer, expense, ac11, db21, ra03 , db23 , ra01 , rb21 , rb91 , rb95 ,
72 rb96 , rc01 , rfxx , re51, rg01 , rg18 , rg19 , rg15 , rg16, rg17 , ri01, ri02 , ri03
73 , ri04 , ri25, ri31, ri33 , ri45 , ri46 , rp03 , rp06 , rp07 , rp08 , rp10 , rp12
74 , avxx, datestamp, final_decision , F_Medico , SI_Final , FranchiseFlag_F ,
75 AppSystem, State, proposed_ccr, drawn_down_flag
76
77 ;
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
78 quit;
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
79
80 GOPTIONS NOACCESSIBLE;
81 %LET _CLIENTTASKLABEL=;
82 %LET _CLIENTPROJECTPATH=;
83 %LET _CLIENTPROJECTNAME=;
84 %LET _SASPROGRAMFILE=;
85
86 ;*';*";*/;quit;run;
87 ODS _ALL_ CLOSE;
88
89
90 QUIT; RUN;
91
