topic Re: ERROR: Invalid value for width specified - width out of range in SAS Programming

ERROR: Invalid value for width specified - width out of range

kmardinian — Sat, 19 Dec 2020 04:23:21 GMT

I have this below macro that runs fine for when xrow=1 to 99, but as soon as I put in anything over 100 it keeps generating this error that I don't understand.

ERROR: Invalid value for width specified - width out of range
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.

I looked up some helpful articles that say it may be a format issue, but I am not sure what format I would need to allow it to read > 100 and all the ones I have tried have not worked. Any help is much appreciated!! Thank you!

%Macro MYC(xdata,xrow);
proc sql noprint;
select filter,biomarks, group, exclude, number, title,
strip("TAB"||strip(put(ID,z2.))||"A") as tab, strip("Table "||strip(number)||": "||strip(title)) as ftabtitle,
strip(tranwrd(title,'Endpoints – ',' ')) as stabtitle
into: xfilters, :xbiomark, :xgroup, :xexclude, :xtabnum, :xtabtitle, :xtab, :xftabtitle, :xstabtitle
from input.data
where ID = &xrow;
quit;

%mend MYC;

%MYC(input.data_new,100);

Re: ERROR: Invalid value for width specified - width out of range

mkeintz — Sat, 19 Dec 2020 05:22:35 GMT

Buried in your select statement is the expression:

put(ID,z2.)

which precedes the clause

where ID = &xrow;

So your macro call

%MYC(input.data_new,100);

means that the put(ID,z2.) will attempt to write the value 100 in a 2-digit character space. Change the z2. to a format that can accommodate the 3-digit value of 100.

Re: ERROR: Invalid value for width specified - width out of range

kmardinian — Sat, 19 Dec 2020 06:20:39 GMT

Thank you so much, I definitely missed that! Works perfectly now!