This certification validates practical skills in software development, including solution design, implementation, testing, and maintenance. It is intended for developers and technical professionals delivering dependable software in real-world environments.
Given the raw data record DEPT:
----|----10---|----20---|----30
Printing 750 -
The following SAS program is submitted:
data bonus;
infile dept;
inputdept$ 1-11 number 13- 15;
<insert statement here>
run;
Which SAS statement completes the program and results in a value of Printing750 for the DEPARTMENT variable?
The following SAS program is submitted:
data one;
addressl = 214 London Way;
run;
data one;
set one;
address = tranwrd(address1, Way, Drive); run;
What are the length and value of the variable ADDRESS?
The following SAS program is submitted:
data work.sets;
do until (prod gt 6);
prod + 1;
end;
run;
What is the value of the variable PROD in the output data set?
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:
WORK.EMPLOYEE WORK.SALARY -
fname age name salary
Bruce 30 Bruce 25000 -
Dan 40 Bruce 35000 -
Dan 25000 -
The following SAS program is submitted:
data work.empdata;
by fname;
totsal + salary;
run;
Which one of the following statements completes the merge of the two data sets by the FNAME variable?
Which program displays a listing of all data sets in the SASUSER library?