By admin | August 11, 2009

SAS Certified Adv Programmer 50 Questions (9)

Table One has five million observations. Table Two has one thousand observations. These tables have identical column attributes. Concatenating tables One and Two should result in 5,001,000 observations.

Which one of the following SAS techniques uses the least CPU time and I/O operations to process?

a. the APPEND procedure
b. the SET statement in the DATA step
c. the INSERT INTO statement in the SQL procedure
d. the OUTER UNION CORR operator in the SQL procedure

2 comments | Add One

  1. admin - 08/11/2009 at 3:18 pm

    A

  2. Consty - 02/12/2013 at 6:06 pm

    A: because only one dataset is read in the PDV

Leave a Comment

Leave a Reply

Your email address will not be published.