topic Re: Assigning value of one variable to other variable in SAS Programming

Assigning value of one variable to other variable

sg_kr — Tue, 18 Jun 2019 15:50:00 GMT

Hi,

i have a dataset like below

Name	Points
x	10
y	5
z	20

i want to add the points of x to y, (result dataset should be like below)

Name	Points
x	10
y	15
z	20

can any one suggest me on this.

thanks

Re: Assigning value of one variable to other variable

Kurt_Bremser — Tue, 18 Jun 2019 16:03:19 GMT

data have;
input name $ points;
datalines;
x 10
y 5
z 20
;

data want;
set have;
_points = lag(points);
if name = 'y' then points = points + _points;
drop _:;
run;

Re: Assigning value of one variable to other variable

sg_kr — Tue, 18 Jun 2019 16:30:27 GMT

Thanks for Rapid response.

this will work only when the y record is next to x.

if i have any other record between x and y , it wont work.

Name	Points
x	10
a	1
y	5
z	20

i want like below.

Name	Points
x	10
a	1
y	15
z	20

in my case, i dont have records next to each other, i need to capture the value of one record based on the name and summ it other record based on name.

thanks.

Re: Assigning value of one variable to other variable

Kurt_Bremser — Tue, 18 Jun 2019 18:30:32 GMT

Then we do not use lag(), but a retained variable:

data want;
set have;
retain _points;
if name = 'x' then _points = points;
if name = 'y' then points = points + _points;
drop _:;
run;

Re: Assigning value of one variable to other variable

sg_kr — Wed, 19 Jun 2019 14:00:54 GMT

thanks.
but i am getting . value in the points for below line
if name = 'y' then points = points + _points;

Re: Assigning value of one variable to other variable

Kurt_Bremser — Wed, 19 Jun 2019 14:47:27 GMT

If there are situations with missing values, use the sum() function in place of a simple addition.

Re: Assigning value of one variable to other variable

sg_kr — Thu, 20 Jun 2019 11:12:01 GMT

yes, i did .

but no use

Re: Assigning value of one variable to other variable

Kurt_Bremser — Thu, 20 Jun 2019 11:21:45 GMT

@sg_kr wrote:

yes, i did .

but no use

Which only means that all arguments to the sum() function are missing. If you want to set zero in such cases, add a single zero as argument to the function.