So if you have many variables, how can you define them without having to write out each one in the input statement? I know that once you have them defined initially you can use variable lists and there are many other options like using _ALL_ , _NUMERIC_ etc, but how about initially. Do you have to type out 20 different variables?     ... View more

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.     ... View more

I guess this would depend on which industry they worked in but what would the main day-to-day jobs/roles require.   It doesn't seem like a data analyst type role but more of a statistical programmer?       ... View more

What is an externally allocated libref?     ... View more

So I'm reading this (below) in the documentation... In BY-group processing, you can use data that is arranged in an order other than alphabetic or numeric, such as by calendar month or by category. To do this, use the NOTSORTED option in a BY statement when you use a SET statement. The NOTSORTED option in the BY statement tells SAS that the data is not in alphabetic or numeric order, but that it is arranged in groups by the values of the BY variable. You cannot use the NOTSORTED option with the MERGE statement, the UPDATE statement, or when the SET statement lists more than one data set.   I'm trying to wrap my head around the idea of when to use NOTSORTED.   So, is NOTSORTED literally only used when you haven't sorted your data-set so you are indicating that the values themselves dictate grouping not the order?         ... View more