Value from output is not complete

[kaix]

So I am trying to export me output in tabular form using dataset from Microsoft Excel, however, one of my output exported is shown as 847 but the value I was looking for is 84700. Other values seem to be fine. How can I fix this? Any assistance would be greatly appreciated.

[Kurt_Bremser]

Are you importing from Excel to SAS, or exporting from SAS to Excel?

In either case, please provide an example of the source data (Excel spreadsheet or SAS dataset). Please post SAS dataset(s) as data step code with datalines, so we can easily recreate your dataset(s).

[kaix]

Thank you for your reply. I am trying to export from SAS to Microsoft Excel.

I'm trying to tabulate my data using:

proc sql;

create table cl&endyyyymm..Fire_clm_os_summ_&endyyyymm. as

select si_band, cov_type, sum(round(zclmosnet,0.01)) as zclmosnet,sum(zclmos) as zclmos

from cl&endyyyymm..Fire_clm_os_summ_&endyyyymm. 

group by 1,2;

quit;

[Kurt_Bremser]

So we now see how you create a dataset, but we don't know how that dataset looks like in terms of structure and contents.

Please supply an example of the resulting dataset as a data step with datalines like

data xxx;
input si_band $ cov_type $ zclmosnet zclmos;
datalines;
A B 3.5 10.2
;

(adapt types and lengths as needed) and the code you used for export to Excel. Use the "little running man" button for posting code.

[ballardw]

---

@kaix wrote:

So I am trying to export me output in tabular form using dataset from Microsoft Excel, however, one of my output exported is shown as 847 but the value I was looking for is 84700. Other values seem to be fine. How can I fix this? Any assistance would be greatly appreciated.

---

You may also want to provide exactly how you are "exporting".