DDE Approach: This will write data from ‘sasfile’ called in a template called ‘report’, starting at row 10 column 3 or the template to row 324 column 11. Write variables “height (weight name age class Injury)” and save as “final_report” in same location as template. ____________ options noxwait noxsync; x "'template path\report.xlsx'"; data _null_; x=sleep(1); run; filename report dde "excel|templatepath\[report.xlsx]new ICD10!r10c3:r324c11" notab recfm=v LRECL=500; data _null_; set sasfile; file report ; put height (weight name age class Injury) ('09'x); run; data _null_; x=sleep(1); run; filename cmp dde 'Excel|System'; data _null_; file cmp; put %unquote(%str(%'[SAVE.as("template path\final_Report.xlsx")]%')); put '[QUIT()]'; run;
... View more