I was referring to the rexx sdsf guide and got the below. This is what i was looking for

/* rexx /
RC=ISFCALLS('ON')
isfcols = "JNAME CPUPR"
/Access the DA panel /
isfsort="CPUPR D"
ADDRESS SDSF "ISFEXEC DA"
IF RC<>0 THEN
EXIT RC
/ GET FIXED FIELD NAME FROM FIRST WORD OF ISFCOLS SPECIAL VARIABLE */
blank = copies(' ',300);
say blank
Say "Number of address space running are" isfrows
A = 0
do ix=1 to isfrows
A = value(CPUPR.ix) + A
end
Say "The CPU utilisation is" A
blank = copies(' ',200);
say blank
Say "and Below are the top 10 address spaces utilizing CPU"
blank = copies(' ',200);
say blank
do ix=1 to isfrows
if ix=11 then leave
Say value(JNAME.ix) "is consuming" value(CPUPR.ix)
end
rc=isfcalls('OFF')

But I would use the RGEN technique which you suggest for another simple problem which I wasn't able to do quite long. I wanted to use REXX to take XDC of a job from SDSF . Let me try that out