A00-231 exam

Given the SAS data set PEPM.STUDENTS: PERM.STUDENTS NAME AGE Alfred 14 Alice13 Barbara13 Carol14 The following SAS program is submitted: libname perm ‘SAS data library’; data students; set perm. Students; file ‘file specification’; put name $15. @5 age 2.; run; What is written to the output raw data file?A ....

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?A . data family ( dIm = ‘,’); infile ‘tile specification’; input relation $ firstname $; run;B . options dIm = ‘,’;...

The following SAS program is submitted: data combine; prefix=’505’; middle=’6465 ‘; end=’09090’; <insert statement here>; run; Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090?A . total = cat(’-’, prefix, middle, end);B . total = catx(’-’, prefix, middle, end);C . total = prefix !!’-’!! middle...

Given the SAS data set PEPM.STUDENTS: PERM.STUDENTS NAME AGE Alfred 14 Alice13 Barbara13 Carol14 The following SAS program is submitted: libname perm ‘SAS data library’; data students; set perm. Students; file ‘file specification’; put name $15. @5 age 2.; run; What is written to the output raw data file?A ....

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?A . 6B . 7C . 8D . (missing numeric)View AnswerAnswer: B

The following SAS program is submitted: data work.empsalary; set work.people (in = inemp) work.money (in = insal); if insal and inemp; run; The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations. How many observations will the data set WORK.EMPSALARY contain?A . 0B ....

The following SAS program is submitted: data work.total; set work.salary(keep = department wagerate); by department; if first.department then payroll = 0; payroll + wagerate; if last.department run; The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments. What is the result?A . The...

The following SAS program is submitted: data WORK.ACCOUNTING; set WORK.DEPARTMENT; label Jobcode='Job Description'; run; Which statement is true about the output dataset?A . The label of the variable Jobcode is Job (only the first word).B . The label of the variable Jobcode is Job Desc (only the first 8 characters).C...

The following SAS program is submitted: data test; set sasuser.employees; if 2 le years_service le 10 then amount = 1000; else amount = 0; amount_per_year = years_service / amount run; What is the value of the variable AMOUNT_PER_YEAR if an employee has been with the company for one year?A ....

Which is a valid LIBNAME statement?A . libname "_SAS_data_library_location_";B . sasdata libname "_SAS_data_library_location_";C . libname sasdata "_SAS_data_library_location_";D . libname sasdata sas "_SAS_data_library_location_";View AnswerAnswer: C