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
... View more
