topic Re: PROC LUA - Resolving variables in SAS Procedures

PROC LUA - Resolving variables

fetcs74 — Tue, 24 May 2016 10:53:16 GMT

Hello,

I'm building XML files using EGuide and I've being using Proc Lua to pass the values to the XML, via Lua local variables. Now, I have more than 200 variables, so they cannot be defined as local, due to limitations to LUA itself. I tried a different approach that is defining only one local variable and then defining the other as attributes of this one. Something like this:

proc lua;
submit;
  local dsid = sas.open("sashelp.fish") -- open for input            
  local vars = {}
  local count=0

  -- Iterate over the rows of the data set   
  while sas.next(dsid) do
	count = count+1

	local Species
	local fish = {}
        --Working Method 
 	Species = sas.get_value(dsid, "species")

	--Not working method
	fish.species = sas.get_value(dsid, "species")

	sas.submit
		[[
		%Put Non-working: Species =  @fish.species@;
		%Put Working: Species = @Species@;
		]]


   end
   sas.close(dsid)
endsubmit;
run;

Thanks!

Re: PROC LUA - Resolving variables

fetcs74 — Wed, 25 May 2016 08:24:05 GMT

After some tests, I was able to find a solution. Instead of declaring each variable as local, I passed them as parameter when calling sas.submit:

proc lua;
submit;
  local dsid = sas.open("sashelp.fish") -- open for input            
  local vars = {}
  local count=0
  -- Iterate over the rows of the data set   
  while sas.next(dsid) do
	count = count+1

	sas.submit(
		[[
		%Put New working: Species =  @species2@;
		]],{species2=sas.get_value(dsid, "species")})


   end
   sas.close(dsid)
endsubmit;
run;

Note that LUA is case sensitive!

I hope that this can help someone.

Kind regards.

Re: PROC LUA - Resolving variables

ChrisHemedinger — Thu, 26 May 2016 12:50:31 GMT

Glad you got it working! I had reached out to Paul Tomas, the SAS developer who works on PROC LUA -- but he was out these past few days, I think.