I am using the DDE method to populate an EXCEL report template. I have a template that is a matrix of data, but all the data that needs to be populated is not consecutive. There are some calculated fields in between. I use multiple '09'x to to change to the appropriate column. This however deletes formulas that are already present in the template. My SAS data looks like Week Customers Visits Sales 1 100 120 1000 and the report needs to look like: Week Customers Visits Visits / Customers Sales Sales / Customer 1 100 120 1.2 1000 10 where "Visits / Customer" and "Sales / Customer " are present in the report template as formulas. When I try skipping over the column Visits/ Customer by using multiple '09x' statements, the formula is that column is being deleted. my SAS code looks like this. DATA _NULL_ put Week '09x' customer '09x' '09x' sales; run; sales is being poulated in the proper column but the formula for VISITS/ CUSTOMER is being deleted. Changing the template is not an option at this point, otherwise I would just calculate the folrmulas in my data set and write the values in EXCEL. Does anyone have any suggestions. Thanks,
... View more