Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

Given the input data sets EMPLOYEES and DONATIONS, and the output data set NODONATIONS below:

A.

data nodonations;

merge employees (in-inE) donations (in=inD);

by employee_id;

if inE=0 and inD-0;

run;

B.

data nodonations;

merge employees (in-inE) donations (in=inD);

by employee_id;

run;

C.

data nodonations;

merge employees (in-inE) donations (in=inD);

by employee_id;

if inE=1 and inD-0;

run;

D.

data nodonations;

merge employees (in-inE) donations (in=inD);

by employee_id;

if inE=1 and inD-1;

run;

Which option renames the variable Name to StudentName when reading the ClassRoster data set?

A.

set ClassRoster (rename (StudentName=Name ) ) ;

B set ClassRoster (rename (NamestudentName) ) ;

B.

set ClassRoster (renaiae=(Name=studentName) ) ;

C.

set ClassRoster (^name=(StudentName=Name));

Which sentence is true regarding the VALUE statement in the FORMAT procedure?

A.

The keyword UNKNOWN can be specified on the VALUE statement.

B.

Numeric format names in the VALUE statement must begin with a $ sign.

C.

The VALUE statement can create numeric and character formats.

D.

The VALUE statement uses the LIB= option to specify the location of the format.

Which line contains a syntax error?

A.

Line 3

B.

Line 1

C.

Line 2

D.

Line 5

Which program assigns the library reference exlib to the CLASS. XLSX workbook and displays the CLASS_TEST worksheet?

A.

libname xlsx exlib "c:\class.xlsx";

proc print data=xlsx.class_test;

run;

B.

libname exlib xlsx "c:\class.xlsx";

proc print data=class_test.xlsx;

run;

C.

libname exlib xlsx "c:\class";

proc print data=exlib.class_test.xlsx;

run;

D.

libname exlib xlsx "c: \class.xlsx";

proc print data=exlib.class_test;

run;

Which statement is true regarding a variable?

A.

A character variable can contain alphabetic characters, numeric digits, and other special characters.

B.

A numeric value must be specified in single or double quotes.

C.

A character value cannot exceed 200 bytes.

D.

A numeric variable can contain digits, decimal point, minus sign, currency symbol, and E for scientific notation.

Given the PATIENT and VISIT data sets and the DATA step shown below:

PATIENT

VISIT

How many observations are created in the ALLVISITS data set?

A.

5

B.

12

C.

7

D.

0

Which step temporarily assign a format to the sales variable?

A.

Proc format;

Formatsales comma12.;

Run;

B.

Data sasuer. Shoes

Set sashelp,sheoes;

Format sales comma12.;

C.

Proc contents data=sashelp.shoes;

Format Sales comma12.;

Run;

D.

Proc print data= sashelp. Shoes

Format sales comma12.;

Run;

You submit a program and the SAS log is shown below:

Which statement is true regarding the submitted program?

A.

The error in the PROC SORT step caused the program to stop processing

B.

All three steps ran successfully

C.

The DATA step and PROC PRINT steps ran without errors.

D.

The PROC SORT and PROC PRINT steps failed.

What happens when you submit the code shown below?

data table1 table2;

set sashelp.shoes;

output;

run;

A.

The program does not run because there is no data set specified on the OUTPUT statement.

B.

Each observation in sashelp. shoes is written to both table1 and table2.

C.

Each observation is written twice to table1 and table2.

D.

Each observation in sashelp. shoes is written to table1 only.