data work.ifthen;
set work.pelicanstores;
if Net_Sales < 50 THEN Sales = "0-$50";
ELSE IF Net_Sales > 51 AND < 100 Sales = "$51-$100";
ELSE IF Net_Sales > 100 AND <200 Sales = "$101-$200";
ELSE IF Net_Sales > 200 Sales ="$200+";
Run; I run clear through the IF, but I am getting an error on my first ELSE . ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, arrayname, (, +, -, INPUT, NOT, PUT, ^, _NEW_, ~. I cannot figure out what's wrong with my syntax. Can anyone help? My objective is to group Net_Sales into categories so they display nicely on Cross Tab. Thanks for your help
... View more