topic Re: Data manupulation in SAS Programming

Data manupulation

rnmishra — Tue, 18 Jun 2013 16:47:28 GMT

The data set 'have' is

Data have;

input a b;

datalines;

1 3

2 4

2 5

2 4

3 2

4 7

4 8

5 1

6 8

6 7

;

Now I want to create a data set want from have to see if there is change in b within each level of a.

So that my new data set want will have an additional variable Change and should look like this.

Want

a b Change

1 3 No

2 4 Yes

2 5 Yes

2 4 Yes

3 2 No

4 7 Yes

4 8 Yes

5 1 No

6 8 Yes

6 7 Yes

Any help would be highly appreciated.

Thanks.

Re: Data manupulation

PGStats — Tue, 18 Jun 2013 17:03:40 GMT

Simple with SQL and remerging :

proc sql;

create table want as

select *, case when range(b)>0 then "Yes" else "No" end as Change

from have

group by a;

quit;

Re: Data manupulation

Linlin — Tue, 18 Jun 2013 17:10:42 GMT

Data have;

input a b;

datalines;

1 3

2 4

2 5

2 4

3 2

4 7

4 8

5 1

6 8

6 7

;

proc sql;

create table want

as select *, case

when min(b)=max(b) then 'no'

else 'yes'

end as change

from have

group by a;

quit;

proc print;run;