https://communities.sas.com/t5/Statistical-Procedures/Organiza%C3%A7%C3%A3o-de-tabela/m-p/758171#M36910 <P>Bom dia.&nbsp; ?Como vais voce?</P> <P>&nbsp;</P> <P>I think this is the same question as was posted elsewhere.&nbsp; I believe&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13884">@ballardw</a>&nbsp;already answered it, yes?&nbsp; or is there another question here?&nbsp; (I don't speak Portuguese except for a few words)</P> <P>&nbsp;</P> <P>Jim</P> Thu, 29 Jul 2021 17:38:32 GMT jimbarbour 2021-07-29T17:38:32Z https://communities.sas.com/t5/Statistical-Procedures/Organiza%C3%A7%C3%A3o-de-tabela/m-p/758119#M36908 <P>Bom dia!</P><P>A partir do código:</P><P>&nbsp;</P><P>proc freq data=base;</P><P>by mês;</P><P>tables tipo_cliente*folha / out=data1;</P><P>run;</P><P>&nbsp;</P><P>Criei a tabela a seguir, mas preciso que ela fique com as seguintes variáveis, respectivamente: mes, folha, count_tipo_cliente (se for 0), count_tipo_cliente (se for 1).</P><P>&nbsp;</P><P>Ou seja, preciso&nbsp;separar a variável&nbsp;"tipo_cliente" em duas colunas, caso seja 0 e caso seja 1.</P><P>&nbsp;</P><P>OUTDATA criada:</P><TABLE border="1"><TBODY><TR><TD>mes</TD><TD>tipo_cliente</TD><TD>folha</TD><TD>count</TD><TD>percent</TD></TR><TR><TD>1</TD><TD>0</TD><TD>3</TD><TD>21188</TD><TD>19.59</TD></TR><TR><TD>1</TD><TD>0</TD><TD>5</TD><TD>25208</TD><TD>23.31</TD></TR><TR><TD>1</TD><TD>0</TD><TD>7</TD><TD>7566</TD><TD>6.99</TD></TR><TR><TD>1</TD><TD>1</TD><TD>3</TD><TD>529</TD><TD>0.49</TD></TR><TR><TD>1</TD><TD>1</TD><TD>5</TD><TD>1066</TD><TD>0.98</TD></TR><TR><TD>1</TD><TD>1</TD><TD>7</TD><TD>522</TD><TD>0.48</TD></TR><TR><TD>2</TD><TD>0</TD><TD>3</TD><TD>23253</TD><TD>16.94</TD></TR><TR><TD>2</TD><TD>0</TD><TD>5</TD><TD>39683</TD><TD>28.91</TD></TR><TR><TD>2</TD><TD>0</TD><TD>7</TD><TD>12354</TD><TD>9.00</TD></TR><TR><TD>2</TD><TD>1</TD><TD>3</TD><TD>632</TD><TD>0.46</TD></TR><TR><TD>2</TD><TD>1</TD><TD>5</TD><TD>2044</TD><TD>1.49</TD></TR><TR><TD>2</TD><TD>1</TD><TD>7</TD><TD>871</TD><TD>0.63</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>&nbsp;</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>&nbsp;</P> Thu, 29 Jul 2021 14:59:29 GMT https://communities.sas.com/t5/Statistical-Procedures/Organiza%C3%A7%C3%A3o-de-tabela/m-p/758119#M36908 Thalitacosta 2021-07-29T14:59:29Z https://communities.sas.com/t5/Statistical-Procedures/Organiza%C3%A7%C3%A3o-de-tabela/m-p/758171#M36910 <P>Bom dia.&nbsp; ?Como vais voce?</P> <P>&nbsp;</P> <P>I think this is the same question as was posted elsewhere.&nbsp; I believe&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13884">@ballardw</a>&nbsp;already answered it, yes?&nbsp; or is there another question here?&nbsp; (I don't speak Portuguese except for a few words)</P> <P>&nbsp;</P> <P>Jim</P> Thu, 29 Jul 2021 17:38:32 GMT https://communities.sas.com/t5/Statistical-Procedures/Organiza%C3%A7%C3%A3o-de-tabela/m-p/758171#M36910 jimbarbour 2021-07-29T17:38:32Z