SAS Di JOB

[JJP1]

Hi ,
Here two datastep statemnets.one is getting the number of records.
another is looping step.so i want to do it using SAS Di transformations.any other option other than user written code please.
i know theoritically i can use loop transfomration but please help more on this how can i achieve this in SAS DI please

data _null_
;
call symputx('tablecount',nobs)
;
set table nobs=nobs
;
stop
;
run
;

%macro macro1
;
%do countloop=1 %to &tablecount
;
data _null_
;
point=&countloop
;
set table point=point
;
call symputx('table_name',cats(libname,'.',memname))
;
stop
;
run
;

[Kurt_Bremser]

What are you doing with the macro variable &table_name?

My suspicion is that you would be much better off doing this:

%macro macro1(table_name);
/* your processing here */
%mend;

data _null_;
set table;
call execute('%nrstr(%macro1(' !! catx('.',libname,memname) !! '))');
run;

[JJP1]

Thanks @Kurt_Bremser.

&table_name is further being used to sort the data.Would you please help how can i do in using SAS DI please

[Kurt_Bremser]

So you want to sort tables? DI Studio has a transformation for that, so use that. And the mechanisms DI Studio provides for repeating tasks.

Since one of the main reasons for using Data Integration is to keep an eye on the sequence of processing (and inheritance of attributes), you need to define the transformation for every single dataset anyway, otherwise DI loses track of the information.

You need to accept the fact that GUI applications like DI Studio will always have limited capabilities, as you can't have a wizard for each imaginable programming trick. OTOH, they automate lots of things for you. See Maxim 45.

[JJP1]

thank you @Kurt_Bremser  i need to develop job using below code in SAS DI please.
how can i do this.so that i can use sort transformation further on this please

%macro macro1
;
%do countloop=1 %to &tablecount
;
data _null_
;
point=&countloop
;
set table point=point
;
call symputx('table_name',cats(libname,'.',memname))
;
stop
;
run
;
data _null_
;
call symputx('tablecount',nobs)
;
set table nobs=nobs
;
stop
;
run
;

[Kurt_Bremser · Accepted solution]

My take is that you can't. Insert the sort transformation in each processing chain where it is needed.

You either work with the tools DI Studio gives you, or with code you write. Select which is better for your organisation.