Hello Tom,
We have LIbreOffice instead of excel we are writing program in sas for output
eg
data test;
input id $ amount;
datalines;
101 123456789
102 987456123
103 456789123
;
run;
ods excelxp tagsets file='path/test.xls';
proc report data=test nowd;
columns id amount;
define id / 'EMP ID';
define amount / 'Amount' format=comma20.2;
run;
i am getting values in output as default in excel / LIbreOffice 2 digits seperated
101 12,34,56,789
102 98,74,56,123
103 45,67,89,123
i want output as complete 3 digit numeric seperaot
101 123,456,789
102 987,456,123
103 456,789,123
... View more