BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
fetcs74
Fluorite | Level 6

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! 

1 ACCEPTED SOLUTION

Accepted Solutions
fetcs74
Fluorite | Level 6

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.

View solution in original post

2 REPLIES 2
fetcs74
Fluorite | Level 6

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.

ChrisHemedinger
Community Manager

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.

Learn from the Experts! Check out the huge catalog of free sessions in the Ask the Expert webinar series.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1812 views
  • 0 likes
  • 2 in conversation