SAS Institute A00-201 Online Practice Questions and Exam Preparation

SAS Institute A00-201 Online Questions & Answers

• Question 61:

  The following SAS program is submitted:

  data work.empsalary;

  set work.people (in = inemp)

  work.money (in = insal);

  if insal and inemp;

  run;

  The SAS data set WORK.PEOPLE has 5 observations, and the data set WORK.MONEY has 7 observations. How many observations will the data set WORKEMPSALARY contain?

  B. 5
  C. 7
  D. 12
  A

• Question 62:

  The following SAS program is submitted:

  data work.accounting; set work.dept1 work.dept2; run;

  A character variable named JOSCODE is contained in both the WORK.DEPT1 and WORK.DEPT2 SAS data sets. The variable JOSCODE has a length of 5 in the WORK.DEPT1 data set and a length of 7 in the WORPK.DEPT2 data set.

  Which one of the following is the length of the variable JOBCODE in the output data set?

  A. 5
  B. 7
  C. 8
  D. 12
  A. 5

• Question 63:

  The following SAS program is submitted: I

  ibname company `SAS-data-library';

  proc sort data = company.payroll;

  by EmployeelDNumber;

  run;

  Write access has been granted to the COMPANY library.

  Which one of the following represents how the observations are sorted?

  A. COMPANY.PAYROLL is recreated in sorted order by EmployeelDNumber.
  B. COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by EmployeelDNumber.
  C. COMPANYPAYROLL is stored in original order, and a new data set COMPANY.PAYROLLSORTED is created in sorted order by EmployeelDNumber.
  D. COMPANY.PAYROLL is recreated in sorted order by EmployeelDNumber, and a new data set PAYROLL is created in sorted order by Emp loyeelDNumber.
  A. COMPANY.PAYROLL is recreated in sorted order by EmployeelDNumber.

• Question 64:

  The following SAS program is submitted:

  proc freq data = sales; run;

  Click the Exhibit button to view the output from the FREQ procedure.

  

  Which one of the following statements completes the program and produces the output?

  A. tables region product
  B. tables region * product
  C. tables product region;
  D. tables product * region;
  B. tables region * product

• Question 65:

  When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:

  Iibname sasdata `SAS-data-Iibrary';

  options obs = 500;

  proc print data = sasdata.prdsales (firstobs = 100); run;

  options obs = max;

  proc means data = sasdata.prdsales (firstobs = 500); run;

  How many observations are processed by each procedure?

  A. 400 for PROC PRINT 4500 for PROC MEANS
  B. 401 for PROC PRINT 4501 for PROC MEANS
  C. 401 for PROC PRINT 4500 for PROC MEANS
  D. 500 for PROC PRINT 5000 for PROC MEANS
  B. 401 for PROC PRINT 4501 for PROC MEANS

• Question 66:

  The following SAS program is submitted:

  data_null;

  set old;

  put sales 1 sales2;

  run;

  Where is the output written?

  A. the SAS log
  B. the raw data We that was opened last
  C. the SAS output window or an output file
  D. the data set mentioned in the DATA statement
  A. the SAS log

• Question 67:

  The following SAS program is submitted:

  data work.test;

  Title = `A Tale of Two Cities, Charles J. Dickens'; Word = scan(title,3,' ,`);

  run;

  Which one of the following is the value of the variable WORD in the output data set?

  A. T
  B. of
  C. Dickens
  D. ``(missing character value)
  B. of

• Question 68:

  The following SAS program is submitted;

  data work.month; date = put('13mar2000'd,ddmmw10.); run;

  Which one of the following represents the type and length of the variable DATE in the output data set?

  A. numeric, 8 bytes
  B. numeric, 10bytes
  C. character, 8 bytes
  D. character, 10 bytes
  D. character, 10 bytes

• Question 69:

  When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:

  libname sasdata `SAS-data-library';

  options obs = 500;

  proc print data = sasdata.prdsales (firstobs = 100); run;

  options obs = max;

  proc means data = sasdata.prdsales (firstobs = 500); run;

  How many observations are processed by each procedure?

  A. 400 for PROC PRINT 4500 for PROC MEANS
  B. 401 for PROC PRINT 4501 for PROC MEANS
  C. 401 for PROC PRINT 4500 for PROC MEANS
  D. 500 for PROC PRINT 5000 for PROC MEANS
  B. 401 for PROC PRINT 4501 for PROC MEANS

• Question 70:

  The SAS data set named COMPANY.PRICES is listed below:

  The following SAS program is submitted:

  libname company `SAS-data-library';

  data hware inter soft;

  set company.prices (keep = producttype price);

  if price le 5.00;

  if producttype = `HARDWARE' then output HWARE;

  else if producttype = `NETWORK' then output INTER; else if producttype = `SOFTWARE' then output SOFT; run;

  How many observations does the HWARE data set contain?

  

  B. 2
  C. 4
  D. 6
  B. 2