Proc DataSet error: Decimal specification.

sam5 — Thu, 20 Dec 2018 11:34:19 GMT

Hi,

I'm trying to export a table from SAS onto excel using a proc dataset which I have done countless times in the past.

However, I'm getting an error that I have not seen before and I'm not sure how to get past it.

This is my code:

Proc Sql;
	create table my_data as
	select Month,
		   character_variable,
		   character_variable,
		   SUM(numeric_variable)/count(*) 
	from source
	group by 1,2,3;
run;

libname key excel "location";

Proc Datasets
lib=key;
Delete my_data;
Run;
Data key.my_data; 
set my_data;
Run;

libname key clear;

This is the error that appears:

ERROR: The decimal specification of 5 must be less than the width specification of 5.

I've tried changing the numeric format from having no format to a 5.2 format to a 10.2 format but the same error appears every time.

The table runs without any errors, it is only the proc datasets where the error occurs.

I export other tables within this code and they run fine.

Any help would be appreciated.

Re: Proc DataSet error: Decimal specification.

Kurt_Bremser — Tue, 18 Dec 2018 12:20:49 GMT

Please post your whole code, and the log from it. Use the proper sub-windows for this (see https://communities.sas.com/t5/help/faqpage/faq-category-id/posting#posting)

topic Proc DataSet error: Decimal specification. in SAS Programming

Proc DataSet error: Decimal specification.

Re: Proc DataSet error: Decimal specification.