proc export data=output_xlsd
dbms=xlsx
outfile="&Outdir./XYZ.xlsx"
replace;
run;
XYZ.xlsx is not retaining decimal points while exporting (Ex : 0.00 is showing as 0 , 149.00 is showing as 149)
I tried to add format in the datastep before exporting. It is not retaining from the dataset . IS there any other way to retain the decimals?
Thanks
Try ODS EXCEL or the older ODS TAGSETS.EXCELXP rather than PROC EXPORT? ODS gives you a lot of flexibility with respect to formatting your output.
Few years ago we could write DDE commands to format an Excel sheet from SAS
data _null_;
file DDEcmds;
put '[font.properties("Verdana","Bold",16,,,,,,,3)]';
run;
It no longer works now.
If you have to use PROC EXPORT, you could make a new CHARACTER variable to hold numeric number via put(var,f8.2). Or you could try ODS EXCEL or ODS TAGSETS.EXCELXP . ods excel file='/folders/myfolders/x.xlsx'; proc report data=sashelp.class nowd; define weight/style={tagattr="format:####.00"}; run; ods excel close;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.