topic Re: Value from output is not complete in SAS Programming

Value from output is not complete

kaix — Wed, 22 Jan 2020 09:22:28 GMT

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.

Re: Value from output is not complete

Kurt_Bremser — Wed, 22 Jan 2020 09:31:02 GMT

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).

Re: Value from output is not complete

ballardw — Wed, 22 Jan 2020 16:49:56 GMT

@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".

Re: Value from output is not complete

kaix — Thu, 23 Jan 2020 08:30:37 GMT

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;

Re: Value from output is not complete

Kurt_Bremser — Thu, 23 Jan 2020 08:52:49 GMT

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.