Can anyone confirm these statements?

[Marilyn]

2. Use as much criteria as possible in the selection of rows. Every addition to the where clause will shrink the resultant rows.

3. Use correlated queries to combine mulitple years.


I am trying to make my code as efficient as possible since I deal with huge datasets, but I'm new and don't really know what works best.

[LinusH]

Number 1 seems to be missing...?
Number 2 is obvious.
Number 3 depends on your data and what type of result you are looking for. Need more information (like sample input/output data) to comment on that one.

/Linus

[GertNissen]

A candidate for rule number 1 could be : select/keep only the variables you need

[mojerry]

yeah, golden rules 😉

1. Select only the data you really need. So select the needed columns and create a where close who gives you only the relevant data.

2. If working on huge data, indexes can be usefull. Too complicated indexes will kill your performance.

3. Use the right formats on datasets. $200. isn't usefull to store yes or no. Same idea on numbers, don't store them as text 😉

4. data is stored on other disk than your sas work.

5. go on...