← Back to exam page

A00-215 – SAS Certified Associate: Programming Fundamentals Using SAS 9.4

Loading demo links...

Showing 4–6 of 10 questions

Question 4

Given the input data set INVENTORY as shown below:

Two output data sets are desired, CHIPS and OTHERSNACKS.

*The CHIPS data set should only include QtySold, Price, and Product.

*The OTHERSNACKS data set should include QtySold, Price, product, and Type.

Which Data step creates the two desired output data sets

Select an option, then click Submit answer.

  • ○

    data chips othersnacks; set: inventory; if Type="chips" then do; keep QtySold Price Product; output chips; end; else output othersnacks; run;

  • ○

    data chips ( keep=QtySold Price Product) othersnacks; set inventory; if Type="chipa" then output chips; else output otharsnacks; run;

  • ○

    data chips otharsnacks; set inventory; if Type="chips" then output chips else output otharsnacks; keep QtySold Price Product; run;

  • ○

    data chips othersnack" set inventory (keep=QtySold Price Product); if Typo~"chips" then output chips; else output othersnacks;
    run;


Question 5

Given the report shown below:

Which PROC PREQ step creates the frequency report?

Select an option, then click Submit answer.

  • ○

    proc freq data= cars; tables make drivetrain; run;

  • ○

    proc freq data= cars; tables make *drivetrain; run;

  • ○

    proc freq data- cars; tables drivetrain make; run;

  • ○

    proc freq data- cars; tables drivetrain* make;
    run;


Question 6

What type of error does NOT produce the expected results and does NOT generate errors or warnings in the log?

Select an option, then click Submit answer.

  • ○

    Syntax error

  • ○

    Logic error

  • ○

    Special error

  • ○

    Data error