topic Replacing observations in SAS Programming

Replacing observations

PreethamReddy — Sun, 22 Feb 2015 06:48:15 GMT

Hii...

Can anyone tell me how to replace the observations of a particular variable in a data set.?

Re: Replacing observations

Vish33 — Sun, 22 Feb 2015 13:32:26 GMT

i think merge / update will work.

Re: Replacing observations

Vish33 — Sun, 22 Feb 2015 13:35:01 GMT

or if you can provide sample data and output (how you want) , that could be helpful in answering your question.

Re: Replacing observations

PreethamReddy — Mon, 23 Feb 2015 01:41:32 GMT

Hello Vish,

The question is "Create a new data and transform the values of 5 variables(weight, calories, Protein, fat, Satfat). Variables containing Value = 11 will be replaced by the Value of 3 ."

The solution I had tried is

data bittu.junkfood123;

set bittu.junkfood;

WEIGHT = 3;

replace all var {WEIGHT} where (WEIGHT==11);

run;

Iam getting error when I execute my code.

Re: Replacing observations

PreethamReddy — Mon, 23 Feb 2015 01:46:34 GMT

Hello vish,

The Problem that I had is "Create a new data and transform the values of 5 variables(weight, calories, Protein, fat, Satfat). Variables containing Value = 11 will be replaced by the Value of 3 ."

The code that I tried is

data bittu.junkfood123;

set bittu.junkfood;

WEIGHT = 3;

replace all var {WEIGHT} where (WEIGHT==11);

run;

but I am getting error when I execute this...

Re: Replacing observations

arodriguez — Wed, 25 Feb 2015 11:06:07 GMT

I will do something like

data bittu.junkfood123;

set bittu.junkfood;

IF WEIGHT = 11 THEN WEIGHT=3;

run;

Also if you want to do the same for this 5 variables you could use an array

data bittu.junkfood123;

set bittu.junkfood;

array vars{*} weight calories Protein fat Satfat;

do over vars;

if vars=11 then vars=3;

end;

run;