DATA Step, Macro, Functions and more

tuning help needed for PROC SQL

Frequent Contributor
Posts: 124

tuning help needed for PROC SQL

[ Edited ]

Hi SAS Users,


I needed some help on tuning this below query to run faster, currently run time for this 6 hours.



sorry, this has been resolved. Thanks for the answer .




Super User
Posts: 24,010

Re: tuning help needed for PROC SQL

Max of a diagnosis code seems a weird criteria...


Have you tried a PROC MEANS output instead? Those should be fairly optimized.

Super Contributor
Posts: 288

Re: tuning help needed for PROC SQL

Hi Ana,


Tuning SQL queries sometimes involves more than just changing the syntax!

Depending if the data being queried is coming from 

- Table / View

- SAS or RDBMS (Relational Database Management System)


Can you share more information beside the query, so we can direct you in the right way?

Sometimes configurations/options settings changes could affect the response time.


The more we know, the better the advice/help can be.


Just my 2 cents,


Ask a Question
Discussion stats
  • 2 replies
  • 3 in conversation