I wanted to export formulas from SAS to Excel, using ODS EXCEL. However, the Excel file did not recognize the formulas. It showed the formulas instead of the calculated numbers. Does anyone know how to fix the problem? Thank you. Below are the codes I used. (You can run them if you have SAS 9.4.) ------------------------------------------- proc sql; create table cars as select distinct make, model, msrp, invoice from sashelp.cars where make = 'Audi' ; quit; data cars_b; set cars; row_num + 1; if first.make then row_num = 1; row_num_b = strip(put(sum(row_num,4),8.)); diff = '='||'C'||row_num_b||'-'||'D'||row_num_b; diff_b = compress(diff); run; options missing = ' ' papersize = letter topmargin = 0.5 in leftmargin = 0.5 in rightmargin = 0.5 in bottommargin = 1.0 in ; ods excel file = 'I:\1 Academic Affairs\Faculty\1 Salary\FERIP\ODS EXCEL (test)\diff_in_prices.xlsx' style = normal options ( embedded_titles = 'yes' embedded_footnotes = 'yes' print_footer = ' ' center_horizontal = 'yes' absolute_column_width = '8,30,12,12,12' fittopage = 'no' pages_fitheight = '100' orientation = 'portrait' row_repeat = '3-5' sheet_interval = 'none' sheet_name = 'Diff' merge_titles_footnotes = 'yes' title_footnote_width = ' ' ); title1 'XXX'; title2 'Difference in Price'; proc print data = cars_b label NOOBS; var make model msrp invoice diff_b; label diff_b = 'Difference'; run; footnote; ods excel close;
... View more