how do i delete certain rows, replace certain cells

aarony — Thu, 17 Apr 2014 22:05:43 GMT

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!

Re: how do i delete certain rows, replace certain cells

ballardw — Thu, 17 Apr 2014 22:17:02 GMT

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';

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