topic Re: problems with proc tabulate in SAS Programming

problems with proc tabulate

monicluder — Fri, 13 Aug 2021 10:10:33 GMT

Hello! I'm trying to reproduce a table with some dimension and percentulals, but I've a problem with visualization; I post a sample code and the part o the result that I see; could anybody help me?

example data and code:

data t;input pat1 pat2 pat3 pat4 pat5 pat6 pat7 genere $ periodo $ cl_eta $ stato $;cards;
0 0 1 0 1 0 1 M periodo1 classe1 stato1
0 0 1 0 1 0 1 M periodo1 classe3 stato2
0 0 1 0 0 0 1 F periodo1 classe1 stato3
1 0 1 0 1 0 0 F periodo1 classe2 stato1
0 0 1 0 1 0 1 M periodo1 classe1 stato1
0 0 1 0 1 0 1 M periodo1 classe2 stato1
0 0 1 0 0 0 1 F periodo1 classe1 stato3
0 0 1 0 1 0 1 M periodo2 classe3 stato3
0 1 1 0 1 0 0 F periodo2 classe1 stato3
0 0 1 0 1 0 1 F periodo2 classe1 stato2
0 0 1 0 1 0 1 M periodo2 classe1 stato2
0 0 1 0 1 0 1 M periodo1 classe4 stato2
1 0 0 0 1 0 1 M periodo1 classe1 stato2
0 0 1 0 1 0 1 F periodo2 classe1 stato2
0 0 0 0 1 0 1 M periodo2 classe1 stato2
0 0 0 0 1 0 1 F periodo1 classe1 stato3
0 0 1 0 1 0 1 M periodo1 classe1 stato3
0 0 1 0 1 0 1 M periodo1 classe1 stato3
0 0 0 0 1 0 0 F periodo1 classe1 stato3
0 0 1 0 1 0 1 M periodo1 classe5 stato1
0 0 1 0 1 0 1 F periodo1 classe1 stato1
0 1 1 0 1 0 1 M periodo1 classe2 stato1
0 1 1 0 1 0 1 F periodo1 classe1 stato1
0 0 1 0 1 0 1 M periodo2 classe3 stato3
0 0 1 0 1 0 1 M periodo2 classe3 stato3
0 0 1 0 1 0 1 M periodo3 classe3 stato2
0 0 1 0 1 0 1 F periodo3 classe3 stato2
0 0 1 0 1 0 1 M periodo2 classe3 stato3
0 0 1 0 1 0 1 F periodo2 classe3 stato1
;
proc tabulate data=t; class periodo genere cl_eta stato;var pat1-pat7;
table periodo, cl_eta='Classe di età' *
(pat1*rowpctsum*f=8.2 pat2*rowpctsum*f=8.2 pat3*rowpctsum*f=8.2 pat4*rowpctsum*f=8.2 pat5*rowpctsum*f=8.2 
pat6*rowpctsum*f=8.2 pat7*rowpctsum*f=8.2) *genere=' ', (stato=' ' all='totale'); keylabel rowpctsum=' ';
run;

In the result it is possible see that the variable "GENERE" is not aligned across all the rows of the table.

Thanks a lot

Monica

Re: problems with proc tabulate

ChrisNZ — Fri, 13 Aug 2021 10:49:10 GMT

Do you use ODS PDF? Please provide your whole code.

Re: problems with proc tabulate

monicluder — Fri, 13 Aug 2021 10:52:04 GMT

No I don't use ODS PDF, I only use the print commando on the result window. I've posted all my code

Re: problems with proc tabulate

FreelanceReinh — Fri, 13 Aug 2021 19:11:53 GMT

Hello @monicluder,

I can confirm that my SAS 9.4M5 produces the same corrupt table layout in HTML, whereas the listing output looks right.

As an example, here is the last page:

The HTML code created by SAS looks suspicious to me because the <tr> and </tr> tags are not balanced: 109 vs. 106 overall. (But I'm not an HTML expert.)

Example (part of the code for the table shown above):

<tr>
<th class="l t rowheader" rowspan="14" scope="rowgroup">classe3 </th>
<th class="l t rowheader" rowspan="2" scope="rowgroup">pat1</th>
<th class="c rowheader" rowspan="2" scope="rowgroup">&nbsp;</th>
<tr>
<th class="l t rowheader" scope="row">F       </th>
</tr>
<tr>
<th class="l t rowheader" scope="row">M       </th>
<td class="r b data">.</td>
<td class="r b data">.</td>
</tr>

I haven't tried other ODS destinations. A similar issue with the PDF destination was mentioned in this 2015 post.

If using ODS Listing is not an option and nobody else has a better idea, you might need to open a track with SAS Technical Support. Sorry I couldn't be of more help.

Re: problems with proc tabulate

ballardw — Fri, 13 Aug 2021 19:44:16 GMT

Try this and see if it is acceptable.

proc tabulate data=t; 
   class periodo  cl_eta stato;
   class genere  ;
    var pat1-pat7;
   table periodo, 
         cl_eta=' ' * (pat1-pat7)*genere=' '*rowpctsum*f=8.2 , 
        stato=' ' all='totale'
       / row=float box="Classe di età"; 
keylabel rowpctsum=' ';
run;

I think the issue is the mix of suppressed and unsuppressed column headers though not sure why.

Personally for my report I would be strongly tempted to have formats for Genere and Stato and use Preloadfmt so the row/columns are tad more consistent.

Re: problems with proc tabulate

monicluder — Sat, 14 Aug 2021 17:12:08 GMT

Thanks Ballardw, I'm agree with you. The first idea was about a bug, and it's indeed an abnormal result on my output report! Writing the code in the mode that you suggest, it's works!
Bye

Monica

Re: problems with proc tabulate

ChrisNZ — Sun, 15 Aug 2021 06:17:39 GMT

@monicluder This looks like a defect. You should report it to SAS Tech support.

Re: problems with proc tabulate

ChrisNZ — Mon, 16 Aug 2021 03:39:55 GMT

I reduced the code size and opened an incident with SAS.

Rogue <tr> tags are inserted.

Re: problems with proc tabulate

monicluder — Tue, 17 Aug 2021 10:59:10 GMT

Thanks Chris! I'm in low wifi area, now, and it's difficult for me communucating with my italian sas representative

Re: problems with proc tabulate

DavidK_SAS — Wed, 18 Aug 2021 10:22:03 GMT

TABULATE likes for analysis variables to follow class variables in TABLE statement dimension expressions. This worked for me:

proc tabulate data=t; class periodo genere cl_eta stato;var pat1-pat7;
table periodo, cl_eta='Classe di età' *genere=' '
*(pat1 pat2 pat3 pat4 pat5 pat6 pat7), (stato=' ' all='totale')*rowpctsum*f=8.2;
keylabel rowpctsum=' ';
run;

Re: problems with proc tabulate

ChrisNZ — Wed, 18 Aug 2021 10:53:24 GMT

I agree. And while the syntax as valid, and while the listing output is correct, the defect is archived and will not be corrected for this reason: the syntax is atypical, and the common syntax works as expected.