How to map Base sas code with multiple set statements in SAS DI

[VVDR]

Hi,

I am using SAS DI and I want to map below sas code into DI transformation. Please help me here. 

Ex:

Data Test1;

   set Test2;

   Set Test3;

keep Var1 var2;

Digita=0;

Digitx=0;

Digity=0;

digitz=Total;

new_digit=0;

/*do unitl*/

do until (digita=digitb);

if digitx=&mcarovar then digitx=49;

digity+1;

digitx+1;

digita+1;

Rec_digit=digita;

Branch_digit=digitx;

output;

end;

run;

For now I am using user written transformation.

But curious to know how can we do that in SAS DI. 

Thanks 

[LinusH]

If you wan to to use a SAS supplied transformation instead, it would require you to be able to transform this code to SQL. Not sure what it does, but suspect it would be hard?

If this is a program pattern, the second best to do is to create a user Written transformation which you could resuse.

Otherwise you are stick to User Written. But by doing so, be sure to use as much of the DI Studio supplied macro variables as possible in your code, such as _input and _output.