topic Re: creating new rows. based on existing rows in SAS Procedures

creating new rows. based on existing rows

thdang — Thu, 11 Apr 2013 18:34:55 GMT

Hi, I have a time-series data of the following and I would like to add new id to the table using the existing id. How can i do this? Thank you very much.

date ID value

.....

want to add:

01/31/1985 0-9 (6201-4183)

02/28/1985 0-9 (6505-4303)

...

Re: creating new rows. based on existing rows

PaigeMiller — Thu, 11 Apr 2013 19:18:28 GMT

data abc;

set abc;

output;

if id=0 or id=9 then output;

run;

Re: creating new rows. based on existing rows

thdang — Thu, 11 Apr 2013 19:24:30 GMT

this one just duplicated the id number 0 and 9. I would like to create new id 10 that has the different of 0 and 9 as value

Re: creating new rows. based on existing rows

ballardw — Thu, 11 Apr 2013 19:55:14 GMT

Is this what you want, assumes ID always has values of 0 through 9 AND value exists for each:

data want;

set have;

if ID = 9 then do;

output;

ID=10;

value=dif9(value);

output;

end;

else output;

run;

Re: creating new rows. based on existing rows

Astounding — Thu, 11 Apr 2013 19:59:38 GMT

Well, if ID and VALUE are numeric variables, you will be limited as to what you place in there. But here is an approach.

data want;

set have;

by date;

if first.date then do;

original_id = id;

original_value = value;

retain original_id original_value;

end;

output;

if last.date then do;

id = 90000 + 100 * original_id + id;

value = value - original_value;

output;

end;

drop original_id original_value;

run;

Good luck.

Re: creating new rows. based on existing rows

thdang — Thu, 11 Apr 2013 20:16:35 GMT

Thanks!.