Free SASInstitute A00-201 Exam Dumps Questions & Answers

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.  401 for PROC PRINT
  4 501 for PROC MEANS
• B.  400 for PROC PRINT
  4 500 for PROC MEANS
• C.  401 for PROC PRINT
  4 500 for PROC MEANS
• D.  500 for PROC PRINT
  5000 for PROC MEANS

Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?

• A.  missing character variables, non-missing character variables, missing numeric variable values, and non-missing numeric variable values
• B.  non-missing character variables and non-missing numeric variable values only
• C.  missing numeric variable values and non-missing numeric variable values only
• D.  non-missing numeric variable values only

The following SAS DATA step is submitted:
data sasdata.atlanta
sasdata.boston
work.portland
work.phoenix;
set company.prdsales;
if region = 'NE' then output boston;
if region = 'SE' then output atlanta;
if region = 'SW' then output phoenix;
if region = 'NW' then output portland;
run;
Which one of the following is true regarding the output data sets?

• A.  The data sets listed in the first two IF statements require a library reference.
• B.  The data sets listed on all the IF statements require a library reference.
• C.  No library references are required.
• D.  The data sets listed in the last two IF statements require a library reference.

Which one of the following is true when SAS encounters a data error in a DATA step?

• A.  A note is written to the SAS log explaining the error, and the DATA step continues to execute.
• B.  The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point.
• C.  The DATA step stops executing at the point of the error, and no SAS data set is created.
• D.  A note appears in the SAS log that the incorrect data record was saved to a separate
  SAS file for further examination.

The contents of two SAS data sets named EMPLOYEE and SALARY are listed below:

The following SAS program is submitted:
data work.empsalary;
merge work.employee (in = inemp)
work.salary (in = insal);
by name;
if inemp and insal;
run;
How many observations will the data set WORK.EMPSALARY contain?

• A.  6
• B.  4
• C.  5
• D.  2