topic Re: Creating a new variable and changing some values in SAS Enterprise Guide

Creating a new variable and changing some values

GDumont — Fri, 22 Feb 2019 14:53:04 GMT

Hi, everybody!

I have a variable which must be descending, but I have some values that brokes this rule. For example:

Have

100

90 <---

80 <---

75 <---

For these guys, I want substitute in a new variable for missing. This way:

Have Want

100 100

90 90

85 85

80 80

90 <--- .

70 70

90 <--- .

80 <--- .

75 <--- .

60 60

50 50

I worked hard, but I couldn't. Anyone can help me?

Thanks!

Re: Creating a new variable and changing some values

Astounding — Fri, 22 Feb 2019 15:05:58 GMT

One way:

data new;

set old;

if _n_=1 then last_valid = have;

retain last_valid;

if have <= last_valid then do;

last_valid = have;

want = have;

end;

run;

It's untested code, so you will have to see if it works for you.

Re: Creating a new variable and changing some values

Kurt_Bremser — Fri, 22 Feb 2019 15:09:22 GMT

Use the lag() and ifn() functions:

want = ifn(have > lag(have) and _n_ ne 1,.,have);

Edit: took care of the first data step iteration (thanks to @Astounding for bringing that to my attention).

Re: Creating a new variable and changing some values

novinosrin — Fri, 22 Feb 2019 15:09:52 GMT

data have;
input n;
cards;
100
90
85
80
90
70
90 
80
75 
60
50
;

data temp;
set have;
retain want;
if _n_=1  then want=n;
else if n<want then want=n;
run;

data want;
set temp ;
by want notsorted;
if not first.want then call missing(want);
run;

Re: Creating a new variable and changing some values

Ksharp — Sat, 23 Feb 2019 11:37:52 GMT

data have;
input n;
cards;
100
90
85
80
90
70
90 
80
75 
60
50
;
data want;
 set have;
 retain min 99999;
 min=min(min,n);
 if min<n then call missing(n);
 drop min;
run;

Re: Creating a new variable and changing some values

Ksharp — Sat, 23 Feb 2019 11:41:15 GMT

data have;
input n;
cards;
100
90
85
80
90
70
90 
80
75 
60
50
;
data want;
 set have;
 retain min 99999;
 min=min(min,n);
 if min<n then call missing(n);
 drop min;
run;