Hello I am trying to use the sashelp.shoes dataset as an input in order to create an output dataset. Additionally, I have to create a new character variable SalesRange, which has the following 3 categories:- -Lower when Sales are less than $100,000. -Middle when Sales are between $100,000 and $200,000, inclusively. -Upper when Sales are above $200,000. Produced below is my code. However, after different combinations of the if then else statements, I keep getting an error saying - Expecting an arithmetic operator and The symbol is not recognized and will be ignored. Any help is much appreciated. Thanks in advance!! data work.shoerange; set sashelp.shoes; if Sales<100,000 then SalesRange="Lower"; if 100,000<=Sales<=200,000 then SalesRange="Middle"; if Sales<200,000 then SalesRange="Upper"; run;
... View more