how do i delete certain rows, replace certain cells

[aarony]

i have a column called  annualreportdate

that column has observations such as dec2012, dec 2010, dec 2011, current

1.)  how do i delete all the rows with current?

1.1) instead of deleting, how do i replace those with 2013?

2) i also want to remove all the dec from dec 2012, dec 2010....and so on.

plz help!

[ballardw · Accepted solution]

One way to remove creating a new data set:

data want;

     set have;

     if annualreportdate="current" then delete;/* have to assume the variable is character if the value is actually "current"*/

/* you also may have to address case if sometimes it is current, Current, or CURRENT, so better would be*/

     if upcase(annualreportdate) = "CURRENT" then delete;

run;

To modify a value:

     if upcase(annualreportdate) = "CURRENT" then <do something>;

could be

     then annualreportdate='2013';

or

     then annualreportdate=tranwrd(annualreportdate,'dec','');