where substr (name,1,3) = 'Mac' and (city='Charleston' or city='Atlanta'); run; Note: SAS functions used in a WHERE expression that can be optimized by an index are the SUBSTR function and the TRIM ...

In a SAS program, a date value can also be declared either as a numeric or a character variable. Here is the date declared as numeric variables: The "substr" function in SAS describes the position ...

when the item is part of generated SAS statements. The item is returned as an unquoted result by the %SCAN, %SUBSTR, or %UPCASE function. (To retain a value's masked status during one of these ...