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.
