SAS Training

SAS Certified Adv Programmer 130 Questions (3)

Which one of the following options controls the pagesize of a SAS data set?

A. SIZE=
B. BUFNO=
C. BUFSIZE=
D. PAGESIZE=

SAS Certified Adv Programmer 130 Questions (2)

The following SAS program is submitted:

<insert statement here>
%let development = ontime; 

proc print data = sasuser.highway; 
    title "For &dept"; 
    title2 "This project was completed &development"; 
run; 

Which one of the following statements completes the above and resolves titlel to “For research&development”?

A. %let dept = %str(research&development);
B. %let dept = %str(research%&development);
C. %let dept = %nrstr(research&development);
D. %let dept = %nrstr(research%&development);

SAS Certified Adv Programmer 130 Questions (1)

Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?

A. RENAME statement only
B. CHANGE statement only
C. MODIFY and RENAME statements
D. MODIFY and CHANGE statements

SAS Certified Base Programmer 123 Questions (123)

The following SAS program is submitted:

data test;
    set sasuser.employees;
    if 2 le years_service le 10 then
        amount=1000;
    else if years_service gt 10 then
        amount=2000;
    else
        amount=0;
    amount_per_year=years_serice/amount;
run;

Which one of the following values does the variable AMOUNT_PER_YEAR contain if an employee has been with the company for one year?

A. 0
B. 1000
C. 2000
D. . (missing numeric value)

SAS Certified Base Programmer 123 Questions (122)

The contents of the raw data file AMOUNT are listed below:

----|----10---|----20---|----30
$1,234

The following SAS program is submitted:

data test;
    infile'amount';
    input @1 salary 6.;
    if _error_ then description='Problems';
    else desription='No Problems';
run;

Which one of the following is the value of the DESCRIPTION variable?

A. Problems
B. No Problems
C. ‘ ‘ (missing character value)
D. The value can not be determined as the program fails to execute due to errors.