topic Re: Help with Retain in SAS Programming

Help with Retain

hhchenfx — Sat, 09 Nov 2013 00:12:48 GMT

Hello Everyone,

I want to group observation anytime variable "time" in my data reach value 1 and group=group +1

So basically, the Want file should be the original added 1 more variable name group as below.

1 2 1

2 3 1

3 2 1

1 6 2

2 9 2

3 6 2

4 9 2

1 9 2

2 1 3

3 1 3

I guess the retain should be used but I am not sure how to get the result I want.

Any help is very much appreciated.

Have a nice weekend.

HHC

data want;

input time value;

datalines;

1 2

2 3

3 2

1 6

2 9

3 6

4 9

1 9

2 1

3 1

;run;

Re: Help with Retain

art297 — Sat, 09 Nov 2013 00:58:22 GMT

You weren't very clear about what you are trying to accomplish, thus I'll just guess:

data have;

input time value;

datalines;

1 2

2 3

3 2

1 6

2 9

3 6

4 9

1 9

2 1

3 1

;

run;

data want;

set have;

if _n_ eq 1 then group=1;

if time lt lag(time) then group+1;

run;

Re: Help with Retain

RichardinOz — Sat, 09 Nov 2013 02:28:18 GMT

hhchenfx

Where Art uses group + 1 that implies the statement (automatically)

retain group ;

Richard

Re: Help with Retain

Jagadishkatam — Sat, 09 Nov 2013 12:14:59 GMT

The code of sir Arthur is good. Here is just an alternative.

data have;

input time value;

order=_n_;

datalines;

1 2

2 3

3 2

1 6

2 9

3 6

4 9

1 9

2 1

3 1

;

run;

proc sort data=have;

by time ;

run;

data want;

set have;

retain count;

by time;

if first.time then count=1;

else count+1;

run;

proc sort data=want;

by order;

run;

Thanks,

jagadish

Re: Help with Retain

hhchenfx — Sat, 09 Nov 2013 16:19:45 GMT

Thank you for your help.

I got it.

Have a nice weekend.

HHC