Sas Excel output column value start with =

Question

ECEMBER 8 2022, 9:16 PM Can anyone suggest on Excel output having column with spacial char ..output file gets corrupted as column value start with = sign for some rows other having + or other spacial chars

Excel ods output having column value start with spacial char like += etc.

Answer 1

Use the option (formulas='off')

Example:

data have;
  cell = '=hello there';
run;

ods excel file='funky-town.xlsx' options(formulas='off');

proc print data=have;
run;

ods excel close;