topic SAS add a value into an existing row in SAS Programming

SAS add a value into an existing row

jhusoc — Wed, 05 May 2021 17:55:15 GMT

Hello,

I would like to add value to an existing row.

For example, I have a table,

data mydata;
    input num1 num2 mydate date9.;
    format mydate date9.;
    datalines;
1200 50000 05MAY1985
0 0 17AUG1982
1500 43500 23OCT1991
;
run;

the output:

Obs num1 num2 mydate123

1200	50000	05MAY1985
0	0	17AUG1982
1500	43500	23OCT1991

The second row has 0 and 0. I want to change 0,0 to 1700, 60000. Can I do that use SAS?

Thank you all,

Re: SAS add a value into an existing row

jhusoc — Wed, 05 May 2021 17:57:23 GMT

The real dataset is huge. I cannot make a new table to replace the current one. I just want to add the values to the table. Thanks.

Re: SAS add a value into an existing row

PeterClemmensen — Wed, 05 May 2021 18:08:33 GMT

Sounds like you want to use the Modify Statement

Re: SAS add a value into an existing row

ballardw — Wed, 05 May 2021 18:45:32 GMT

@jhusoc wrote:

Hello,

I would like to add value to an existing row.

For example, I have a table,
data mydata;
    input num1 num2 mydate date9.;
    format mydate date9.;
    datalines;
1200 50000 05MAY1985
0 0 17AUG1982
1500 43500 23OCT1991
;
run;
the output:

Obs num1 num2 mydate123

1200 50000 05MAY1985

0 0 17AUG1982

1500 43500 23OCT1991

The second row has 0 and 0. I want to change 0,0 to 1700, 60000. Can I do that use SAS?

Thank you all,

JH

In your "real" data is it only one record or multiple that need this change?

If more than one record, do they all have the same change or different?

Do you have a variable, or combination of variables, that uniquely identify this record (or other records that need change)?

Re: SAS add a value into an existing row

jhusoc — Wed, 05 May 2021 18:51:27 GMT

Currently. I just have one row that needs to change. But if I know how to change multiple rows, it'll be excellent!
If more than one change, they'll be different.
Yes. I have a unique variable for changing the records.

Thank you!

Re: SAS add a value into an existing row

LeonidBatkhan — Wed, 05 May 2021 22:07:45 GMT

Hi jhusoc,

This may not be the most efficient way to do it, but it is perhaps the simplest:

data mydata;
    input num1 num2 mydate date9.;
    format mydate date9.;
    datalines;
1200 50000 05MAY1985
0 0 17AUG1982
1500 43500 23OCT1991
;
data mydata;
   set mydata;
   if _n_=2 then
   do;
      num1 = 1700;
      num2 = 60000;
   end;
run;

Hope this helps.

Re: SAS add a value into an existing row

ChrisNZ — Thu, 06 May 2021 08:01:48 GMT

Probably not what you need, but since you haven't explained your need on the full data set, this does what you asked for:

data mydata;
  input NUM1 NUM2 MYDATE date9.;
  format MYDATE date9.;
  if NUM1=0 then NUM1=1700;
  if NUM2=0 then NUM1=60000;
  datalines;
1200 50000 05MAY1985
0 0 17AUG1982
1500 43500 23OCT1991
run;