topic Output Formatting in SAS Programming https://communities.sas.com/t5/SAS-Programming/Output-Formatting/m-p/347715#M80390 <P>&nbsp;Hi,</P><P>&nbsp;</P><P>I have an output (FigA) but want it to look like (FigB) - any ideas?</P><P>&nbsp;</P><P>(FigA)</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Yr</TD><TD>Mth</TD><TD>Product</TD><TD>Total</TD></TR><TR><TD>2010</TD><TD>1</TD><TD>D</TD><TD>8445</TD></TR><TR><TD>2010</TD><TD>1</TD><TD>R</TD><TD>217</TD></TR><TR><TD>2010</TD><TD>1</TD><TD>E</TD><TD>7276</TD></TR><TR><TD>2010</TD><TD>2</TD><TD>D</TD><TD>322</TD></TR><TR><TD>2010</TD><TD>2</TD><TD>R</TD><TD>6845</TD></TR><TR><TD>2010</TD><TD>2</TD><TD>E</TD><TD>6508</TD></TR><TR><TD>2010</TD><TD>3</TD><TD>D</TD><TD>474</TD></TR><TR><TD>2010</TD><TD>3</TD><TD>R</TD><TD>7503</TD></TR><TR><TD>2010</TD><TD>3</TD><TD>E</TD><TD>6960</TD></TR><TR><TD>2011</TD><TD>1</TD><TD>D</TD><TD>6508</TD></TR><TR><TD>2011</TD><TD>1</TD><TD>R</TD><TD>6558</TD></TR><TR><TD>2011</TD><TD>1</TD><TD>E</TD><TD>6608</TD></TR><TR><TD>2011</TD><TD>2</TD><TD>D</TD><TD>6658</TD></TR><TR><TD>2011</TD><TD>2</TD><TD>R</TD><TD>6708</TD></TR><TR><TD>2011</TD><TD>2</TD><TD>E</TD><TD>200</TD></TR><TR><TD>2011</TD><TD>3</TD><TD>D</TD><TD>250</TD></TR><TR><TD>2011</TD><TD>3</TD><TD>R</TD><TD>900</TD></TR><TR><TD>2011</TD><TD>3</TD><TD>E</TD><TD>950</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>(FigB)</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Yr</TD><TD>Product</TD><TD>Total</TD></TR><TR><TD>2010</TD><TD>D</TD><TD>9241</TD></TR><TR><TD>&nbsp;</TD><TD>R</TD><TD>14565</TD></TR><TR><TD>&nbsp;</TD><TD>E</TD><TD>20744</TD></TR><TR><TD>2011</TD><TD>D</TD><TD>13416</TD></TR><TR><TD>&nbsp;</TD><TD>R</TD><TD>14166</TD></TR><TR><TD>&nbsp;</TD><TD>E</TD><TD>7758</TD></TR></TBODY></TABLE> Thu, 06 Apr 2017 13:45:52 GMT CamRutherford 2017-04-06T13:45:52Z Output Formatting https://communities.sas.com/t5/SAS-Programming/Output-Formatting/m-p/347715#M80390 <P>&nbsp;Hi,</P><P>&nbsp;</P><P>I have an output (FigA) but want it to look like (FigB) - any ideas?</P><P>&nbsp;</P><P>(FigA)</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Yr</TD><TD>Mth</TD><TD>Product</TD><TD>Total</TD></TR><TR><TD>2010</TD><TD>1</TD><TD>D</TD><TD>8445</TD></TR><TR><TD>2010</TD><TD>1</TD><TD>R</TD><TD>217</TD></TR><TR><TD>2010</TD><TD>1</TD><TD>E</TD><TD>7276</TD></TR><TR><TD>2010</TD><TD>2</TD><TD>D</TD><TD>322</TD></TR><TR><TD>2010</TD><TD>2</TD><TD>R</TD><TD>6845</TD></TR><TR><TD>2010</TD><TD>2</TD><TD>E</TD><TD>6508</TD></TR><TR><TD>2010</TD><TD>3</TD><TD>D</TD><TD>474</TD></TR><TR><TD>2010</TD><TD>3</TD><TD>R</TD><TD>7503</TD></TR><TR><TD>2010</TD><TD>3</TD><TD>E</TD><TD>6960</TD></TR><TR><TD>2011</TD><TD>1</TD><TD>D</TD><TD>6508</TD></TR><TR><TD>2011</TD><TD>1</TD><TD>R</TD><TD>6558</TD></TR><TR><TD>2011</TD><TD>1</TD><TD>E</TD><TD>6608</TD></TR><TR><TD>2011</TD><TD>2</TD><TD>D</TD><TD>6658</TD></TR><TR><TD>2011</TD><TD>2</TD><TD>R</TD><TD>6708</TD></TR><TR><TD>2011</TD><TD>2</TD><TD>E</TD><TD>200</TD></TR><TR><TD>2011</TD><TD>3</TD><TD>D</TD><TD>250</TD></TR><TR><TD>2011</TD><TD>3</TD><TD>R</TD><TD>900</TD></TR><TR><TD>2011</TD><TD>3</TD><TD>E</TD><TD>950</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>(FigB)</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Yr</TD><TD>Product</TD><TD>Total</TD></TR><TR><TD>2010</TD><TD>D</TD><TD>9241</TD></TR><TR><TD>&nbsp;</TD><TD>R</TD><TD>14565</TD></TR><TR><TD>&nbsp;</TD><TD>E</TD><TD>20744</TD></TR><TR><TD>2011</TD><TD>D</TD><TD>13416</TD></TR><TR><TD>&nbsp;</TD><TD>R</TD><TD>14166</TD></TR><TR><TD>&nbsp;</TD><TD>E</TD><TD>7758</TD></TR></TBODY></TABLE> Thu, 06 Apr 2017 13:45:52 GMT https://communities.sas.com/t5/SAS-Programming/Output-Formatting/m-p/347715#M80390 CamRutherford 2017-04-06T13:45:52Z Re: Output Formatting https://communities.sas.com/t5/SAS-Programming/Output-Formatting/m-p/347719#M80393 <P>Proc REPORT, TABULATE OR FREQ.&nbsp;</P> <P>&nbsp;</P> <P>I'd probably start with TABULATE.&nbsp;</P> Thu, 06 Apr 2017 13:49:09 GMT https://communities.sas.com/t5/SAS-Programming/Output-Formatting/m-p/347719#M80393 Reeza 2017-04-06T13:49:09Z Re: Output Formatting https://communities.sas.com/t5/SAS-Programming/Output-Formatting/m-p/347722#M80394 <P>Tabulate works but I need it to be in an output file not a table. When I use OUT= it doesn't keep the format of the proc tabulate and instead refers back to original file.</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 06 Apr 2017 13:50:38 GMT https://communities.sas.com/t5/SAS-Programming/Output-Formatting/m-p/347722#M80394 CamRutherford 2017-04-06T13:50:38Z Re: Output Formatting https://communities.sas.com/t5/SAS-Programming/Output-Formatting/m-p/347727#M80399 <P>Given your sample they should be the same structure.</P> <P>You can try PROC MEANS or FREQ.&nbsp;</P> <P>i recommend against including missing values in first column.</P> Thu, 06 Apr 2017 14:00:02 GMT https://communities.sas.com/t5/SAS-Programming/Output-Formatting/m-p/347727#M80399 Reeza 2017-04-06T14:00:02Z Re: Output Formatting https://communities.sas.com/t5/SAS-Programming/Output-Formatting/m-p/347738#M80405 <P>If you want this in a data set what is the purpose of the blank values for year?</P> <P>What will you do with the resulting data set?</P> Thu, 06 Apr 2017 14:18:44 GMT https://communities.sas.com/t5/SAS-Programming/Output-Formatting/m-p/347738#M80405 ballardw 2017-04-06T14:18:44Z