----|----10---|----20---|----30

 John,FEB,13,25,14,27,Final

 John,MAR,26,17,29,11,23,Current

 Tina,FEB,15,18,12,13,Final

 Tina,MAR,29,14,19,27,20,Current

The following output is desired:

  Obs  Name  Month  Status    Week1   Week2   Week3   Week4   Week5

  1   John   FEB   Final       $$13     $$25     $$14     $$27       .

  2   John   MAR   Current     $$26     $$17     $$29     $$11     $$23

  3   Tina   FEB   Final       $$15     $$18     $$12     $$13       .

  4   Tina   MAR   Current     $$29     $$14     $$19     $$27     $$20

Which SAS program correctly produces the desired output?

  101    data WORK.JANUARY;

  102    set WORK.ALLYEAR(keep=product month num_Sold Cost);

  103    if Month='Jan' then output WORK.JANUARY;

  104    Sales=Cost * Num_Sold;

  105    keep=Product Sales;

                        -----

                        22

  ERROR 22-322: Syntax error, expecting one of the following: !,

                !!, &, *, **, +, -,

  , <=, <>, =, >, >=,

                AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,

                NOTIN, OR, ^=, |, ||, ~=.

  106  run;

What changes should be made to the KEEP statement to correct the errors in the LOG?

The following SAS program is submitted:

  data WORK.TOTAL;

     set WORK.SALARY(keep=Department MonthlyWageRate);

     by Department;

     if First.Department=1 then Payroll=0;

     Payroll+(MonthlyWageRate*12);

     if Last.Department=1;

  run;

Which statement is true?

input exam;

datalines;

50.1

;

run;

proc format;

value score 1 – 50 = ‘Fail’

            51 – 100 = ‘Pass’;

run;

proc report data =course nowd;

column exam;

define exam / display format=score.;

run;

What is the value for exam?

     proc format;

        value agegrp

           low-12 ='Pre-Teen'

           13-high = 'Teen';

     run;

     proc means data=SASHELP.CLASS;

        var Height;

        class Sex Age;

        format Age agegrp.;

     run;

Which statement in the proc means step needs to be modified or added

to generate the following results:

                     Analysis Variable : Height

                    N

   Sex  Age         Obs       Minimum         Maximum            Mean

   ------------------------------------------------------------------

   F    Pre-Teen      3          51.3            59.8            55.8

        Teen          6          56.5            66.5            63.0

   M    Pre-Teen      4          57.3            64.8            59.7

        Teen          6          62.5            72.0            66.8

   --------------------------------------------------------------------

following three worksheets:

    JAN

     FEB

     MAR

Which statement correctly assigns a library reference to the Excel workbook?

 data WORK.TEST;

    set WORK.MEASLES(keep=Janpt Febpt Marpt);

    array Diff{3}  Difcount1-Difcount3;

    array Patients{3} Janpt Febpt Marpt;

 run;

What new variables are created?

data WORK.DATE_INFO;

     X='04jul2005'd;

     DayOfMonth=day(x);

     MonthOfYear=month(x);

     Year=year(x);

run;

What types of variables are DayOfMonth, MonthOfYear, and Year?

data WORK.GEO;

     infile datalines;

     input City $20.;

     if City='Tulsa' then

     State='OK';

     Region='Central';

     if City='Los Angeles' then

     State='CA';

     Region='Western';

datalines;

Tulsa

Los Angeles

Bangor

;

run;

After data step execution, what will data set WORK.GEO contain?

  WORK.ONE

  Num   Char

  ---   ----

    1   23

    3   23

    1   77

The following SAS program is submitted:

proc print data=WORK.ONE;

     where Num='1';

run;

What is output?

The following SAS program is submitted:

data WORK.FEE_STRUCTURE;

     format LocalFee CountryFee percent7.2;

     set WORK.REALESTAT;

     LocalFee=LocalFee/100;

     CountryFee=CountryFee/100;

run;

What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

A. LocalFee has format of 9. and CountryFee has a format of 7.

B. LocalFee has format of 9. and CountryFee has a format of percent7.2

C. Both LocalFee and CountryFee have a format of percent7.2

D. The data step fails execution; there is no format for LocalFee.