DATA Step, Macro, Functions and more

Updating a table

Reply
Contributor
Posts: 22

Updating a table

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
Super Contributor
Posts: 578

Re: Updating a table

Posted in reply to saslackey
responded to the other question you posted.
Trusted Advisor
Posts: 2,116

Re: Updating a table

Posted in reply to saslackey
please post your question just once, to one forum. We don't need to see it multiple places.
Contributor
Posts: 22

Re: Updating a table

sorry doc. but i still dint get the right answer. pls help out
Trusted Advisor
Posts: 2,116

Re: Updating a table

Posted in reply to saslackey
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.
Ask a Question
Discussion stats
  • 4 replies
  • 127 views
  • 0 likes
  • 3 in conversation