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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.