topic tuning help needed for PROC SQL in SAS Programming

tuning help needed for PROC SQL

SASAna — Thu, 09 Nov 2017 20:48:51 GMT

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 .

Thanks,

Ana

Reeza — Thu, 09 Nov 2017 18:10:39 GMT

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

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

AhmedAl_Attar — Thu, 09 Nov 2017 19:26:01 GMT

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,

Ahmed