Help using Base SAS procedures

how do i delete certain rows, replace certain cells

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 102
Accepted Solution

how do i delete certain rows, replace certain cells

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!


Accepted Solutions
Solution
‎04-17-2014 06:17 PM
Super User
Posts: 11,343

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

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

View solution in original post


All Replies
Solution
‎04-17-2014 06:17 PM
Super User
Posts: 11,343

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

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 172 views
  • 0 likes
  • 2 in conversation