A data set stored on a network drive has the following characteristics:
✑ 14 Million observations
✑ 400 numeric variables
✑ 0 character variables of length 20
✑ Binary compression
A DATA Step query requires only 3 character and 15 numeric variables from this data set. What is the best way to reduce computer resource utilization in this
DATA Step?
To reduce computer resource utilization in the DATA Step, the best approach is to use the KEEP= data set option on the SET statement. This ensures that only the required variables (3 character and 15 numeric) are read into the DATA Step, minimizing the amount of data processed and thus saving computational resources. The other options either specify actions that take place after the data is read into the DATA Step or are less efficient.
eventually A? A KEEP= data set option used on the SET Statement