topic Re: How to retain sas Excel templete when appending to excel in SAS Programming

How to retain sas Excel templete when appending to excel

rinsabraham — Wed, 05 Dec 2018 06:49:13 GMT

Hi Team,

We have one excel the template with data we are trying to delete the data from existing sheet and appending with new data along with the new additional column while we do we not getting same format for new addition column.Can you please help me out?

refer the below code;

libname ccc odbc no prompt="dsn=excel files; dbq=pathname ";

proc datasets lib=ccc;

delete 'Data$'n;

run;

proc datasets lib=ccc;

delete data;

run;

proc append base=ccc.data data=abc;

run;

libname ccc clear;

Re: How to retain sas Excel templete when appending to excel

andreas_lds — Wed, 05 Dec 2018 07:37:36 GMT

Afaik you can't delete data and keep formatting at the same time using sas. Some time ago someone suggest using two sheets in the excel-file: one with the required layout and another one with the data. The search facility should show the post.

Re: How to retain sas Excel templete when appending to excel

rinsabraham — Fri, 07 Dec 2018 08:12:41 GMT

Thanks for your replying.

But we want to get the data into one sheet with the existing template. Please find the attachment after execution of our code result. Here phone number column is the addition column which we have appended into the excel the sheet and formating is not happening into the new column.

Re: How to retain sas Excel templete when appending to excel

andreas_lds — Wed, 05 Dec 2018 08:57:31 GMT

1. Don't repeat your posts if you don't get an answer fast enough.

2. I can't help you any further, because i won't open office files.

Re: How to retain sas Excel templete when appending to excel

rinsabraham — Wed, 05 Dec 2018 08:59:53 GMT

ok sorry