How to replace observations conditionally

shanky_44 — Mon, 17 Jun 2019 22:46:00 GMT

Hello everyone,

I want to change(replace) values in sashelp.class for weight/height/age variables. this is just for understanding the concept. Suppose this our data :

Obs Name Sex Age Height Weight

1 Alfred M 14 69.0 112.5
2 Alice F 13 56.5 84.0
3 Barbara F 13 65.3 98.0
4 Carol F 14 62.8 102.5
5 Henry M 14 63.5 102.5
6 James M 12 57.3 83.0
7 Jane F 12 59.8 84.5
8 Janet F 15 62.5 112.5
9 Jeffrey M 13 62.5 84.0
10 John M 12 59.0 99.5
11 Joyce F 11 51.3 50.5
12 Judy F 14 64.3 90.0
13 Louise F 12 56.3 77.0
14 Mary F 15 66.5 112.0
15 Philip M 16 72.0 150.0
16 Robert M 12 64.8 128.0
17 Ronald M 15 67.0 133.0
18 Thomas M 11 57.5 85.0
19 William M 15 66.5 112.0

I am willing to change weight variable values to 9999 if the observation is between 120 - 150. Thanks for the help!

Re: How to replace observations conditionally

ehmsoleil — Mon, 17 Jun 2019 22:52:05 GMT

data new;

set help.class;

if 120 <= weight <= 150 then weight = 9999;

run;

Re: How to replace observations conditionally

shanky_44 — Mon, 17 Jun 2019 23:08:37 GMT

Thanks, it is working fine.

topic How to replace observations conditionally in SAS Programming

How to replace observations conditionally

Re: How to replace observations conditionally

Re: How to replace observations conditionally