Hi, in the attached Table I would like to obscure the entire row when the values of the "Componenti Totale" variable are lower than 3 (in the case in question, instead of all the values of SECS-P / 05 - Econometria, SECS-P / 13 - Scienze Merceologiche and SECS-S / 05 - Statistica Sociale I wish I could put an asterisk). I tried to insert a statement like this in the proc format: value hide 0-3 = "*" other = [comma8.]; and insert the format in the PROC REPORT that I use, but this only obscures the values of "Componenti Totale" below 3 (while I would need the values of the entire row to be obscured, keeping the name of the Settore Scientifico Disciplinare). title1 j=l bold color=navy height=2 "Tavola 1 - Distribuzione per Settore Scientifico Disciplinare";
proc report data=archivi.dati_finali nowd vardef=n ;
columns ssd_cod_desc giorni_ruolo ('Componenti' n_comp anzianita_ruolo) n_soglie_sup,(sum std) tasso_f2 tasso_f1 tasso_co n_soglie_succ ('Indicatori UNIFI' indi_1 indi_2
tasso_succ indi_3 indi_4 indi_5 indi_6);
define ssd_cod_desc / group "Settore Scientifico Disciplinare";
define giorni_ruolo / analysis noprint;
define n_comp / analysis sum "Totale" format=hide.;
define anzianita_ruolo / computed f=commax8.2 "Anzianità nel ruolo";
compute anzianita_ruolo;
anzianita_ruolo= giorni_ruolo.sum / (n_comp.sum*365.25);
endcomp;
define n_soglie_sup / analysis "Soglie superate";
define sum / "Totale";
define std / "Deviazione standard" f=commax8.2;
define tasso_f2 / analysis mean f=commax8.2 "Tasso possesso requisiti PA" noprint;
define tasso_f1 / analysis mean f=commax8.2 "Tasso possesso requisiti PO" noprint;
define tasso_co / analysis mean f=commax8.2 "Tasso possesso requisiti CO" noprint;
define n_soglie_succ / analysis noprint;
define indi_1 / computed f=commax8.2 "A1 / (%)";
compute indi_1;
indi_1=(n_soglie_succ.sum / (n_comp.sum*3))*100 ;
endcomp;
define indi_2 / computed f=commax8.2 "A2 / ";
compute indi_2;
indi_2=(n_soglie_succ.sum / n_comp.sum);
endcomp;
define tasso_succ / analysis noprint;
define indi_3 / computed f=commax8.2 "A3 / ";
compute indi_3;
indi_3=(tasso_succ.sum / n_comp.sum);
endcomp;
define indi_4 / computed f=commax8.2 "A4 / (%)";
compute indi_4;
indi_4=(n_soglie_sup.sum / (n_comp.sum*9))*100 ;
endcomp;
define indi_5 / computed f=commax8.2 "A5 / ";
compute indi_5;
indi_5=(n_soglie_sup.sum / n_comp.sum) ;
endcomp;
define indi_6 / computed f=commax8.2 "A6 / ";
compute indi_6;
indi_6=mean(tasso_f2.mean, tasso_f1.mean, tasso_co.mean);
endcomp;
compute ssd_cod_desc;
count+1;
if mod(count,2) then do;
call define(_row_, "style", "style=[background=paoy]");
end;
endcomp;
run; A possible solution would be to carry out a date step that excludes the Settore Scientifico Disciplinare with values lower than 3 and then generate the PROC REPORT without having to obscure anything, but if you have a better solution I will gladly apply it. Thank you for your attention. Giacomo.
... View more
