Note: The SQL procedure displays the variable labels as stored in the view. However, because you are referencing a view descriptor, you must use the SAS variable names in the WHERE clause, not the ...
just some info for anyone else who's not a sql guru:<BR><BR>i did the following selection on a table:<BR><BR>SELECT * FROM Table WHERE myField <> 'active'<BR><BR>the values in that colum are a mix of ...