Sorry, please ignore this, I just figured it out.

Kristie Beth <kristie_35_89@yahoo.com> wrote:Hi SAS-L,

I have an error I can't figure out though I do obtain the correct results...

I have these formats

value categrp

498-502 = 1

748-752 = 2

958-967 = 3

;

and this sql code

proc sql;

create table group as

select invno, ptno, max(group) as group label='group'

from

select i.invno, i.ptno,

input(put(i.dose/v.bot, categrp.),1.) as group

from file1 as i, here as v

quit;

I keep getting an error from the put statement (I have taken apart the code step by step and the put is where the error is occurring). This is the error,

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

I have one data point that is 966 which is the cause of my error. When I delete it, I don't get this error however, I have to keep them. Any help would be appreciated.

Thanks so much, Kristie

--------------------------------- Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.

--------------------------------- Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.