topic Macro question in SAS Studio https://communities.sas.com/t5/SAS-Studio/Macro-question/m-p/406690#M3776 <TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD><P>&nbsp;</P><P>Acct_ID</P></TD><TD>Name</TD><TD>Birthday</TD><TD>Sex</TD><TD>State</TD><TD>Cust_Type</TD><TD>Product</TD><TD>Balance</TD><TD>Last_Tran_Date</TD></TR><TR><TD>1001</TD><TD>John</TD><TD>1/1/1962</TD><TD>M</TD><TD>CA</TD><TD>Gold</TD><TD>Checking</TD><TD>1000</TD><TD>9/1/2015</TD><TD>&nbsp;</TD></TR><TR><TD>1002</TD><TD>Mary</TD><TD>1-Feb</TD><TD>F</TD><TD>CA</TD><TD>Silver</TD><TD>Saving</TD><TD>2000</TD><TD>10/1/2015</TD><TD>&nbsp;</TD></TR><TR><TD>1003</TD><TD>Peter</TD><TD>3/1/1982</TD><TD>M</TD><TD>NY</TD><TD>Gold</TD><TD>Loan</TD><TD>3000</TD><TD>10/3/2016</TD><TD>&nbsp;</TD></TR><TR><TD>1004</TD><TD>Mary</TD><TD>4/1/1992</TD><TD>F</TD><TD>NY</TD><TD>Silver</TD><TD>Checking</TD><TD>4000</TD><TD>9/17/2016</TD><TD>&nbsp;</TD></TR><TR><TD>1005</TD><TD>Linda</TD><TD>5/1/1994</TD><TD>F</TD><TD>WA</TD><TD>Gold</TD><TD>Saving</TD><TD>5000</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1006</TD><TD>Susan</TD><TD>6/1/1997</TD><TD>F</TD><TD>WA</TD><TD>Gold</TD><TD>Loan</TD><TD>1000</TD><TD>9/15/2016</TD><TD>&nbsp;</TD></TR><TR><TD>1007</TD><TD>Sam</TD><TD>7/1/1999</TD><TD>M</TD><TD>CA</TD><TD>Gold</TD><TD>Checking</TD><TD>2000</TD><TD>2/1/2016</TD><TD>&nbsp;</TD></TR><TR><TD>1008</TD><TD>Thomas</TD><TD>8/1/1962</TD><TD>M</TD><TD>CA</TD><TD>Silver</TD><TD>Checking</TD><TD>3000</TD><TD>7/1/2016</TD><TD>&nbsp;</TD></TR><TR><TD>1009</TD><TD>Linda</TD><TD>9/1/1982</TD><TD>F</TD><TD>NY</TD><TD>Silver</TD><TD>Saving</TD><TD>4000</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>From the data above, I need to create a table as attached using macros. I'm learning an efficient use of macro. Any suggestion would be a great help.</P> Mon, 23 Oct 2017 18:35:27 GMT sasban 2017-10-23T18:35:27Z Macro question https://communities.sas.com/t5/SAS-Studio/Macro-question/m-p/406690#M3776 <TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD><P>&nbsp;</P><P>Acct_ID</P></TD><TD>Name</TD><TD>Birthday</TD><TD>Sex</TD><TD>State</TD><TD>Cust_Type</TD><TD>Product</TD><TD>Balance</TD><TD>Last_Tran_Date</TD></TR><TR><TD>1001</TD><TD>John</TD><TD>1/1/1962</TD><TD>M</TD><TD>CA</TD><TD>Gold</TD><TD>Checking</TD><TD>1000</TD><TD>9/1/2015</TD><TD>&nbsp;</TD></TR><TR><TD>1002</TD><TD>Mary</TD><TD>1-Feb</TD><TD>F</TD><TD>CA</TD><TD>Silver</TD><TD>Saving</TD><TD>2000</TD><TD>10/1/2015</TD><TD>&nbsp;</TD></TR><TR><TD>1003</TD><TD>Peter</TD><TD>3/1/1982</TD><TD>M</TD><TD>NY</TD><TD>Gold</TD><TD>Loan</TD><TD>3000</TD><TD>10/3/2016</TD><TD>&nbsp;</TD></TR><TR><TD>1004</TD><TD>Mary</TD><TD>4/1/1992</TD><TD>F</TD><TD>NY</TD><TD>Silver</TD><TD>Checking</TD><TD>4000</TD><TD>9/17/2016</TD><TD>&nbsp;</TD></TR><TR><TD>1005</TD><TD>Linda</TD><TD>5/1/1994</TD><TD>F</TD><TD>WA</TD><TD>Gold</TD><TD>Saving</TD><TD>5000</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1006</TD><TD>Susan</TD><TD>6/1/1997</TD><TD>F</TD><TD>WA</TD><TD>Gold</TD><TD>Loan</TD><TD>1000</TD><TD>9/15/2016</TD><TD>&nbsp;</TD></TR><TR><TD>1007</TD><TD>Sam</TD><TD>7/1/1999</TD><TD>M</TD><TD>CA</TD><TD>Gold</TD><TD>Checking</TD><TD>2000</TD><TD>2/1/2016</TD><TD>&nbsp;</TD></TR><TR><TD>1008</TD><TD>Thomas</TD><TD>8/1/1962</TD><TD>M</TD><TD>CA</TD><TD>Silver</TD><TD>Checking</TD><TD>3000</TD><TD>7/1/2016</TD><TD>&nbsp;</TD></TR><TR><TD>1009</TD><TD>Linda</TD><TD>9/1/1982</TD><TD>F</TD><TD>NY</TD><TD>Silver</TD><TD>Saving</TD><TD>4000</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>From the data above, I need to create a table as attached using macros. I'm learning an efficient use of macro. Any suggestion would be a great help.</P> Mon, 23 Oct 2017 18:35:27 GMT https://communities.sas.com/t5/SAS-Studio/Macro-question/m-p/406690#M3776 sasban 2017-10-23T18:35:27Z Re: Macro question https://communities.sas.com/t5/SAS-Studio/Macro-question/m-p/406697#M3777 Not sure what you need suggestions on:<BR /><BR />1. create a template in Excel, with the report structure you want. <BR />2. For the fields you need that are not formatted into a nice table, link them to cells behind the scene so you can export data from SAS straight into the template.<BR />2. Use SAS to copy the template, FCOPY<BR />3. Export data to the template for each report. <BR /><BR />First, get it working for one report and then work on automating the report. Mon, 23 Oct 2017 18:42:31 GMT https://communities.sas.com/t5/SAS-Studio/Macro-question/m-p/406697#M3777 Reeza 2017-10-23T18:42:31Z