topic Di Studio - Previous Row in SAS Data Management

Di Studio - Previous Row

DavidCaliman — Fri, 27 Dec 2013 02:28:44 GMT

Is possible, using only transformations in DI Studio (without using programming), get the previous record of a data set and implement the logic below?

Input:

1 a

1 b

1 c

2 d

3 e

3 f

Output:

I need to calculate a new column that uses the value from the previous record.

1 a a

1 b a-b

1 c a-b-c

2 d d

3 e e

3 f e-f

Re: Di Studio - Previous Row

LinusH — Sat, 28 Dec 2013 17:01:49 GMT

From your sample (which seems abit inconsistent), I would say no.

If this is a common task, you could package your logic in a User Written Transformation so it could be reused.

But can I question the purpose for this logic? From the little information you give, the calculation doesn't look like anything that needs to be stored in a Data Warehouse process, rather a customized report. Please tell us more about the business requirement for this calculation.

Re: Di Studio - Previous Row

DavidCaliman — Mon, 30 Dec 2013 17:02:05 GMT

I need the following final result:

Input:

cd dsc

1 a

1 b

1 c

2 d

3 e

3 f

Output:

I need to group by code and do a concatenation descriptions.

cd concat

1 a-b-c

2 d

3 e-f

Re: Di Studio - Previous Row

LinusH — Tue, 31 Dec 2013 11:27:06 GMT

Ok, but I still miss the business requirement, and how do you define the rule which values you need to concatenate?

Re: Di Studio - Previous Row

DavidCaliman — Tue, 31 Dec 2013 19:36:06 GMT

I found the answer to this problem on the link below.

I added code in the user written code transformation and it worked.

Thank you.

https://communities.sas.com/message/53141