About Ronein

Ronein

Hello I want to ask about percent format. The format PCT1 show .0574% but I want it to show 0.0574% The format PCT2 show (.0574%) but I want it to show (0.0574%) Data have; x1=1276; x2=-1276; total=2222151; pct1=x1/total; pct2=x2/total; format pct1 pct2 percent8.5; Run;

Ronein

I dont understand , In my code I used format=percent8.5 What do you recommend me to change here? Do you recommend me use percent8.5 or percentn8.5? data test; length format $50.; length var $50.; format='percentn8.5'; var=put(0.10412456435, percentn8.5); output; format='percent8.5'; var=put(0.10412456435, percent8.5); output; format='percentn8.5'; var=put(-0.10412456435, percentn8.5); output; format='percent8.5'; var=put(-0.10412456435, percent8.5); output; RUN;

Ronein

My question if better to group in data step and then used the grouped vars in summary proc? or use the user defined formats on 300 variables in summary proc?

Ronein

Please note thst in grouping I used different user defined formats .Did Tom used it?

Ronein

The question is- about running time? Which way do you think is lowest running time? Should have significant difference in run time?is proc sql have the history running time??

Ronein

Hello Lets say that I want to run statistics on multiple variables. Lets say that this code is working 100% and I get desired results. My question- Is there better way to write the code (using proc step instead of proc sql)? Please note that in real word I run it on 300 fields and data set has 2 million rows %macro dist(VAR,tbl,level,format); %do j=1 %to 6; %let version=%scan(&Vector_Versions.,&j.,+); proc sql; create table _dist_ as select Left("&VAR.") as Var_name LENGTH=300, put(&VAR.,&Format.) as Cat LENGTH=100, count(*) as nr, calculated nr/(select count(*) as total_nr from &tbl.) as PCT format=percent8.5 from &tbl. group by calculated CAT union all select Left("&VAR.") as Var_name LENGTH=300, 'Total' as CAT, count(*) as nr, 1 as PCT format=percent8.5 from &tbl. ; quit; proc sort data=_dist_; by var_name level cat_order; Run; proc append data=_dist_ base=r_r.Accum_tbl force;quit; %end; %mend dist; %dist(Var=Wealth,tbl=Y_ttt&version.,level=Y,Format=Fmt_1F.) %dist(Var=LoansBalance ,tbl=Y_ttt&version.,level=Y,Format=Fmt_continuous.) %dist(Var=AVG_PAYOFF_LAST_MON,tbl=Y_ttt&version.,level=Y,Format=Fmt_1F.) %dist(Var=HIYUV_EXLISCAR_AMT,tbl=L_ttt&version.,level=L,Format=Fmt_1F.) %macro dist(VAR,tbl,level,format); %do j=1 %to 6; %let version=%scan(&Vector_Versions.,&j.,+); proc sql; create table _dist_ as select Left("&VAR.") as Var_name LENGTH=300, put(&VAR.,&Format.) as Cat LENGTH=100, count(*) as nr, calculated nr/(select count(*) as total_nr from &tbl.) as PCT format=percent8.5 from &tbl. group by calculated CAT union all select Left("&VAR.") as Var_name LENGTH=300, 'Total' as CAT, count(*) as nr, 1 as PCT format=percent8.5 from &tbl. ; quit; proc sort data=_dist_; by var_name level cat_order; Run; proc append data=_dist_ base=r_r.Accum_tbl force;quit; %end; %mend dist; %dist(Var=Wealth,tbl=Y_ttt&version.,level=Y,Format=Fmt_1F.) %dist(Var=LoansBalance ,tbl=Y_ttt&version.,level=Y,Format=Fmt_continuous.) %dist(Var=AVG_PAYOFF_LAST_MON,tbl=Y_ttt&version.,level=Y,Format=Fmt_1F.) %dist(Var=HIYUV_EXLISCAR_AMT,tbl=L_ttt&version.,level=L,Format=Fmt_1F.)

Ronein

So if the program run 1 hour then what should I write there ?? 60???

Ronein

Hello What is the way to create code that run macro based on 2 arguments from data set? The question is actually how to create this code austomatically?(In real word the data set includes many rows so I am looking for a way to run the macro from these values automatically) %RRR(VAR=Wealth ,Format=F1MT ) %RRR(VAR=obligo ,Format=F2MT ) %RRR(VAR=LoansBal ,Format=F3Mt ) %macro RRR(VAR,Format); proc sql; create table a_dist_continuous as select Left("&VAR.") as Var_name LENGTH=300, put(&VAR.,&Format.) as Cat LENGTH=100, count(*) as nr&mon., calculated nr&mon./(select count(*) as total_nr from ttt) as tamhil&mon. format=percent8.2 from ttt group by calculated CAT ; quit; %mend RRR; Data MAcro_need_to_run; infile datalines dsd; input field $ Fmt $; cards; Wealth,F1MT obligo,F2MT LoansBal,F3Mt ; Run; proc format; value F1MT .='(b1) NULL' 0='(b2) 0' 0<-1000='(b3) 0-1K' 1000<-5000='(b4) 1-5K' 5000<-High='(b5) 5K+' Low-<0='(b6) Neg' other='(b7) other' ; Run; proc format; value F2MT 0-100='(b1) POS 0-100' 100<-High='(b2) POS 100+' Low- -100='(b3) Neg_100+' -100 - 0='(b4) Neg_0-100' other='(b5) other' ; Run; proc format; value F3Mt Low-0,.='(a1) 0/Null/Neg' 0<-High='(a2) Pos' ; Run; %RRR(VAR=Wealth ,Format=F1MT ) %RRR(VAR=obligo ,Format=F2MT ) %RRR(VAR=LoansBal ,Format=F3Mt )

Ronein

Hello Lets say I have a sas program that run long time (1 hour). The program should run 48 times (each time with different macro arguments). The final result of the run is update of one permanent data set (This data set is saved in a permanent libarary). Note-Each run update the same data set and add rows to this data set (So this data set is called accumulated data set because each run add it rows) My question- Is it possible that some people run the same sas program (with different macro arguments) ? So ,multiple runs (done by multiple people) update the same data set Is it possible? The idea is to save run time because multiple people run in same time

Ronein

Hello I run this code and get an error what is the problem ? How can i solve it? %MACRO Sort_if_Data_Set_pdgr_Exist; %if %sysfunc(exist(Add.PCS_&mon._Y_pdgr) %then %do; proc sort data=Add.PCS_&mon._Y_pdgr(KEEP=lakoach groupk groupk_befov vct_nm_sibat_or) out=Y_pdgr; by lakoach; Run; %end; %else %do; data Y_pdgr; format lakoach 8. groupk 8. groupk_befov 8. vct_nm_sibat_or $5. ; stop; run; %end; %MEND Sort_if_Data_Set_pdgr_Exist; %Sort_if_Data_Set_pdgr_Exist; LOG 1 The SAS System 08:57 Wednesday, June 4, 2025 ERROR: Macro keyword LET appears as text. ERROR: Macro keyword LET appears as text. 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; ERROR: Macro keyword LET appears as text. 3 %LET _CLIENTTASKLABEL='Program'; ERROR: Macro keyword LET appears as text. 4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project'; ERROR: Macro keyword LET appears as text. 5 %LET _CLIENTPROJECTPATH=''; ERROR: Macro keyword LET appears as text. 6 %LET _CLIENTPROJECTPATHHOST=''; ERROR: Macro keyword LET appears as text. 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; ERROR: Macro keyword MACRO appears as text. 10 11 ODS _ALL_ CLOSE; ERROR: Macro keyword IF appears as text. 12 OPTIONS DEV=SVG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; ERROR: Macro keyword MEND appears as text. 14 %macro HTML5AccessibleGraphSupported; 15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH; 16 %mend; 17 FILENAME EGHTML TEMP; 18 ODS HTML5(ID=EGHTML) FILE=EGHTML 19 OPTIONS(BITMAP_MODE='INLINE') 20 %HTML5AccessibleGraphSupported 21 ENCODING='utf-8' 22 STYLE=HTMLBlue 23 NOGTITLE 24 NOGFOOTNOTE ERROR: Macro keyword MACRO appears as text. 25 GPATH=&sasworklocation 26 ; ERROR: Macro keyword IF appears as text. 27 28 29 %MACRO Sort_if_Data_Set_pdgr_Exist; 30 %if %sysfunc(exist(Add.PCS_&mon._Y_pdgr) %then %do; ERROR: Macro keyword END appears as text. 31 proc sort data=Add.PCS_&mon._Y_pdgr(KEEP=lakoach groupk groupk_befov vct_nm_sibat_or) out=Y_pdgr; ERROR: There is no matching %IF statement for the %ELSE. ERROR: Macro keyword DO appears as text. 32 by lakoach; 33 Run; 34 %end; 35 %else %do; 36 data Y_pdgr; 37 format 38 lakoach 8. 39 groupk 8. 40 groupk_befov 8. ERROR: Macro keyword END appears as text. 41 vct_nm_sibat_or $5. 42 ; 2 The SAS System 08:57 Wednesday, June 4, 2025 ERROR: Macro keyword MEND appears as text. 43 stop; 44 run; 45 %end; ERROR: Macro keyword LET appears as text. 46 %MEND Sort_if_Data_Set_pdgr_Exist; ERROR: Macro keyword LET appears as text. 47 %Sort_if_Data_Set_pdgr_Exist; 48 ERROR: Macro keyword LET appears as text. 49 %LET _CLIENTTASKLABEL=; ERROR: Macro keyword LET appears as text. 50 %LET _CLIENTPROCESSFLOWNAME=; ERROR: Macro keyword LET appears as text. 51 %LET _CLIENTPROJECTPATH=; ERROR: Macro keyword LET appears as text. 52 %LET _CLIENTPROJECTPATHHOST=; ERROR: Macro keyword LET appears as text. 53 %LET _CLIENTPROJECTNAME=; 54 %LET _SASPROGRAMFILE=; 55 %LET _SASPROGRAMFILEHOST=; 56 57 ;*';*";*/;quit;run; 58 ODS _ALL_ CLOSE; 59 60 61 QUIT; RUN; 62

Ronein

Thank you

Ronein

Thanks! Can you please show the full code that identify automatically var type and create the code that make the required calculations? Also- the distinguish between continous and count was made by me and how sas know to distinguish between them???

Ronein

My question was IF there is a more clever and short code to run this: Here I have for each var a separate code. since it is proc sql then I dont know to use array here / Any idea how to write it in a better way? proc sql; create table t_contunous_CONUT_Vars as SELECT ' Case_Id ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Case_Id) AS SUM,nmiss( Case_Id) AS Nr_Null,SUM(Case_Id=0) AS Nr_0,SUM(Case_Id>0) AS Nr_POS,SUM(Case_Id<0 AND Case_Id ne .) AS nr_neg from ttt union all SELECT ' Avg_Payoff ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Avg_Payoff_Last_Month) AS SUM,nmiss( Avg_Payoff_Last_Month) AS Nr_Null,SUM(Avg_Payoff_Last_Month=0) AS Nr_0,SUM(Avg_Payoff_Last_Month>0) AS Nr_POS,SUM(Avg_Payoff_Last_Month<0 AND Avg_Payoff_Last_Month ne .) AS nr_neg from ttt union all SELECT ' Sum_Mortage ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Mortage_Last_Month) AS SUM,nmiss( Sum_Mortage_Last_Month) AS Nr_Null,SUM(Sum_Mortage_Last_Month=0) AS Nr_0,SUM(Sum_Mortage_Last_Month>0) AS Nr_POS,SUM(Sum_Mortage_Last_Month<0 AND Sum_Mortage_Last_Month ne .) AS nr_neg from ttt union all SELECT ' Sum_Mortage' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Mortage_Last_Month_) AS SUM,nmiss( Sum_Mortage_Last_Month_) AS Nr_Null,SUM(Sum_Mortage_Last_Month_=0) AS Nr_0,SUM(Sum_Mortage_Last_Month_>0) AS Nr_POS,SUM(Sum_Mortage_Last_Month_<0 AND Sum_Mortage_Last_Month_ ne .) AS nr_neg from ttt union all SELECT ' Sum_Checs ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Checs) AS SUM,nmiss( Sum_Checs) AS Nr_Null,SUM(Sum_Checs=0) AS Nr_0,SUM(Sum_Checs>0) AS Nr_POS,SUM(Sum_Checs<0 AND Sum_Checs ne .) AS nr_neg from ttt union all SELECT ' Sum_Cash ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Cash) AS SUM,nmiss( Sum_Cash) AS Nr_Null,SUM(Sum_Cash=0) AS Nr_0,SUM(Sum_Cash>0) AS Nr_POS,SUM(Sum_Cash<0 AND Sum_Cash ne .) AS nr_neg from ttt union all SELECT ' Sum_Transfer ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Transfer) AS SUM,nmiss( Sum_Transfer) AS Nr_Null,SUM(Sum_Transfer=0) AS Nr_0,SUM(Sum_Transfer>0) AS Nr_POS,SUM(Sum_Transfer<0 AND Sum_Transfer ne .) AS nr_neg from ttt union all SELECT ' Sum_Transfer_Same_Inv ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Transfer_Same_Inv) AS SUM,nmiss( Sum_Transfer_Same_Inv) AS Nr_Null,SUM(Sum_Transfer_Same_Inv=0) AS Nr_0,SUM(Sum_Transfer_Same_Inv>0) AS Nr_POS,SUM(Sum_Transfer_Same_Inv<0 AND Sum_Transfer_Same_Inv ne .) AS nr_neg from ttt union all SELECT ' Sum_G_Credit ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_G_Credit) AS SUM,nmiss( Sum_G_Credit) AS Nr_Null,SUM(Sum_G_Credit=0) AS Nr_0,SUM(Sum_G_Credit>0) AS Nr_POS,SUM(Sum_G_Credit<0 AND Sum_G_Credit ne .) AS nr_neg from ttt union all SELECT ' Sum_Checs_Debit ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Checs_Debit) AS SUM,nmiss( Sum_Checs_Debit) AS Nr_Null,SUM(Sum_Checs_Debit=0) AS Nr_0,SUM(Sum_Checs_Debit>0) AS Nr_POS,SUM(Sum_Checs_Debit<0 AND Sum_Checs_Debit ne .) AS nr_neg from ttt union all SELECT ' Sum_Cash_Debit ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Cash_Debit) AS SUM,nmiss( Sum_Cash_Debit) AS Nr_Null,SUM(Sum_Cash_Debit=0) AS Nr_0,SUM(Sum_Cash_Debit>0) AS Nr_POS,SUM(Sum_Cash_Debit<0 AND Sum_Cash_Debit ne .) AS nr_neg from ttt union all SELECT ' Sum_Transfer_Debit ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Transfer_Debit) AS SUM,nmiss( Sum_Transfer_Debit) AS Nr_Null,SUM(Sum_Transfer_Debit=0) AS Nr_0,SUM(Sum_Transfer_Debit>0) AS Nr_POS,SUM(Sum_Transfer_Debit<0 AND Sum_Transfer_Debit ne .) AS nr_neg from ttt union all SELECT ' Sum_Transfer_Debit_Same_I ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Transfer_Debit_Same_I) AS SUM,nmiss( Sum_Transfer_Debit_Same_I) AS Nr_Null,SUM(Sum_Transfer_Debit_Same_I=0) AS Nr_0,SUM(Sum_Transfer_Debit_Same_I>0) AS Nr_POS,SUM(Sum_Transfer_Debit_Same_I<0 AND Sum_Transfer_Debit_Same_I ne .) AS nr_neg from ttt union all SELECT ' Sum_Loans_Last_Month_Nashaf ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Loans_Last_Month_Nashaf) AS SUM,nmiss( Sum_Loans_Last_Month_Nashaf) AS Nr_Null,SUM(Sum_Loans_Last_Month_Nashaf=0) AS Nr_0,SUM(Sum_Loans_Last_Month_Nashaf>0) AS Nr_POS,SUM(Sum_Loans_Last_Month_Nashaf<0 AND Sum_Loans_Last_Month_Nashaf ne .) AS nr_neg from ttt union all SELECT ' Sum_Cc_M_1 ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Cc_M_1) AS SUM,nmiss( Sum_Cc_M_1) AS Nr_Null,SUM(Sum_Cc_M_1=0) AS Nr_0,SUM(Sum_Cc_M_1>0) AS Nr_POS,SUM(Sum_Cc_M_1<0 AND Sum_Cc_M_1 ne .) AS nr_neg from ttt union all SELECT ' Sum_Cc_M_2 ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Cc_M_2) AS SUM,nmiss( Sum_Cc_M_2) AS Nr_Null,SUM(Sum_Cc_M_2=0) AS Nr_0,SUM(Sum_Cc_M_2>0) AS Nr_POS,SUM(Sum_Cc_M_2<0 AND Sum_Cc_M_2 ne .) AS nr_neg from ttt union all SELECT ' Sum_Cc_M_3 ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Cc_M_3) AS SUM,nmiss( Sum_Cc_M_3) AS Nr_Null,SUM(Sum_Cc_M_3=0) AS Nr_0,SUM(Sum_Cc_M_3>0) AS Nr_POS,SUM(Sum_Cc_M_3<0 AND Sum_Cc_M_3 ne .) AS nr_neg from ttt union all SELECT ' Sum_Cc_M_4 ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Cc_M_4) AS SUM,nmiss( Sum_Cc_M_4) AS Nr_Null,SUM(Sum_Cc_M_4=0) AS Nr_0,SUM(Sum_Cc_M_4>0) AS Nr_POS,SUM(Sum_Cc_M_4<0 AND Sum_Cc_M_4 ne .) AS nr_neg from ttt union all SELECT ' Sum_Cc_M_5 ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Cc_M_5) AS SUM,nmiss( Sum_Cc_M_5) AS Nr_Null,SUM(Sum_Cc_M_5=0) AS Nr_0,SUM(Sum_Cc_M_5>0) AS Nr_POS,SUM(Sum_Cc_M_5<0 AND Sum_Cc_M_5 ne .) AS nr_neg from ttt union all SELECT ' Loan_Exbank_Amt ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Loan_Exbank_Amt) AS SUM,nmiss( Loan_Exbank_Amt) AS Nr_Null,SUM(Loan_Exbank_Amt=0) AS Nr_0,SUM(Loan_Exbank_Amt>0) AS Nr_POS,SUM(Loan_Exbank_Amt<0 AND Loan_Exbank_Amt ne .) AS nr_neg from ttt union all SELECT ' Hiyuv_Exbank_Amt ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Hiyuv_Exbank_Amt) AS SUM,nmiss( Hiyuv_Exbank_Amt) AS Nr_Null,SUM(Hiyuv_Exbank_Amt=0) AS Nr_0,SUM(Hiyuv_Exbank_Amt>0) AS Nr_POS,SUM(Hiyuv_Exbank_Amt<0 AND Hiyuv_Exbank_Amt ne .) AS nr_neg from ttt union all SELECT ' Loan_Excard_Amt ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Loan_Excard_Amt) AS SUM,nmiss( Loan_Excard_Amt) AS Nr_Null,SUM(Loan_Excard_Amt=0) AS Nr_0,SUM(Loan_Excard_Amt>0) AS Nr_POS,SUM(Loan_Excard_Amt<0 AND Loan_Excard_Amt ne .) AS nr_neg from ttt union all SELECT ' Hiyuv_Excard_Amt ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Hiyuv_Excard_Amt) AS SUM,nmiss( Hiyuv_Excard_Amt) AS Nr_Null,SUM(Hiyuv_Excard_Amt=0) AS Nr_0,SUM(Hiyuv_Excard_Amt>0) AS Nr_POS,SUM(Hiyuv_Excard_Amt<0 AND Hiyuv_Excard_Amt ne .) AS nr_neg from ttt union all SELECT ' Loan_EM_Amt ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Loan_EM_Amt) AS SUM,nmiss( Loan_EM_Amt) AS Nr_Null,SUM(Loan_EM_Amt=0) AS Nr_0,SUM(Loan_EM_Amt>0) AS Nr_POS,SUM(Loan_EM_Amt<0 AND Loan_EM_Amt ne .) AS nr_neg from ttt union all SELECT ' Hiyuv_EM_Amt ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Hiyuv_EM_Amt) AS SUM,nmiss( Hiyuv_EM_Amt) AS Nr_Null,SUM(Hiyuv_EM_Amt=0) AS Nr_0,SUM(Hiyuv_EM_Amt>0) AS Nr_POS,SUM(Hiyuv_EM_Amt<0 AND Hiyuv_EM_Amt ne .) AS nr_neg from ttt union all SELECT ' Loan_Exliscar_Amt ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Loan_Exliscar_Amt) AS SUM,nmiss( Loan_Exliscar_Amt) AS Nr_Null,SUM(Loan_Exliscar_Amt=0) AS Nr_0,SUM(Loan_Exliscar_Amt>0) AS Nr_POS,SUM(Loan_Exliscar_Amt<0 AND Loan_Exliscar_Amt ne .) AS nr_neg from ttt union all SELECT ' Hiyuv_Exliscar_Amt ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Hiyuv_Exliscar_Amt) AS SUM,nmiss( Hiyuv_Exliscar_Amt) AS Nr_Null,SUM(Hiyuv_Exliscar_Amt=0) AS Nr_0,SUM(Hiyuv_Exliscar_Amt>0) AS Nr_POS,SUM(Hiyuv_Exliscar_Amt<0 AND Hiyuv_Exliscar_Amt ne .) AS nr_neg from ttt union all SELECT ' Sum_Mortage_L_Month_Mosdi ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Mortage_L_Month_Mosdi) AS SUM,nmiss( Sum_Mortage_L_Month_Mosdi) AS Nr_Null,SUM(Sum_Mortage_L_Month_Mosdi=0) AS Nr_0,SUM(Sum_Mortage_L_Month_Mosdi>0) AS Nr_POS,SUM(Sum_Mortage_L_Month_Mosdi<0 AND Sum_Mortage_L_Month_Mosdi ne .) AS nr_neg from ttt union all SELECT ' Avg_Payoff_Last_Month_Nashaf ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Avg_Payoff_Last_Month_Nashaf) AS SUM,nmiss( Avg_Payoff_Last_Month_Nashaf) AS Nr_Null,SUM(Avg_Payoff_Last_Month_Nashaf=0) AS Nr_0,SUM(Avg_Payoff_Last_Month_Nashaf>0) AS Nr_POS,SUM(Avg_Payoff_Last_Month_Nashaf<0 AND Avg_Payoff_Last_Month_Nashaf ne .) AS nr_neg from ttt union all SELECT ' Sum_T_Shuvar ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_T_Shuvar) AS SUM,nmiss( Sum_T_Shuvar) AS Nr_Null,SUM(Sum_T_Shuvar=0) AS Nr_0,SUM(Sum_T_Shuvar>0) AS Nr_POS,SUM(Sum_T_Shuvar<0 AND Sum_T_Shuvar ne .) AS nr_neg from ttt union all SELECT ' Sum_Loans_Nashaf_Real ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Loans_Nashaf_Real) AS SUM,nmiss( Sum_Loans_Nashaf_Real) AS Nr_Null,SUM(Sum_Loans_Nashaf_Real=0) AS Nr_0,SUM(Sum_Loans_Nashaf_Real>0) AS Nr_POS,SUM(Sum_Loans_Nashaf_Real<0 AND Sum_Loans_Nashaf_Real ne .) AS nr_neg from ttt union all SELECT ' Sum_Loans_G_Real ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Loans_G_Real) AS SUM,nmiss( Sum_Loans_G_Real) AS Nr_Null,SUM(Sum_Loans_G_Real=0) AS Nr_0,SUM(Sum_Loans_G_Real>0) AS Nr_POS,SUM(Sum_Loans_G_Real<0 AND Sum_Loans_G_Real ne .) AS nr_neg from ttt union all SELECT ' Sum_Matach_Credit ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Matach_Credit) AS SUM,nmiss( Sum_Matach_Credit) AS Nr_Null,SUM(Sum_Matach_Credit=0) AS Nr_0,SUM(Sum_Matach_Credit>0) AS Nr_POS,SUM(Sum_Matach_Credit<0 AND Sum_Matach_Credit ne .) AS nr_neg from ttt union all SELECT ' Sum_Matach_Debit ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Matach_Debit) AS SUM,nmiss( Sum_Matach_Debit) AS Nr_Null,SUM(Sum_Matach_Debit=0) AS Nr_0,SUM(Sum_Matach_Debit>0) AS Nr_POS,SUM(Sum_Matach_Debit<0 AND Sum_Matach_Debit ne .) AS nr_neg from ttt union all SELECT ' Sum_Transosher_Debit ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Transosher_Debit) AS SUM,nmiss( Sum_Transosher_Debit) AS Nr_Null,SUM(Sum_Transosher_Debit=0) AS Nr_0,SUM(Sum_Transosher_Debit>0) AS Nr_POS,SUM(Sum_Transosher_Debit<0 AND Sum_Transosher_Debit ne .) AS nr_neg from ttt union all SELECT ' Sum_Transosher_Credit ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Transosher_Credit) AS SUM,nmiss( Sum_Transosher_Credit) AS Nr_Null,SUM(Sum_Transosher_Credit=0) AS Nr_0,SUM(Sum_Transosher_Credit>0) AS Nr_POS,SUM(Sum_Transosher_Credit<0 AND Sum_Transosher_Credit ne .) AS nr_neg from ttt union all SELECT ' Sum_Cc_M_12 ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Cc_M_12) AS SUM,nmiss( Sum_Cc_M_12) AS Nr_Null,SUM(Sum_Cc_M_12=0) AS Nr_0,SUM(Sum_Cc_M_12>0) AS Nr_POS,SUM(Sum_Cc_M_12<0 AND Sum_Cc_M_12 ne .) AS nr_neg from ttt union all SELECT ' Sum_Cc_M_13 ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Cc_M_13) AS SUM,nmiss( Sum_Cc_M_13) AS Nr_Null,SUM(Sum_Cc_M_13=0) AS Nr_0,SUM(Sum_Cc_M_13>0) AS Nr_POS,SUM(Sum_Cc_M_13<0 AND Sum_Cc_M_13 ne .) AS nr_neg from ttt union all SELECT ' Sum_Cc_M_14 ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Cc_M_14) AS SUM,nmiss( Sum_Cc_M_14) AS Nr_Null,SUM(Sum_Cc_M_14=0) AS Nr_0,SUM(Sum_Cc_M_14>0) AS Nr_POS,SUM(Sum_Cc_M_14<0 AND Sum_Cc_M_14 ne .) AS nr_neg from ttt union all SELECT ' Sum_Cc_M_15 ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Cc_M_15) AS SUM,nmiss( Sum_Cc_M_15) AS Nr_Null,SUM(Sum_Cc_M_15=0) AS Nr_0,SUM(Sum_Cc_M_15>0) AS Nr_POS,SUM(Sum_Cc_M_15<0 AND Sum_Cc_M_15 ne .) AS nr_neg from ttt union all SELECT ' Sum_Nizcard_Cdo ' AS FIELD, 'continuous' as type,COUNT(*) AS NR_TOTAL,SUM(Sum_Nizcard_Cdo) AS SUM,nmiss( Sum_Nizcard_Cdo) AS Nr_Null,SUM(Sum_Nizcard_Cdo=0) AS Nr_0,SUM(Sum_Nizcard_Cdo>0) AS Nr_POS,SUM(Sum_Nizcard_Cdo<0 AND Sum_Nizcard_Cdo ne .) AS nr_neg from ttt union all SELECT ' Nlp_Grp ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Nlp_Grp) AS SUM,nmiss( Nlp_Grp) AS Nr_Null,SUM(Nlp_Grp=0) AS Nr_0,SUM(Nlp_Grp>0) AS Nr_POS,SUM(Nlp_Grp<0 AND Nlp_Grp ne .) AS nr_neg from ttt union all SELECT ' Count_Mortage_Last_Month ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Mortage_Last_Month) AS SUM,nmiss( Count_Mortage_Last_Month) AS Nr_Null,SUM(Count_Mortage_Last_Month=0) AS Nr_0,SUM(Count_Mortage_Last_Month>0) AS Nr_POS,SUM(Count_Mortage_Last_Month<0 AND Count_Mortage_Last_Month ne .) AS nr_neg from ttt union all SELECT ' Count_Mortage_Last_Month_ ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Mortage_Last_Month_) AS SUM,nmiss( Count_Mortage_Last_Month_) AS Nr_Null,SUM(Count_Mortage_Last_Month_=0) AS Nr_0,SUM(Count_Mortage_Last_Month_>0) AS Nr_POS,SUM(Count_Mortage_Last_Month_<0 AND Count_Mortage_Last_Month_ ne .) AS nr_neg from ttt union all SELECT ' Count_Checs ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Checs) AS SUM,nmiss( Count_Checs) AS Nr_Null,SUM(Count_Checs=0) AS Nr_0,SUM(Count_Checs>0) AS Nr_POS,SUM(Count_Checs<0 AND Count_Checs ne .) AS nr_neg from ttt union all SELECT ' Count_Cash ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cash) AS SUM,nmiss( Count_Cash) AS Nr_Null,SUM(Count_Cash=0) AS Nr_0,SUM(Count_Cash>0) AS Nr_POS,SUM(Count_Cash<0 AND Count_Cash ne .) AS nr_neg from ttt union all SELECT ' Count_Transfer ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Transfer) AS SUM,nmiss( Count_Transfer) AS Nr_Null,SUM(Count_Transfer=0) AS Nr_0,SUM(Count_Transfer>0) AS Nr_POS,SUM(Count_Transfer<0 AND Count_Transfer ne .) AS nr_neg from ttt union all SELECT ' Count_Transfer_Same_Inv ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Transfer_Same_Inv) AS SUM,nmiss( Count_Transfer_Same_Inv) AS Nr_Null,SUM(Count_Transfer_Same_Inv=0) AS Nr_0,SUM(Count_Transfer_Same_Inv>0) AS Nr_POS,SUM(Count_Transfer_Same_Inv<0 AND Count_Transfer_Same_Inv ne .) AS nr_neg from ttt union all SELECT ' Count_G_Credit ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_G_Credit) AS SUM,nmiss( Count_G_Credit) AS Nr_Null,SUM(Count_G_Credit=0) AS Nr_0,SUM(Count_G_Credit>0) AS Nr_POS,SUM(Count_G_Credit<0 AND Count_G_Credit ne .) AS nr_neg from ttt union all SELECT ' Count_Checs_Debit ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Checs_Debit) AS SUM,nmiss( Count_Checs_Debit) AS Nr_Null,SUM(Count_Checs_Debit=0) AS Nr_0,SUM(Count_Checs_Debit>0) AS Nr_POS,SUM(Count_Checs_Debit<0 AND Count_Checs_Debit ne .) AS nr_neg from ttt union all SELECT ' Count_Cash_Debit ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cash_Debit) AS SUM,nmiss( Count_Cash_Debit) AS Nr_Null,SUM(Count_Cash_Debit=0) AS Nr_0,SUM(Count_Cash_Debit>0) AS Nr_POS,SUM(Count_Cash_Debit<0 AND Count_Cash_Debit ne .) AS nr_neg from ttt union all SELECT ' Count_Transfer_Debit ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Transfer_Debit) AS SUM,nmiss( Count_Transfer_Debit) AS Nr_Null,SUM(Count_Transfer_Debit=0) AS Nr_0,SUM(Count_Transfer_Debit>0) AS Nr_POS,SUM(Count_Transfer_Debit<0 AND Count_Transfer_Debit ne .) AS nr_neg from ttt union all SELECT ' Count_Transfer_Debit_Same ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Transfer_Debit_Same) AS SUM,nmiss( Count_Transfer_Debit_Same) AS Nr_Null,SUM(Count_Transfer_Debit_Same=0) AS Nr_0,SUM(Count_Transfer_Debit_Same>0) AS Nr_POS,SUM(Count_Transfer_Debit_Same<0 AND Count_Transfer_Debit_Same ne .) AS nr_neg from ttt union all SELECT ' Count_G_Debit ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_G_Debit) AS SUM,nmiss( Count_G_Debit) AS Nr_Null,SUM(Count_G_Debit=0) AS Nr_0,SUM(Count_G_Debit>0) AS Nr_POS,SUM(Count_G_Debit<0 AND Count_G_Debit ne .) AS nr_neg from ttt union all SELECT ' Count_Loans_Last_Month_Nashaf ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Loans_Last_Month_Nashaf) AS SUM,nmiss( Count_Loans_Last_Month_Nashaf) AS Nr_Null,SUM(Count_Loans_Last_Month_Nashaf=0) AS Nr_0,SUM(Count_Loans_Last_Month_Nashaf>0) AS Nr_POS,SUM(Count_Loans_Last_Month_Nashaf<0 AND Count_Loans_Last_Month_Nashaf ne .) AS nr_neg from ttt union all SELECT ' Count_Cc_M_1 ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cc_M_1) AS SUM,nmiss( Count_Cc_M_1) AS Nr_Null,SUM(Count_Cc_M_1=0) AS Nr_0,SUM(Count_Cc_M_1>0) AS Nr_POS,SUM(Count_Cc_M_1<0 AND Count_Cc_M_1 ne .) AS nr_neg from ttt union all SELECT ' Count_Cc_M_2 ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cc_M_2) AS SUM,nmiss( Count_Cc_M_2) AS Nr_Null,SUM(Count_Cc_M_2=0) AS Nr_0,SUM(Count_Cc_M_2>0) AS Nr_POS,SUM(Count_Cc_M_2<0 AND Count_Cc_M_2 ne .) AS nr_neg from ttt union all SELECT ' Count_Cc_M_3 ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cc_M_3) AS SUM,nmiss( Count_Cc_M_3) AS Nr_Null,SUM(Count_Cc_M_3=0) AS Nr_0,SUM(Count_Cc_M_3>0) AS Nr_POS,SUM(Count_Cc_M_3<0 AND Count_Cc_M_3 ne .) AS nr_neg from ttt union all SELECT ' Count_Cc_M_4 ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cc_M_4) AS SUM,nmiss( Count_Cc_M_4) AS Nr_Null,SUM(Count_Cc_M_4=0) AS Nr_0,SUM(Count_Cc_M_4>0) AS Nr_POS,SUM(Count_Cc_M_4<0 AND Count_Cc_M_4 ne .) AS nr_neg from ttt union all SELECT ' Count_Cc_M_5 ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cc_M_5) AS SUM,nmiss( Count_Cc_M_5) AS Nr_Null,SUM(Count_Cc_M_5=0) AS Nr_0,SUM(Count_Cc_M_5>0) AS Nr_POS,SUM(Count_Cc_M_5<0 AND Count_Cc_M_5 ne .) AS nr_neg from ttt union all SELECT ' Count_Cc_M_6 ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cc_M_6) AS SUM,nmiss( Count_Cc_M_6) AS Nr_Null,SUM(Count_Cc_M_6=0) AS Nr_0,SUM(Count_Cc_M_6>0) AS Nr_POS,SUM(Count_Cc_M_6<0 AND Count_Cc_M_6 ne .) AS nr_neg from ttt union all SELECT ' Count_Cc_M_7 ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cc_M_7) AS SUM,nmiss( Count_Cc_M_7) AS Nr_Null,SUM(Count_Cc_M_7=0) AS Nr_0,SUM(Count_Cc_M_7>0) AS Nr_POS,SUM(Count_Cc_M_7<0 AND Count_Cc_M_7 ne .) AS nr_neg from ttt union all SELECT ' Count_Cc_M_8 ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cc_M_8) AS SUM,nmiss( Count_Cc_M_8) AS Nr_Null,SUM(Count_Cc_M_8=0) AS Nr_0,SUM(Count_Cc_M_8>0) AS Nr_POS,SUM(Count_Cc_M_8<0 AND Count_Cc_M_8 ne .) AS nr_neg from ttt union all SELECT ' Count_Cc_M_9 ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cc_M_9) AS SUM,nmiss( Count_Cc_M_9) AS Nr_Null,SUM(Count_Cc_M_9=0) AS Nr_0,SUM(Count_Cc_M_9>0) AS Nr_POS,SUM(Count_Cc_M_9<0 AND Count_Cc_M_9 ne .) AS nr_neg from ttt union all SELECT ' Count_Cc_M_10 ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cc_M_10) AS SUM,nmiss( Count_Cc_M_10) AS Nr_Null,SUM(Count_Cc_M_10=0) AS Nr_0,SUM(Count_Cc_M_10>0) AS Nr_POS,SUM(Count_Cc_M_10<0 AND Count_Cc_M_10 ne .) AS nr_neg from ttt union all SELECT ' Count_Cc_M_11 ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cc_M_11) AS SUM,nmiss( Count_Cc_M_11) AS Nr_Null,SUM(Count_Cc_M_11=0) AS Nr_0,SUM(Count_Cc_M_11>0) AS Nr_POS,SUM(Count_Cc_M_11<0 AND Count_Cc_M_11 ne .) AS nr_neg from ttt union all SELECT ' Loan_Exbank_Cnt ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Loan_Exbank_Cnt) AS SUM,nmiss( Loan_Exbank_Cnt) AS Nr_Null,SUM(Loan_Exbank_Cnt=0) AS Nr_0,SUM(Loan_Exbank_Cnt>0) AS Nr_POS,SUM(Loan_Exbank_Cnt<0 AND Loan_Exbank_Cnt ne .) AS nr_neg from ttt union all SELECT ' Hiyuv_Exbank_Cnt ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Hiyuv_Exbank_Cnt) AS SUM,nmiss( Hiyuv_Exbank_Cnt) AS Nr_Null,SUM(Hiyuv_Exbank_Cnt=0) AS Nr_0,SUM(Hiyuv_Exbank_Cnt>0) AS Nr_POS,SUM(Hiyuv_Exbank_Cnt<0 AND Hiyuv_Exbank_Cnt ne .) AS nr_neg from ttt union all SELECT ' Loan_Excard_Cnt ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Loan_Excard_Cnt) AS SUM,nmiss( Loan_Excard_Cnt) AS Nr_Null,SUM(Loan_Excard_Cnt=0) AS Nr_0,SUM(Loan_Excard_Cnt>0) AS Nr_POS,SUM(Loan_Excard_Cnt<0 AND Loan_Excard_Cnt ne .) AS nr_neg from ttt union all SELECT ' Hiyuv_Excard_Cnt ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Hiyuv_Excard_Cnt) AS SUM,nmiss( Hiyuv_Excard_Cnt) AS Nr_Null,SUM(Hiyuv_Excard_Cnt=0) AS Nr_0,SUM(Hiyuv_Excard_Cnt>0) AS Nr_POS,SUM(Hiyuv_Excard_Cnt<0 AND Hiyuv_Excard_Cnt ne .) AS nr_neg from ttt union all SELECT ' Loan_EM_Cnt ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Loan_EM_Cnt) AS SUM,nmiss( Loan_EM_Cnt) AS Nr_Null,SUM(Loan_EM_Cnt=0) AS Nr_0,SUM(Loan_EM_Cnt>0) AS Nr_POS,SUM(Loan_EM_Cnt<0 AND Loan_EM_Cnt ne .) AS nr_neg from ttt union all SELECT ' Hiyuv_EM_Cnt ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Hiyuv_EM_Cnt) AS SUM,nmiss( Hiyuv_EM_Cnt) AS Nr_Null,SUM(Hiyuv_EM_Cnt=0) AS Nr_0,SUM(Hiyuv_EM_Cnt>0) AS Nr_POS,SUM(Hiyuv_EM_Cnt<0 AND Hiyuv_EM_Cnt ne .) AS nr_neg from ttt union all SELECT ' Loan_Exliscar_Cnt ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Loan_Exliscar_Cnt) AS SUM,nmiss( Loan_Exliscar_Cnt) AS Nr_Null,SUM(Loan_Exliscar_Cnt=0) AS Nr_0,SUM(Loan_Exliscar_Cnt>0) AS Nr_POS,SUM(Loan_Exliscar_Cnt<0 AND Loan_Exliscar_Cnt ne .) AS nr_neg from ttt union all SELECT ' Hiyuv_Exliscar_Cnt ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Hiyuv_Exliscar_Cnt) AS SUM,nmiss( Hiyuv_Exliscar_Cnt) AS Nr_Null,SUM(Hiyuv_Exliscar_Cnt=0) AS Nr_0,SUM(Hiyuv_Exliscar_Cnt>0) AS Nr_POS,SUM(Hiyuv_Exliscar_Cnt<0 AND Hiyuv_Exliscar_Cnt ne .) AS nr_neg from ttt union all SELECT ' Cnt_Mortage_L_Month_Mosdi ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Cnt_Mortage_L_Month_Mosdi) AS SUM,nmiss( Cnt_Mortage_L_Month_Mosdi) AS Nr_Null,SUM(Cnt_Mortage_L_Month_Mosdi=0) AS Nr_0,SUM(Cnt_Mortage_L_Month_Mosdi>0) AS Nr_POS,SUM(Cnt_Mortage_L_Month_Mosdi<0 AND Cnt_Mortage_L_Month_Mosdi ne .) AS nr_neg from ttt union all SELECT ' Cnt_Payoff_Last_Month_Nashaf ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Cnt_Payoff_Last_Month_Nashaf) AS SUM,nmiss( Cnt_Payoff_Last_Month_Nashaf) AS Nr_Null,SUM(Cnt_Payoff_Last_Month_Nashaf=0) AS Nr_0,SUM(Cnt_Payoff_Last_Month_Nashaf>0) AS Nr_POS,SUM(Cnt_Payoff_Last_Month_Nashaf<0 AND Cnt_Payoff_Last_Month_Nashaf ne .) AS nr_neg from ttt union all SELECT ' Count_Cc_M_12 ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cc_M_12) AS SUM,nmiss( Count_Cc_M_12) AS Nr_Null,SUM(Count_Cc_M_12=0) AS Nr_0,SUM(Count_Cc_M_12>0) AS Nr_POS,SUM(Count_Cc_M_12<0 AND Count_Cc_M_12 ne .) AS nr_neg from ttt union all SELECT ' Count_Cc_M_13 ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cc_M_13) AS SUM,nmiss( Count_Cc_M_13) AS Nr_Null,SUM(Count_Cc_M_13=0) AS Nr_0,SUM(Count_Cc_M_13>0) AS Nr_POS,SUM(Count_Cc_M_13<0 AND Count_Cc_M_13 ne .) AS nr_neg from ttt union all SELECT ' Count_Cc_M_14 ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cc_M_14) AS SUM,nmiss( Count_Cc_M_14) AS Nr_Null,SUM(Count_Cc_M_14=0) AS Nr_0,SUM(Count_Cc_M_14>0) AS Nr_POS,SUM(Count_Cc_M_14<0 AND Count_Cc_M_14 ne .) AS nr_neg from ttt union all SELECT ' Count_Cc_M_15 ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Count_Cc_M_15) AS SUM,nmiss( Count_Cc_M_15) AS Nr_Null,SUM(Count_Cc_M_15=0) AS Nr_0,SUM(Count_Cc_M_15>0) AS Nr_POS,SUM(Count_Cc_M_15<0 AND Count_Cc_M_15 ne .) AS nr_neg from ttt union all SELECT ' Risk_Score ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(Risk_Score) AS SUM,nmiss( Risk_Score) AS Nr_Null,SUM(Risk_Score=0) AS Nr_0,SUM(Risk_Score>0) AS Nr_POS,SUM(Risk_Score<0 AND Risk_Score ne .) AS nr_neg from ttt union all SELECT ' E_Exbank ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(E_Exbank) AS SUM,nmiss( E_Exbank) AS Nr_Null,SUM(E_Exbank=0) AS Nr_0,SUM(E_Exbank>0) AS Nr_POS,SUM(E_Exbank<0 AND E_Exbank ne .) AS nr_neg from ttt union all SELECT ' E_EM ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(E_EM) AS SUM,nmiss( E_EM) AS Nr_Null,SUM(E_EM=0) AS Nr_0,SUM(E_EM>0) AS Nr_POS,SUM(E_EM<0 AND E_EM ne .) AS nr_neg from ttt union all SELECT ' E_Excard ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(E_Excard) AS SUM,nmiss( E_Excard) AS Nr_Null,SUM(E_Excard=0) AS Nr_0,SUM(E_Excard>0) AS Nr_POS,SUM(E_Excard<0 AND E_Excard ne .) AS nr_neg from ttt union all SELECT ' E_Exliscar ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(E_Exliscar) AS SUM,nmiss( E_Exliscar) AS Nr_Null,SUM(E_Exliscar=0) AS Nr_0,SUM(E_Exliscar>0) AS Nr_POS,SUM(E_Exliscar<0 AND E_Exliscar ne .) AS nr_neg from ttt union all SELECT ' E_G ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(E_G) AS SUM,nmiss( E_G) AS Nr_Null,SUM(E_G=0) AS Nr_0,SUM(E_G>0) AS Nr_POS,SUM(E_G<0 AND E_G ne .) AS nr_neg from ttt union all SELECT ' E_Nashaf ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(E_Nashaf) AS SUM,nmiss( E_Nashaf) AS Nr_Null,SUM(E_Nashaf=0) AS Nr_0,SUM(E_Nashaf>0) AS Nr_POS,SUM(E_Nashaf<0 AND E_Nashaf ne .) AS nr_neg from ttt union all SELECT ' E_Mrtg_ ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(E_Mrtg_) AS SUM,nmiss( E_Mrtg_) AS Nr_Null,SUM(E_Mrtg_=0) AS Nr_0,SUM(E_Mrtg_>0) AS Nr_POS,SUM(E_Mrtg_<0 AND E_Mrtg_ ne .) AS nr_neg from ttt union all SELECT ' E_Mrtg_Bnk_Ex ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(E_Mrtg_Bnk_Ex) AS SUM,nmiss( E_Mrtg_Bnk_Ex) AS Nr_Null,SUM(E_Mrtg_Bnk_Ex=0) AS Nr_0,SUM(E_Mrtg_Bnk_Ex>0) AS Nr_POS,SUM(E_Mrtg_Bnk_Ex<0 AND E_Mrtg_Bnk_Ex ne .) AS nr_neg from ttt union all SELECT ' E_Mrtg_Ex_Nobnk ' AS FIELD, 'COUNT/DESCRETE' as type,COUNT(*) AS NR_TOTAL,SUM(E_Mrtg_Ex_Nobnk) AS SUM,nmiss( E_Mrtg_Ex_Nobnk) AS Nr_Null,SUM(E_Mrtg_Ex_Nobnk=0) AS Nr_0,SUM(E_Mrtg_Ex_Nobnk>0) AS Nr_POS,SUM(E_Mrtg_Ex_Nobnk<0 AND E_Mrtg_Ex_Nobnk ne .) AS nr_neg from ttt ; quit;

Ronein

Thank you it is perfect, However, I want to ask please- In real world I have 150 columns and my question is how can I make a clever code that perform it for all of the columns? Should I write 100 rows :(for each continuous var)? select 'x1' as field,'continuous' as type,nmiss(x1) as nr_null,sum(x1=0) as nr_0,sum(x1>0) as nr_pos from have

Ronein

Hello I have a data set with 2 million rows and 150 columns. Each customer ID have one row. The columns are from 3 types of fields- continuous (such as wealth amount), count (such as number of active loans), binary (such as indicator of failure in payments) CHAR( such as address) I want to check the data if it has no problems (for example : if a specific field has only null values ) I thoughts about create 3 reports for each type of variable- For each continuous/count var check- number of customers with null value number of customers with value 0 number of customers with POS value For each binary var check- number of customers with null value number of customers with value 0 number of customers with value 1 For each char var check- number of customers with null value number of customers with not null value What is the way (code) to create it please? options missing=.; Data have; input CustID x1 x2 x3 w1 w2 B1 B2 C1 $ C2 $ ; cards; 1 10.1 15 20 0 2 0 0 abx . 2 . . 21.1 0 0 1 1 abx def 3 12 14.4 16 . . 1 1 abx def 4 18 . 20.8 0 0 0 1 abx def 5 . . . 1 3 0 0 . def ; run;

Online Status	Online
Date Last Visited	yesterday

XLSX engine

send email from sas - text+report in body

proc report--number of rows

Re: proc export to XLSX- right to left layout

Re: proc export to XLSX- right to left layout

export

proc export to XLSX- right to left layout

ODS EXCEL---Excel sheet layout-right to left

put text with color

Re: Output freq on multiple vars into one data set

Re: percent format

Re: percent format

Re: percent format

Re: proc export to XLSX- right to left layout

Re: proc export to XLSX- right to left layout

Long to wide

Re: seq number between groups

Re: Percentile

score new data-logistic regression

Tools tab disappeared

percent format

Re: summary stats for many vars

Re: summary stats for many vars

Re: summary stats for many vars

Re: summary stats for many vars

summary stats for many vars

Re: Run sas by multiple people and update same data set??

Run macro based on 2 arguments from data set

Run sas by multiple people and update same data set??

Run if data set exist--error

Re: DATA CLEASING

Re: DATA CLEASING

Re: DATA CLEASING

Re: DATA CLEASING

DATA CLEASING

SAS Users Group in Israel