Updating a table

[saslackey]

this is my table(a small example) my table has around 25000 rows

id statename associationname code price
1 texas TX 3435 234
2 alabama FLC 2342 345
3 alabama FLB 35443 345
4 alabama ALC 3445 356

Now i want to make changes such that if statename= alabama and associationname=FLC

i want to change associationname to AL

pls help thanks in advance

[DBailey]

responded to the other question you posted.

[Doc_Duke]

please post your question just once, to one forum. We don't need to see it multiple places.

[saslackey]

sorry doc. but i still dint get the right answer. pls help out

[Doc_Duke]

Both the SQL and the DATA step solutions that you got look like they should work. That means that we didn't understand the question. You probably need to provide both the input and the output data sets as examples.