topic Re: sequence no based on an input field in SAS Data Management

sequence no based on an input field

Sandhyaa — Tue, 12 Feb 2013 10:07:03 GMT

src Col	seq no
a	1
a	2
a	3
b	1
b	2
c	1

Based on one of the source columns, a sequence no has to be generated. If the source value changes, then the sequene no must start from one.

Is this is possible in SAS DI without using user-written transformation?

Re: sequence no based on an input field

LinusH — Tue, 12 Feb 2013 10:23:48 GMT

Not really, maybe by using some extensive logic using Group By and monotonic(), but that would probably be more difficult to understand, than a simple user written using by - first. logic.

Re: sequence no based on an input field

Jagadishkatam — Tue, 12 Feb 2013 12:49:25 GMT

Hi Sandhyaa,

I am not sure if it is possible to get the seq no as you want in DI studio without coding. May be other members can you help you if they have come across similar situation.

Here is a small piece of code which i hope can help you

data have;

input src_col $;

datalines;

;

proc sort data=want;

by src_col;

run;

data want;

set have;

retain seq_no;

by src_col;

if first.src_col then seq_no=1;

else seq_no+1;

run;

Thanks,

Jagadish