Hi,
I think Option A is correct.Please clarify.
Thanks.
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?
A. A KEEP= data set option used on the SET Statement
B. A KEEP Statement used within the DATA Step
C. A KEEP= data set option used on the DATA Statement
D. A DROP= data set option used on the DATA Statement
Thank you. I am using practice exam and key says Option D.Is that correct?
No.
I think I agree with you that A is the best option. It is better than B or C because you do not spend CPU and memory on reading a lot of data that you do not need, and because you may want to create new variables in the data step. In which case you will not have to worry about the names of your new variables clashing with the names of existing, but unwanted, variables in the table read.
And options A is also better than option D. For two reasons:
I would pick up A.
The best answer is A.
With even partial knowledge of how data step really works you should realize that B,C,D and saying the same thing and so test taking skills should lead you pick A.
Perhaps the test randomizes the order of the choices and you are looking at the wrong answer key?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.