CODEWITHSUNDEEP
excelsascharprocods
Ravi Sharma
Ravi Sharma

Reputation: 1

Sas Excel output column value start with =

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.

Upvotes: 0

Views: 67

Answers (1)

Richard
Richard

Reputation: 27508

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;

enter image description here

Upvotes: 0

Related Questions