topic Re: updating a table in SAS Procedures

updating a table

saslackey — Wed, 04 May 2011 00:05:10 GMT

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

Re: updating a table

DBailey — Wed, 04 May 2011 01:03:09 GMT

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.

Re: updating a table

saslackey — Wed, 04 May 2011 01:05:38 GMT

sorry it is a dataset and not a table

Re: updating a table

DBailey — Wed, 04 May 2011 01:57:37 GMT

table/dataset terms mean the same thing in SAS.