Olá Comunidade, Estou com um problema, para mim, na geração de um relatório com o Proc Print. NÃO gostaria que fosse impressa no relatório a última linha, a que tem o valor 993.996. Isso é possível? Abaixo as informações. Agradeço a comunidade. Relatório gerado pelo Proc Print Código SAS proc sort data=ArquivoDeDados
out= ArquivoDeDados_sort;
by Ordem
Tipo1;
run;
Title "CABECALHO 1";
Title2 JUSTIFY=RIGHT "CABECALHO 2";
Footnote italic 'FOOTNOTE 1';
Footnote2 italic 'FOOTNOTE 2';
proc print data=ArquivoDeDados_sort noobs label split="*" sumlabel="Total";
by Tipo1 notsorted;
var Tipo2 / style(data)={just=l verticalalign=c} style(header)={just=l verticalalign=c};
var Qtde / style(data)={just=c verticalalign=c} style(header)={just=c verticalalign=c};
sum Qtde / style(TOTAL)={just=c verticalalign=c} style(header)={just=c verticalalign=c};
label Tipo1 = "Tipo 1"
Tipo2 = "Tipo 2";
run;
title;
title2;
footnote;
footnote2; ArquivodeDados Tipo1 Tipo2 Qtde Ordem T1 M6 1.979885057 99 T1 M7 2.25 99 T1 M1 7.735488577 99 T1 M2 0.9 99 T1 M9 52.7236825 99 T1 M3 45.5742165 99 T1 M4 20.481892593 99 T1 M5 31.19141462 99 T1 M10 1.634920635 99 T1 M11 12.28700107 99 T2 M6 10.2712186 15 T2 M7 45.770711788 15 T2 M1 63.729361426 15 T2 M2 0 15 T2 M9 143.36997815 15 T2 M3 324.92522675 15 T2 M4 135.24650238 15 T2 M5 24.861977905 15 T2 M10 0 15 T2 M11 69.06241385 15 ArquivoDeDados_sort Tipo1 Tipo2 Qtde Ordem T2 M6 10.2712186 15 T2 M7 45.770711788 15 T2 M1 63.729361426 15 T2 M2 0 15 T2 M9 143.36997815 15 T2 M3 324.92522675 15 T2 M4 135.24650238 15 T2 M5 24.861977905 15 T2 M10 0 15 T2 M11 69.06241385 15 T1 M6 1.979885057 99 T1 M7 2.25 99 T1 M1 7.735488577 99 T1 M2 0.9 99 T1 M9 52.7236825 99 T1 M3 45.5742165 99 T1 M4 20.481892593 99 T1 M5 31.19141462 99 T1 M10 1.634920635 99 T1 M11 12.28700107 99 Log 1 The SAS System 11:04 Wednesday, June 22, 2022
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program';
4 %LET _CLIENTPROCESSFLOWNAME='06_Perfil';
5 %LET _CLIENTPROJECTPATH='/sasdata/DS/metricas/Projects/Pontual/Pontual.egp';
6 %LET _CLIENTPROJECTPATHHOST='MZ-FL-AP-248';
7 %LET _CLIENTPROJECTNAME='Pontual.egp';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=SVG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
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
25 GPATH=&sasworklocation
26 ;
NOTE: Writing HTML5(EGHTML) Body file: EGHTML
27
28 proc sort data=ArquivoDeDados
29 out= ArquivoDeDados_sort;
30 by Ordem
31 Tipo1;
32 run;
NOTE: There were 20 observations read from the data set WORK.ARQUIVODEDADOS.
NOTE: The data set WORK.ARQUIVODEDADOS_SORT has 20 observations and 4 variables.
NOTE: Compressing data set WORK.ARQUIVODEDADOS_SORT increased size by 100.00 percent.
Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.19 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 954.46k
OS Memory 22688.00k
Timestamp 06/22/2022 02:12:32 PM
Step Count 154 Switch Count 2
Page Faults 0
Page Reclaims 55
Page Swaps 0
Voluntary Context Switches 38
Involuntary Context Switches 5
Block Input Operations 0
Block Output Operations 0
33
34 Title "CABECALHO 1";
35 Title2 JUSTIFY=RIGHT "CABECALHO 2";
2 The SAS System 11:04 Wednesday, June 22, 2022
36 Footnote italic 'FOOTNOTE 1';
37 Footnote2 italic 'FOOTNOTE 2';
38
39 proc print data=ArquivoDeDados_sort noobs label split="*" sumlabel="Total";
40 by Tipo1 notsorted;
41
42 var Tipo2 / style(data)={just=l verticalalign=c} style(header)={just=l verticalalign=c};
43 var Qtde / style(data)={just=c verticalalign=c} style(header)={just=c verticalalign=c};
44
45 sum Qtde / style(TOTAL)={just=c verticalalign=c} style(header)={just=c verticalalign=c};
46
47 label Tipo1 = "Tipo 1"
48 Tipo2 = "Tipo 2";
49 run;
NOTE: There were 20 observations read from the data set WORK.ARQUIVODEDADOS_SORT.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.04 seconds
user cpu time 0.03 seconds
system cpu time 0.00 seconds
memory 1731.37k
OS Memory 22684.00k
Timestamp 06/22/2022 02:12:32 PM
Step Count 155 Switch Count 0
Page Faults 0
Page Reclaims 72
Page Swaps 0
Voluntary Context Switches 3
Involuntary Context Switches 10
Block Input Operations 0
Block Output Operations 0
50 title;
51 title2;
52 footnote;
53 footnote2;
54
55 %LET _CLIENTTASKLABEL=;
56 %LET _CLIENTPROCESSFLOWNAME=;
57 %LET _CLIENTPROJECTPATH=;
58 %LET _CLIENTPROJECTPATHHOST=;
59 %LET _CLIENTPROJECTNAME=;
60 %LET _SASPROGRAMFILE=;
61 %LET _SASPROGRAMFILEHOST=;
62
63 ;*';*";*/;quit;run;
64 ODS _ALL_ CLOSE;
65
66
67 QUIT; RUN;
68
... View more
