I am trying to use ods excel to output a sas data set to excel while at the same time adding a computed column as an excel formula. The data set exports to excel just fine but the computed column just has periods (.) as values....no formula. I have tried absolutely everything and nothing seems to work...as if SAS is completely ignoring the tagattr altogether. I am well aware I could just do this calculation in SAS then export the resolved value, this is just an example that I am playing with to eventually scale up to a larger program that must export excel formulas to excel and not be calculated by SAS. ods excel file="C:\temp.xlsx";
data _null_;
set sashelp.class end=done;
if _n_ = 1 then do;
declare odsout t();
t.table_start();
t.row_start();
t.format_cell(data: 'Name');
t.format_cell(data: 'Height (ins)');
t.format_cell(data: 'Weight (lbs)');
t.format_cell(data: 'derived');
t.row_end();
end;
t.row_start();
t.format_cell(data: name);
t.format_cell(data: height);
t.format_cell(data: weight);
t.format_cell(data: .,style_attr: 'tagattr="formula:RC[-1]-RC[-2]"');
t.row_end();
if done then t.table_end();
run;
ods excel close;
... View more