Re: Compute stats based on database

edasdfasdfasdfa · Posted 04-23-2021 04:26 PM

Hello,

I was hoping to be able to get some advice on how to check if a correlation of two variables crosses a certain threshold but set a different threshold based on the DB (database). So, a different threshold for DB1 compared to DB2 or DB3.

mkeintz · Posted 04-23-2021 05:26 PM

Why don't you first figure out how to do it with a single database, making sure you have working code that produces the results you want, in the format you want.

Then you can progress to parameterizing your task based on the data source.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Compute stats based on database

Re: Compute stats based on database

SAS Innovate 2025: Call for Content