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.
The following SAS program is submitted:
proc sort data = work.employee;
by descending fname;
proc sort data = work.salary;
by descending fname;
data work.empdata;
merge work.employee
work.salary;
by fname;
run;
Why does the program rail to execute?
The following SAS program is submittad:
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?
Given the following raw data record:
----I----10---I----20---I----30
son Travis,
The following output is desired:
Obs relation firstname -
1 son Travis
Which SAS program correctly reads in the raw data?
Given the SAS data set AGES:
AGES -
AGE -
---------
The variable AGE contains character values. The following SAS program is submitted: data subset; set ages; where age> 12; run;
How many observations are written out to the data set SUBSET?
Given the SAS data set PRICES:
PRICES -
prodid price
K12S 5.10 producttype -
NETWORK sales -
15 returns
B132S 2.34 HARDWARE 300 10
R18KY21.29 SOFTWARE 25 5
3KL8BY 6.37 HARDWARE 125 15
DY65DW 5.60 HARDWARE 45 5
DGTY23 4.55 HARDWARE 67 2
The following SAS program is submitted:
data hware inter soft;
set 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?