...
Otherwise; optional to otherwise output other
end;
To avoid errors due to capitalisation, use the upcase or lowcase function, e.g., select (lowcase(<variable>))
To collapse levels of a variable, e.g, to collapse value 3 into 2
...
Inclusive range for IF statement can be achieved with: 5 le <variable> le 7; gives observations between 57 inclusive
Numerical operators
Mean  Arithmetic mean 
Sum  Sum or arguments 
Var  Variance 
Sin  Sine 
Log  Natural log 
SQRT  Square root 
ABS  Absolute value 
Logical operators
Modify where expressions: not / and / or
Eg where city not in('London','Rome','Paris') = city is not London, Rome or Paris
Comparison operators
Equal to  eq  = 
Not equal to  ne 

Less than  lt  < 
Greater than or equal  ge  >= 
Less than or equal  le  <= 
Equal to one of a list  in 

Special where operators (can only be used for where statements)
Operator  Definition  Char  num 
Contains  Includes substring  x 

Between and  Inclusive range  x  x 
Is null  A missing value  x  x 
Is missing  A missing value  x  x 
Like  Matches a pattern  x 

Where same and  Augments original condition  x  x 