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

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

VVDR — Wed, 30 Sep 2020 09:50:25 GMT

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

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

LinusH — Wed, 30 Sep 2020 13:38:25 GMT

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.