Macro question

[sasban]

Acct_ID	Name	Birthday	Sex	State	Cust_Type	Product	Balance	Last_Tran_Date
1001	John	1/1/1962	M	CA	Gold	Checking	1000	9/1/2015
1002	Mary	1-Feb	F	CA	Silver	Saving	2000	10/1/2015
1003	Peter	3/1/1982	M	NY	Gold	Loan	3000	10/3/2016
1004	Mary	4/1/1992	F	NY	Silver	Checking	4000	9/17/2016
1005	Linda	5/1/1994	F	WA	Gold	Saving	5000
1006	Susan	6/1/1997	F	WA	Gold	Loan	1000	9/15/2016
1007	Sam	7/1/1999	M	CA	Gold	Checking	2000	2/1/2016
1008	Thomas	8/1/1962	M	CA	Silver	Checking	3000	7/1/2016
1009	Linda	9/1/1982	F	NY	Silver	Saving	4000

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.

[Reeza]

Not sure what you need suggestions on:

1. create a template in Excel, with the report structure you want.
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.
2. Use SAS to copy the template, FCOPY
3. Export data to the template for each report.

First, get it working for one report and then work on automating the report.