topic Re: calculation of new variables in New SAS User

calculation of new variables

efi88 — Mon, 11 Mar 2019 15:05:20 GMT

Hi,

I'm trying to calculate new variables based on other variables from different row of specific value.

For example:

my_data:

name string value

name	string	value
aba	aaaaa	12
baba	bbbbb	84
caca	cccc	65
gaga	ddddd	52

wanted_data

name	string	value	diff
aba	aaaaa	12
baba	bbbbb	84	72
caca	cccc	65	44
gaga	ddddd	52	40

The calculation of the new variable diff:

84-12

65-12

52-12

Please advice,

Thank you!

Re: calculation of new variables

tomrvincent — Mon, 11 Mar 2019 15:11:17 GMT

use the 'retain' command.

Re: calculation of new variables

novinosrin — Mon, 11 Mar 2019 15:28:11 GMT

data have;
input name$	string$	value;
cards;
aba	aaaaa	12
baba	bbbbb	84
caca	cccc	65
gaga	ddddd	52
;

data want;
set have;
if _n_=1 then do; t=value;diff=0;end;
else diff=value-t;
retain t;
drop t;
run;

Re: calculation of new variables

pb82477 — Mon, 11 Mar 2019 15:17:25 GMT

efi88: As has already been stated, the retain statement should be a big help.

However, it appears that you have an error in your 'wanted data'. For name 'caca', according to your specified formula, the result should be 53 (65-12), not 44 as shown.

Best Wishes.

Re: calculation of new variables

PeterClemmensen — Mon, 11 Mar 2019 15:26:15 GMT

data have;
input name $	string $	value;
datalines;
aba	aaaaa	12
baba	bbbbb	84
caca	cccc	65
gaga	ddddd	52
;

data want(drop=v);
   set have;
   if _N_=1 then v=value;
   diff=value-v;
   retain v;
run;

Re: calculation of new variables

novinosrin — Mon, 11 Mar 2019 15:47:17 GMT

@efi88 Also, you could use a conditional set to mimic retain

data have;
input name$	string$	value;
cards;
aba	aaaaa	12
baba	bbbbb	84
caca	cccc	65
gaga	ddddd	52
;
data want;
set have;
if _n_=1 then set have(keep=value rename=(value=t));
diff=value-t;
drop t;
run;