How do I Update multiple fields of a record

Deb4 — Tue, 13 Sep 2022 14:47:08 GMT

How do I change the values of age and salary both for Matt?
Can it be done using if statement?
data people;
input name $ age salary;
datalines;
Timothy 25 1200
Mark 30 1500
Matt 29 1600
;
run;

Re: How do I Update multiple fields of a record

ballardw — Tue, 13 Sep 2022 15:27:34 GMT

How many of these records need to be updated? Is the Name duplicated?

If you only have a few of these then perhaps an "if" is appropriate: an example with made up values since you did not provide any.

The key with multiple variables is to place the assignment statements inside a Do/ End block.

data want;
   set people;
   if name='Matt' then do;
      age=45;
      salary= 1850;
   end;
run;

If you have a lot of these and the new values are in a data set you have options but that will depend on whether Name, or any combination of variables used to identify a record, only occurs once or multiple times in the data set.

topic How do I Update multiple fields of a record in New SAS User

How do I Update multiple fields of a record

Re: How do I Update multiple fields of a record