ElearnSAS.com

ElearnSAS.com
SAS Learning Platform

Base SAS 25

The following SAS program is submitted:
footnote1 'Sales Report for Last Month';
footnote2 'Selected Products Only';
footnote3 'All Regions';
footnote4 'All Figures in Thousands of Dollars';
proc print data = sasuser.shoes;
footnote2 'All Products';
run;
Which one of the following contains the footnote text that is displayed in the report?
A. All Products
B. Sales Report for Last Month
All Products
C. All Products
All Regions
All Figures in Thousands of Dollars
D. Sales Report for Last Month
All Products
All Regions
All Figures in Thousands of Dollars
Click Comment link to get answer

23 comments:

  1. Anonymous4:54 AM

    footnote 2 (the second one ) will over write the footnote2 and delete the rest of the footnotes 3 and 4 which are higher

    ReplyDelete
  2. Anonymous10:45 AM

    Its B

    ReplyDelete
  3. Anonymous4:13 AM

    The answer is not in included :) it is
    'Sales Report for Last Month';
    'Selected Products Only';
    'All Regions';
    'All Figures in Thousands of Dollars'
    if you run the following in sas you will see!

    data courses;
    exam=50.5;
    run;
    footnote1 'Sales Report for Last Month';
    footnote2 'Selected Products Only';
    footnote3 'All Regions';
    footnote4 'All Figures in Thousands of Dollars';

    proc print data=courses;
    run;
    footnote2 'All Products';

    ReplyDelete
    Replies
    1. Anonymous9:39 PM

      footnote2 'All Products';

      should be before RUN;

      answer is B

      Delete
  4. Anonymous4:24 PM

    Answer is B.
    The second footnote2 statement overrides the previous footnote2 and purges footnote3 and footnote4.

    To the previous commenter, make sure that your RUN statement goes AFTER this line:
    footnote2 'All Products';

    ReplyDelete
  5. Anonymous10:09 AM

    FOOTNOTE n 'text' | "text";

    no arguments

    Cancels all existing footnotes.

    n

    Specifies the relative line to be occupied by the footnote.


    According to me the answer is D

    ReplyDelete
  6. Anonymous6:27 AM

    Does anyone have the "rules" they could post - I know you may have 10 footnotes and any later same-named footnote will override the earlier one but why would the others higher-ordered not print? Thanks.

    ReplyDelete
    Replies
    1. SINGH5:10 PM

      Rule is if you define footnote or title again with any number (here footnote 2 is mentioned again), it will cancel all higher numbered footnote and replace previous on with same number

      Delete
  7. Titles and footnotes stay in effect until you replace them with new ones or cancel them with a null
    statement. The following null statement would cancel all current titles:
    TITLE;
    When you specify a new title or footnote, it replaces the old title or footnote with the same number
    and cancels those with a higher number. For example, a new TITLE2 cancels an existing TITLE3, if
    there is one.


    **** Therefore Answer is B

    ReplyDelete
  8. Anonymous7:57 AM

    Answer is B Footnote2 will be overwritten and footnote3 and 4 will be deleted as they are higher

    ReplyDelete
  9. Anonymous12:29 AM

    Answer is D

    ReplyDelete
  10. Yup! D is the one. The rule is given on the SAS documentation website

    ReplyDelete
  11. Anonymous6:39 AM

    Answer is B

    A FOOTNOTE statement takes effect when the step or RUN group with which it is associated executes. After you specify a footnote for a line, SAS repeats the same footnote on all pages until you cancel or redefine the footnote for that line. When a FOOTNOTE statement is specified for a given line, it cancels the previous FOOTNOTE statement for that line and for all footnote lines with higher numbers.

    http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000214615.htm

    ReplyDelete
  12. b,footnote1 along with footnote2(the later one)

    ReplyDelete
  13. A writer should always try to keep its writing very simple and clear. Always use facts which are easily acceptable by general people because they are very close to their assumptions and they welcome such kind of facts.โปรแกรมขาย

    ReplyDelete