updating a table

[saslackey]

this is my table

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]

proc sql;
update table tablename
set associationname='AL'
where statename='alabama' and associationname='FLC';
quit;

There are other approaches if you have more than you can handle programming manually.

[saslackey]

sorry it is a dataset and not a table

[DBailey]

table/dataset terms mean the same thing in SAS.