Statistical Analysis System (SAS) Programming Certification Practice Exam

Which of the following programs correctly reads the Orders data set and creates FastOrdr?

1. data cert.fastordr(drop=ordrtime);

2. data cert.orders(drop=ordrtime);

3. data cert.fastordr(drop=ordrtime);

4. none of the above

The correct answer is: data cert.fastordr(drop=ordrtime);

The correct choice is the first option, as it accurately reflects the intended data manipulation in the context of reading and creating a new dataset. The statement `data cert.fastordr(drop=ordrtime);` performs two key tasks: it specifies that a new dataset called `fastordr` is being created within the `cert` library, and it includes the `drop` option to exclude the variable `ordrtime` from this new dataset. This means that the resulting dataset will not contain the `ordrtime` field, effectively streamlining the data for further analysis or reporting. The other choices do not correctly fulfill the requirements of creating the new dataset named `FastOrdr`. For instance, the second option suggests creating a dataset called `orders`, which does not align with the desired output of creating `fastordr`. Similarly, the third option mistakenly replicates the first option and has the same content, which could cause confusion if interpreted differently. The mention of "none of the above" as an option also does not apply here, as there is a suitable program listed in the first choice. Thus, the first option is the only one that meets the criteria of the question.