PROC PYTHON vs. PROC LUA question

EyalGonen — Mon, 03 Oct 2022 11:53:06 GMT

Hi experts,

Question is for SAS Viya 2022.9

In PROC LUA one could invoke SAS functions directly for example:

proc lua;
submit;
local dsid = sas.open("sashelp.class")
for row in dsid:rows() do
print(row.age, row.height)
end
dsid:close()
endsubmit;
run;

I am struggling to do the same with PROC PYTHON. For example to invoke the "sas.open" function I found only this way which is kind of cumbersome compared to PROC LUA:

dsid = SAS.sasfnc("open","sashelp.class")

And I could not find the equivalent of "dsid:rows()" in PROC PYTHON.

Am I missing something?

Re: PROC PYTHON vs. PROC LUA question

ChrisHemedinger — Mon, 03 Oct 2022 13:01:00 GMT

For actions specific to working with a data table, I think you would use SAS.sd2df to convert the data set into a pandas data frame, and then use the Python friendly data frame methods.

Otherwise, yes -- I think the way to invoke SAS functions generically from Python is the SAS.sasfnc method -- there isn't a Python-specific wrapper for each SAS function (or even the most commonly used ones).

topic PROC PYTHON vs. PROC LUA question in SAS Programming

PROC PYTHON vs. PROC LUA question

Re: PROC PYTHON vs. PROC LUA question