https://communities.sas.com/t5/SAS-Programming/Updating-a-table/m-p/61612#M13388 You may have to use the strip and upper functions in the event that your data has extra spaces or case difference but, otherwise, you may only need something like:<BR /> [pre]<BR /> data want;<BR /> set have;<BR /> if statename eq "alabama" and associationname eq "FLC"<BR /> then associationname="AL";<BR /> run;<BR /> [/pre]<BR /> HTH,<BR /> Art Wed, 04 May 2011 01:01:15 GMT art297 2011-05-04T01:01:15Z https://communities.sas.com/t5/SAS-Programming/Updating-a-table/m-p/61611#M13387 this is my table(a small example) my table has around 25000 rows<BR /> <BR /> id statename associationname code price<BR /> 1 texas TX 3435 234<BR /> 2 alabama FLC 2342 345<BR /> 3 alabama FLB 35443 345<BR /> 4 alabama ALC 3445 356<BR /> <BR /> Now i want to make changes such that if statename= alabama and associationname=FLC<BR /> <BR /> i want to change associationname to AL<BR /> <BR /> pls help thanks in advance Wed, 04 May 2011 00:35:44 GMT https://communities.sas.com/t5/SAS-Programming/Updating-a-table/m-p/61611#M13387 saslackey 2011-05-04T00:35:44Z https://communities.sas.com/t5/SAS-Programming/Updating-a-table/m-p/61612#M13388 You may have to use the strip and upper functions in the event that your data has extra spaces or case difference but, otherwise, you may only need something like:<BR /> [pre]<BR /> data want;<BR /> set have;<BR /> if statename eq "alabama" and associationname eq "FLC"<BR /> then associationname="AL";<BR /> run;<BR /> [/pre]<BR /> HTH,<BR /> Art Wed, 04 May 2011 01:01:15 GMT https://communities.sas.com/t5/SAS-Programming/Updating-a-table/m-p/61612#M13388 art297 2011-05-04T01:01:15Z