topic Re: Updating a table in SAS Programming

Updating a table

saslackey — Wed, 04 May 2011 00:28:50 GMT

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

Re: Updating a table

DBailey — Wed, 04 May 2011 01:04:13 GMT

responded to the other question you posted.

Re: Updating a table

Doc_Duke — Wed, 04 May 2011 01:07:35 GMT

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

Re: Updating a table

saslackey — Wed, 04 May 2011 01:09:26 GMT

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

Re: Updating a table

Doc_Duke — Wed, 04 May 2011 01:45:28 GMT

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.