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

 

Hello, 

 

I am having some trouble that doesn't seem to makes sense to me.  I have a complex macro in SAS that creates multiple tables and outputs before getting the final results (two html tables and two data tables) all other output/tables are dropped in the macro.  I am able to run this on the SASHELP.cars data set for testing in EG fine and it finishes in seconds.  However, when i try and execute it from the STP WRS on the same dataset, it spins and never shows my output or log or anything.  It spins until the server timeout.   Any thoughts on why this is?   I would share the code but it is very long and not sure if that would help here because it runs and has been thoroughly tested to work in EG.

1 ACCEPTED SOLUTION

Accepted Solutions
hulksmash
Obsidian | Level 7

Hello, 

 

Thanks for the reply.  The two outputs are a proc means output with no modifications, the second output is proc print of a table created using multiple proc sql, proc transpose, and data steps.  I have isolated the proc means on the test data set and it worked no problem.

 

SOLUTION FOUND:  It appears that the issue was caused by using SAS Data Quality Server functions ("dqpattern" in this case).  I am able to run them and load the QKB in EG fine but for some reason I am unable to run them in WRS in a stored process.

 

 

 

View solution in original post

2 REPLIES 2
ballardw
Super User

Without specifics it is hard to determine. I would likely start at how you are telling the output to get places. WRS is different in general.

 

Second would be to examine the code, find the bit that actually generates the output and isolate that for testing with known data.

 

"Complex Multi-step macro" just from the description sort of makes me cringe. Generally I separate data creation for any report writing so debugging of output issues is somewhat easier. As well as isolating destination specific behavior.

 

A programming maxim I learned in the very first class I took:

 

You'll spend 90 percent of your time getting the data correct and the other 90 percent getting the output as desired.

 

Yes that adds to 180 percent, that's the point. Output appearance control, destinations and such can take as much work as the data part, if not more.

hulksmash
Obsidian | Level 7

Hello, 

 

Thanks for the reply.  The two outputs are a proc means output with no modifications, the second output is proc print of a table created using multiple proc sql, proc transpose, and data steps.  I have isolated the proc means on the test data set and it worked no problem.

 

SOLUTION FOUND:  It appears that the issue was caused by using SAS Data Quality Server functions ("dqpattern" in this case).  I am able to run them and load the QKB in EG fine but for some reason I am unable to run them in WRS in a stored process.

 

 

 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 741 views
  • 0 likes
  • 2 in conversation