Hi Cynthia, For SAS, I am not sure that is a way to export new sheets in existing excel files on linux , so first I import all sheets in the original external file, then export to a new file in which some sheets are just kept original format, and others will have some manipulation like adding hyperlink to new datasets , and some new sheets are added to source file. I had tried to use ODS report writing interface to format excel , but it seems to be not easy. Until now the way used in my above code can create the new output file with the same format as original file approximately except this the unsolved side effect of using mergeacross. Thanks a lot for your help.
... View more