Hello, I'm running the following program and running into an issue within excel. When SAS processing the line put '[formula.fill("=SUM(U2:U299)/1000")]'; excel gives me the following message. Not sure where I'm going wrong here.. Thanks!
Filename cmds dde 'excel|system';
Data _null_;
File cmds;
Put '[workbook.activate("MB")]';
Put '[select("R300C20")]';
put '[formula.fill("Sum of Acquisition Cost and Carrying Value")]';
put '[select("R301C20")]';
put '[formula.fill("From Sch A, col A, line M.2 & Sch A, col D, line M.2")]';
put '[select("R302C20")]';
put '[formula.fill("Check, must be zero")]';
put '[select("R300C21")]';
put '[formula.fill("=SUM(U2:U299)/1000")]';
put '[select("R300C66")]';
put '[formula.fill("=SUM(BN2:BN299)/1000")]';
put '[select("R301C21")]';
put '[formula.fill("='Schedule A'!G16")]';
put '[select("R302C21")]';
put '[formula.fill("=U300-U301")]';
put '[select("R301C66")]';
put '[formula.fill("='Schedule A'!J16")]';
put '[select("R302C66")]';
put '[formula.fill("=BN300-BN301")]';
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.