SAS Advanced Programming Certification Practice Exam

These questions are part of the practice quiz. Start practicing

• What does the ROUND function do in the context of PROC FCMP?
• What is an array in SAS?
• In which PROC would you push processing into an Oracle database?
• What happens when you use this highlighted statement in your program: if _N_=1 then do; if 0 then set pg3.stocks(keep=Stock Date Open Close); end;
• What is the function of the SAS log?
• What is the primary role of the PRX functions in SAS?
• Which IF statement would correctly subset ProductName for values containing the standalone word shirt?
• What type of SQL does PROC FEDSQL use?
• Which data step generates the output table work.rotate?
• What is the use of the WHERE statement in PROC SQL?
• True or False: Perl regular expressions must start and end with a delimiter.
• What is a validation check used for in SAS data manipulation?
• What is the function of the PROC SORT procedure in SAS?
• What distinguishes the CLASS statement from the VAR statement in PROC ANOVA?
• What does the KEEP statement do in a DATA step?
• Which Perl regular expression correctly replaces 'PG3' with 'PG3M6'?
• In what circumstance would you use the NODUPKEY option?
• What effect do the DROP= and KEEP= data set options have?
• What is a SAS array?
• What is the purpose of the BY statement in SAS procedures?
• Which statement about PROC FEDSQL is true?
• Why is StateName specified in the DEFINEKEY and DEFINEDATA methods?
• How does the COUNTW function operate in SAS?
• Which statement is false concerning the following array statement: array TwoD[2,3] $ _temporary_?
• What is the value of TwoD5 after the first iteration of the data step?
• When writing SQL queries for PROC FEDSQL, which clause syntax restricts data returned by a query?
• What is the primary purpose of a temporary array in SAS?
• Which statement is false regarding an ARRAY statement?
• Which data step multiplies the values of Quiz1 through Quiz5 by 10?
• What is the correct syntax to select specific columns from a SAS table?
• What is a common type of condition verified in validation checks?
• In a hash object definition, what is the role of specifying an ordered status?
• What does the FORMAT statement do in SAS?
• When executing a query that specifies column order, which order will the columns appear in the output?
• What does an association refer to in SAS/ETS?
• What is the purpose of using conditional functions in SAS?
• True or False: The LAG function can retrieve the previous value of a numeric or character column.
• What error might you encounter if you use double quotation marks in the WHERE clause of PROC FEDSQL?
• What information does PROC CONTENTS provide about a dataset?
• Which PICTURE statement correctly generates a date format for visualizing a date value?
• What type of data combination occurs in a left join?
• Complete the if statement below to output the rows only when the value of the Name column is found in the Tests hash object: if ___________ then output;
• How many rows does the following query produce in the report: select * from sq.employee_donations, sq.employees?
• Which clause is often used to group rows that share a common field value?
• What visualization types can PROC UNIVARIATE generate?
• Which statement is used to read a CSV file in SAS?
• True or False: The following ARRAY statements contain valid syntax for creating the numeric columns Target1, Target2, Target3, and Target4.
• What does the FIRST. variable indicate in a SAS DATA step?
• What does the use of PROC FEDSQL imply about data processing?
• In the context of aliases, which clause allows using a calculated value?
• Which array statement correctly loads the following values into the array survey: 4, 5, 3, 2, 4 and 5, 5, 2, 4, 3?
• What is the purpose of using single quotation marks in PROC FEDSQL?
• Is it permissible to include SAS-specific features in PROC SQL?
• Which query executes correctly in PROC FEDSQL?
• For what purpose is PROC SQL used in SAS?
• Which statement identifies the syntax error in the following query: select Lastname, Firstname from charity.donors where Donation > 1000 and Lastname not in select Lastname from charity.current?
• Which of the following is NOT a characteristic of the PICTURE statement?
• Which of the following best describes the role of the DATA step?
• What is the purpose of the RANK procedure in SAS?
• Which global option specifies the table SAS searches for a package that contains the custom function?
• How can error handling be implemented in a SAS program?
• Which syntax correctly defines a hash object with one key component and two data components?
• What is a "hash object" in SAS?
• What does the SUM statement do in a DATA step?
• What is the significance of using the BY statement in a DATA step?
• What ensures the rows in your output are in a specific order?
• What does the COUNT function do in SAS?
• What does sorting data assist with in later analytical tasks?
• True or False: The RETURN statement can have the custom function return multiple values.
• True or False: Key components must be defined as PDV columns, but data components do not need to be defined as PDV columns.
• What does the PRXPARSE function return?
• Which declare statement has correct syntax?
• What is an index in SAS primarily used for?
• How can a new column be created in the SELECT clause?
• Which method is used to concatenate datasets in SAS?
• Which syntax is appropriate for a self-join on the employees table?
• How can the correlation between two variables be calculated in SAS?
• What is the purpose of the LABEL statement in SAS?
• What clause allows the use of an alias in the WHERE statement for an expression?
• Which of the following is not a valid way to specify the output column label in PROC SQL?
• What must be true for a hash object to iterate over its elements correctly?
• How do you ensure a dataset's variable format is applied effectively?
• Yes or No: Based on the following declare statement, will the output method create a sorted table? declare hash StateSort (ordered); StateSort.output(dataset: 'work.USstates');
• Which statement is true regarding the purpose of PROC FORMAT?
• What is one primary use of the SET statement in a DATA step?
• Which program correctly displays a list of qualified column names in the SAS log?
• Which SAS procedure is specifically designed for generating reports from datasets?
• Complete the FUNCTION statement to create a function named TitleName that takes two character arguments:
• How does a DATA step differ from a PROC step?
• What would you expect as an outcome of using PROC FEDSQL for a query?
• In which scenario would you use the CLASS statement?
• Which statement allows for maintaining total counts across observations in SAS?
• Which of the following statements is true regarding the hash iterator (hiter) object?
• What does the PROC PRINT procedure do in SAS?
• Which method retrieves entries from a hash object based on a key value?
• In PROC SQL, what does a left join accomplish?
• How does the SAS system handle character data types?
• Which option correctly uses an ANSI standard column modifier for a column label?
• What type of variables must be included in the DATA step columns when using hash objects?
• When might you use the OUTPUT statement in a DATA step?
• What is a common use case for PROC FEDSQL in data management?
• What statement is used to create a histogram in SAS?
• Which query finds the ID, Job_Title, and Salary values of all employees in the Engineering Department?
• How does PROC SQL determine which records to keep in a left join?
• Which procedure is used to define formats in SAS?
• What is the effect of using a zero digit selector before the decimal point in a PICTURE statement?
• Is 'calculated' a reserved keyword in PROC SQL for alias usage?
• Which data step correctly calculates the difference in Tavg between consecutive rows?
• Which SQL function would you use to find the total number of rows in a query result?
• Complete the array statement to create temporary array elements that have initial values of 100, 129, 104, and 119.
• Which code correctly produces a report of only the matches from the employee_donations and employees tables, including each column once?
• In SAS, what does the DIM function do when used in conjunction with an array?
• What does the OPTION statement do in a SAS session?
• How can you run a SAS program in batch mode?
• What is the purpose of the PROC TRANSPOSE procedure in SAS?
• What is one of the key benefits of using validation checks?
• How can cumulative totals be calculated in SAS?
• Which query finds the ID, Job_Title, and Salary values of all employees who make more than the average of all employees?
• Which statement is used to retain variables in an output dataset during data step processing?
• How can you validate data during the DATA step execution?
• In SQL, which command is used to delete existing records from a table?
• What kind of argument does PRXMATCH use?
• Which of the following is NOT a feature of PROC FEDSQL?
• Which SQL feature allows for grouping records based on a specified column?
• How would you set up a permanent SAS library?
• Which statement is false regarding the PICTURE statement?
• Which of the following is true about the execution environment for PROC FEDSQL?
• How can one create a new variable in a DATA step?
• What type of data will the LENGTH statement affect?
• What is the function of the MERGE statement in SAS?
• How can interactive reports be created in SAS?
• What does the prefix option do in a PICTURE statement?
• What is an example of a continuous variable?
• Which PICTURE statement generates the correct format for displaying the values 76.54, 0.32, and 1.82?
• Which of the following are format options that can be placed after the format name?
• Which of the following actions can be performed with PROC SQL?
• What is the primary purpose of the DATA step in SAS?
• Which PICTURE statement displays a nine-digit account number with five leading asterisks?
• Which statement is true regarding a noncorrelated subquery?
• Which statement is true regarding the transfer of SQL knowledge to PROC SQL?
• What purpose does a SAS macro serve?
• What happens if the LAG function is not executed due to a false condition?
• What does the SET statement do in a DATA step?
• Which statement accurately describes where the custom function will be stored in PROC FCMP?
• What kind of statistics does PROC UNIVARIATE summarize?
• Which query correctly retrieves unique combinations of two columns from a table?
• Which SAS function would help in identifying issues during macro execution?
• What is the value of Position when using the PRXMATCH function with the pattern '/Dutch/' on the string 'Sawyer Dutch Kenai'?
• What is the significance of sorting data before analysis?
• True or False: an in-line view can return multiple rows and columns.
• Which of these actions is enhanced by the use of PROC FEDSQL?
• What is the purpose of the SAS Output Delivery System (ODS)?
• What keyword must be included in a SELECT statement to prevent duplicate rows from appearing in the results?
• Which statement correctly describes the ROLE of the FORMAT statement?
• What is the primary purpose of SAS DATA step debugging options?
• How do numeric and character variables differ in SAS?
• How can PROC FREQ be used in SAS?
• What is the correct order of clauses in a SELECT statement when all are present?
• What is the purpose of the CALL MISSING routine when working with hash objects?
• How can you use the OUTPUT statement in SAS?
• Which statement about Perl regular expressions is true?
• What is the function of the LABEL statement in SAS?
• What is the correct statement to end the syntax for the ToCelsius function in PROC FCMP?
• What does a value of -1 for the times argument specify in the PRXCHANGE function?
• When defining a multi-dimensional array in SAS, how are elements accessed?
• What type of analysis does PROC UNIVARIATE provide in SAS?
• What is the effect of using WHERE statement in a DATA step?
• Which statement is used to specify the variable of interest in PROC MEANS?
• What defines categorical variables in SAS?
• What is the best solution if you need to use the most up-to-date data from a complex query and want multiple users to access the information?
• What type of data processing does PROC FEDSQL primarily aim to perform?
• What options can be used in PROC MEANS to calculate statistics?
• Which statement is false regarding a hash object?
• Which procedure is best for creating a summary report of statistics in SAS?
• How can you explicitly manage missing values in SAS?
• What should you avoid when constructing queries in PROC FEDSQL?
• What enhances the readability of output when using SAS?
• How is a standalone word identified within a larger string using the FINDW function?
• What must be done before referencing an array in SAS?
• What statement is used to read data from an external file in SAS?
• Which option can be used to remove duplicate observations from a dataset?
• What does the INNER JOIN clause do in an SQL query?
• Which statement creates the TEST array that references the columns Test1, Test2, Test3, Test4, Test5, and Final?
• What is indicated by the DEFAULT= option in a PICTURE statement format?
• What is the purpose of the OUT= option in PROC SORT?