roznica<1000 indicates that roznica field would be numeric to be, but then you reassign it a value of 'Rank1' which is character. As long as you realize that 200>1000 in character language I guess the following is what you want in terms of programming. Logically it doesn't make sense to me. You have an additional bracket, are missing the end and are also missing the semicolon at the end. In terms of the IDE, I don't believe that the case and other key words are coloured when using it in an update statement, but it still works. proc sql; update anacars.rabat set roznica= case <------------------------------------------ when roznica <'1000' then 'Rank1' end; select * from anacars.rabat;
... View more