I first removed the "replace;" lines from the code, but the program failed: ERROR 22-322: Syntax error, expecting one of the following: ;, DATA, DBLABEL, DBMS, DEBUG, FILE, LABEL, OUTFILE, OUTTABLE, REPLACE, TABLE, _DEBUG_. ERROR 76-322: Syntax error, statement will be ignored. Removing the data tabs from the template breaks the links to the presentation tabs (resulting in the #REF errors, which wouldn't be corrected when the tabs are added through the SAS program), which then defeats the whole purpose of the process. I guess what it comes down to is, can SAS/UNIX actually copy an Excel file completely or not? Because that is the benefit of this exercise. What are your thoughts on the file copying functionality?
... View more