Wednesday, May 1, 2013

Base SAS Certification Sample Question 12.1

I hope the below Base SAS Certification sample question is helpful to you when you're studying for the exam. Leave your answer as a comment below and good luck!

-SAS Cert


*****************************


Which of the following is false about one-to-one merging?

a) The new dataset contains all variables from all input data sets
b) If there are same-named variables, the last dataset's variable replaces the earlier dataset's variable
c) The new dataset contains the total number of observations in the smallest original dataset
d) None of the above

14 comments:

  1. This comment has been removed by the author.

    ReplyDelete
    Replies
    1. C. one-to-one merging
      creates observations that contain all of the variables from each contributing data set. combines observations based on their relative position in each data set.

      Delete
  2. Ans - D
    Options A,B and C are true for one to one merging.

    ReplyDelete
  3. shouldn't the ans be A as same name variables from different datsets will not be repeated, thus leaving some of the variables(with same name).

    ReplyDelete
  4. ASKING --- false about one-to-one merging-----

    answer is C.

    ReplyDelete
  5. Ans D -
    C is not right. Please refer to the link below
    http://support.sas.com/documentation/cdl/en/basess/58133/HTML/default/viewer.htm#a001318478.htm

    ReplyDelete
  6. C, one to one MERGING, not one to one READING

    ReplyDelete
  7. For latest and updated SAS certification dumps in PDF format contact us at completeexamcollection@gmail.com.
    Refer our blog for more details http://completeexamcollection.blogspot.in/2015/12/sas-certification-dumps.html

    ReplyDelete
  8. According to sas base prep guide, the following is called one-to-one merging:
    data one2one;
    set a;
    set b;
    run;

    In this case, the number of observations in the new data set is the number of observations in the smallest original data set.

    On the other hand, in SAS online documentation, the following is called one-to-one merging:
    data one2one;
    merge a b;
    run;

    In this case, the number of observations in the new data set is equal to the number of observations in the largest data set named in the MERGE statement.

    So the question is ambiguous.

    ReplyDelete
  9. Nice & Informative Blog !
    you may encounter various issues in QuickBooks that can create an unwanted interruption in your work. To alter such problems, call us at QuickBooks Customer Service Number 1-855-974-6537 and get immediate technical services for QuickBooks in less time.

    ReplyDelete