Free SAS Certification Exam Practice Test

Attempt SAS practice test questions and test your skills. This free Data Science with SAS exam prep material simulates the actual certification exam.

  • 50 Questions,
  • 90 Minutes
Related course

Data Science with SAS Training

Become an expert in the various analytics techniques using SAS. Master the PROC SQL, PROC procedure, and SAS Macros. Understand advance ...

Get 15% DiscountCoupon will be auto applied. GO TO COURSE
Instructions:

1. This is a FREE test and can be attempted multiple times. But it is recommended to take the test when you are ready for best practice experience.

2. Test Duration: 90 Minutes

3. Number of questions: 50 Multiple Choice Questions

4. Each question has multiple options out of which one or more may be correct

5. You can pause the test in between and you are allowed to re-take the test later. Your test will resume from where you left, but the test time will be reduced by the amount of time you've taken in the previous attempt.

Please fill the form below to start the Practice Test
Name*
Email*
+91-
Phone Number*
{{seconds | secondsToDate | date:'HH:mm:ss'}} Time remaining
1. Which of the following analysis explains "what has happened"?
2. Which of the following analysis includes Delinquent behavior analysis of customer?
3. _____ is the practice of using data and technology to study how your business is performing to continuously make it better.
4. Which of the following keywords is used in SAS to store values in variables?
5. Which of the following signs in SAS program holds only the missing numeric values?
6. The starting variables in the program data vector are set to be missing value.
7. Which of the following keywords is used to define the variables in SAS Dataset?
8. In which of the following combining dataset techniques does SAS append the observation from one dataset to another?
9. Which of the following options forces PROC APPEND to concatenate the files in some situations where program executes syntax error.
10. Which of the following programs concatenates the data sets HR and Marketing?
11. Which of the following methods continues to read observations until the last observation is read from the largest dataset to merge datasets?
12. Which of the following statements can be used to exclude variables from the output dataset?
13. Which of the following statements can be used in Proc SQL to select Variables.
14. Which of the following keywords can be used to assign the name to new variable in Proc SQL?
15. _____ statement provides the ability to create a new data set as output in lieu of a report.
16. Which of the following clauses can be used to compare the values in Proc SQL.
17. Global variables cannot be accessed by any SAS program available in SAS environment.
18. Which of the following keywords can be used to close the macro syntax?
19. Which of the following keywords is used to end Proc SQL?
20. Order By Statement is used to______
21. We can join three or more tables in Proc SQL.
22. If the size of dataset is not similar, which of the following options should be used in Proc Append to add datasets?
23. The following SAS program is submitted: data WORK.ACCOUNTING; set WORK.DEPARTMENT; label Jobcode='Job Description'; run; Which of the following statements is true about the output dataset?
24. The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of 'Asking Price'. Which of the following SAS programs temporarily replaces the label 'Asking Price' with the label 'Sale Price' in the output? ''
25. 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?
26. What will happen if you submit the following program: Porc Print Data=Electronic; Run;
27. Given the SAS data set PERM.STUDENTS: PERM.STUDENTS NAMEAGE ---------------- Alfred14 Alice13 Barbara13 Carol14 The following SAS program is submitted: libname perm 'SAS data library'; data students; set perm.students; file 'file specification'; put name $ age; <insert statement here> run; The following double-spaced file is desired as output Alfred 14 Alice 13 Barbara 13 Carol 14 Which statement completes the program and creates the desired file?
28. 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 of the following SAS statements completes the program and results in a value of 'Printing750' for the DEPARTMENT variable?
29. 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 of the following statements completes the merge of the two data sets by the FNAME variable?
30. 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?
31. 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?
32. Which of the following statements specifies that records 1 through 10 are to be read from the raw data file customer.txt? infile 'customer.txt' 1-10; input 'customer.txt' stop@10; infile 'customer.txt' obs=10; input 'customer.txt' stop=10; Given the AIRPLANES data set AlRPLANES TYPE MPG -------- ------ F-18 105 C-130 25 Harrier 75 A-6 110 The following SAS program is submitted: data gt100; set airplanes(keep = type mpg load); load = mpg * 150; run; The program fails to execute due to syntax errors. What is the cause of the syntax error?
33. Which of the following statements is true regarding the SAS automatic variable _ERROR_?
34. Which of the following signs tells SAS to hold the current input record for the execution of the next INPUT statement, rather than advancing to a new record?
35. Which of the following statements is used in SAS to retain variables from the Dataset?
36. The following SAS program is submitted; data combine; country = 'Italy, Russia, ireland'; found = find(country, 'i'); run; What is the value of the variable FOUND in the output data set?
37. Which of the following is correct syntax to Print first 10 Observations form Dataset.
38. 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?
39. The following SAS program is submitted: data work.new; length word $7; amount = 4; if amount = 4 then word = 'FOUR'; else if amount = 7 then word = 'SEVEN'; else word = 'NONE!!!'; amount = 7; run; What are the values of the AMOUNT and WORD variables in SAS dataset work.new?
40. Which of the following keywords is used to define Base dataset in Proc Append?
41. The following SAS program is submitted: data WORK.ONE; Text=’Australia, US, Denmark’; Pos=find(Text,’US’,’i’,5); run; What value will SAS assign to Pos?
42. Identify the default statistics that Proc Means Produce?
43. The following SAS program is submitted: footnote1 'Sales Report for Last Month'; footnote2 'Selected Products Only'; footnote3 'All Regions'; footnote4 'All Figures in Thousands of Dollars'; proc print data = sasuser.shoes; footnote2 'All Products'; run; Which footnote(s) is/are displayed in the report?
44. Which of the following is correct to sort data in descending order.
45. Which of the following is also called as Attrition analysis?
46. Which of the following clauses is used to Apply filter based on condition in Proc SQL?
47. Which of the following statements is used define dependent and Independent variable in Proc Reg?
48. _____keyword is used to define constraint in SAS.
49. Which of the following keywords is used to solve linear equations in SAS?
50. Which of the following procedures is used for Model Optimization
{{ seconds | secondsToDate | date:'HH:mm:ss'}} Time remaining
NOTE

All test progress will be lost in case you close the browser without finishing the test. Please finish the test to access your results.

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.

Request more information

For individuals
For business
Name*
Email*
Phone Number*
Your Message (Optional)
We are looking into your query.
Our consultants will get in touch with you soon.

A Simplilearn representative will get back to you in one business day.

First Name*
Last Name*
Email*
Phone Number*
Company*
Job Title*