Hi,   I am creating a table which a column name 'Ev_%_Sat_Sch' in SAS DI and I get the warning : 'apparent invocation of  macro xxxx not resolved' .   This column name is in an existing SAS EG code and I am trying to put that in SAS DI without any changes to the table structure.   Is there a way I could just use the existing DI objects (e.g. extract, Join) without having to manipulate the existing generated code?   In the 'Physical Storage' tab for the DI objects, I have selected both 'Enable case-sensitive DBMS object names' and 'Enable special characters within table or column object names'.   Thank you.   Rgds.   ... View more

  Hi,   I have been trying to automate refreshing a pivot table from SAS and followed the previous suggestions from the link below :-   https://communities.sas.com/t5/SAS-Procedures/Updating-Extrenal-Excel-Pivot-Table-in-SAS/td-p/167515    However I still get the DDE Error :-   ERROR: DDE session not ready. FATAL: Unrecoverable I/O error detected in the execution of the DATA step program. Aborted during the EXECUTION phase.   Code:-   options noxwait noxsync; data _null_;   rc=system('start excel');   rc=sleep(5); run;   filename cmds dde 'excel|system'; data _null_;      file cmds;      put "[open(""&path\&f_name..xls"")]";      put '[workbook.select("Pivot")]';      put '[select("R1C4")]';      put "[pivot.refresh()]";      put "[save()]";      put "[quit()]"; run; quit   Here the Excel file is a 2003 file and I have debugged this code. I get the error with this code line  ' put "[pivot.refresh()]"; '   Please advice. ... View more