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
;
... View more
