If I want to select data for every state BUT New York, how do I do that? What are the operands?


#1

If I want to select data for every state BUT New York, how do I do that? What are the operands?


#2

Since New York is assigned the STATEFIP value of 36, you should use the syntax statefip(*-35,37-*) to filter out New York in the Online Data Analysis System. You can find more details about open-ended ranges and other types of selection filters here.

Hope this helps.