topic Re: update sepcific observation in a dataset in SAS Programming

update sepcific observation in a dataset

BrahmanandaRao — Sun, 26 Mar 2023 06:28:52 GMT

data march;
input id name$ score;
datalines;
1 aaa 55
2 bbb 77
3 ccc 22
4 ddd  p
5 eee  4
6 ff   k
;
run;

/* update values above datasets */

data march;
modify march;
if score=p then score=98;
run;

hi i want to update value of score where score= p then i want change 98 but above update where character value i want only required value to change

Re: update sepcific observation in a dataset

Kurt_Bremser — Sun, 26 Mar 2023 07:08:54 GMT

Your first DATA step needs fixing. Do that first.

Re: update sepcific observation in a dataset

Kurt_Bremser — Sun, 26 Mar 2023 07:17:43 GMT

And your second data step will only work if there is a variable named p in your dataset.

Re: update sepcific observation in a dataset

Astounding — Sun, 26 Mar 2023 11:53:40 GMT

To get your first DATA step to work, add a MISSING statement:

data march;
missing p k;
input id name$ score;
datalines;
use the same data you are using now
;

This lets you store p and k as numeric values without needing to change anything to 98. In fact, changing them to 98 would cause problems later. For example, when you calculate the average score, values of 98 would affect the average.

Re: update sepcific observation in a dataset

PaigeMiller — Sun, 26 Mar 2023 13:36:18 GMT

This is obviously a made up problem, but changing an invalid value, like the letter P, to a valid value, is a very poor practice. Better you should leave the P as missing, SAS does the correct things when it encounters a missing value. SAS will probably not do the correct things when it finds a 98.