SAS Base Programming Certification Practice Exam

These questions are part of the practice quiz. Start practicing

• What is the default output format generated by the ODS HTML statement?
• What is the significance of the NODS option in the PROC CONTENTS statement?
• Which statement about the INPUT and INFILE methods is incorrect?
• In the context of SAS programming, what does performing data analysis via PROC FREQ primarily accomplish?
• What does the COMPRESS function return?
• Which size will the variable All be in the output dataset based on the provided SAS program?
• What types of variables can you define in SAS?
• In a DATA step, what does the INPUT statement do?
• What does the colon modifier ':' do when reading data in SAS?
• What function does the INPUT statement serve in a SAS DATA step?
• How can you prevent a dataset from automatically being created during a DATA step?
• In SAS9, which statement about user-defined format names is not true?
• What is the primary function of the PROPCASE function?
• After submitting a DATA step to create a data set named women from clinical, how many observations will result?
• In the context of SAS date functions, what does the acronym QTR stand for?
• What is the purpose of the FLOWOVER option in an INPUT statement?
• What does the statement "OUTPUT;" indicate within a DATA step?
• Which option would you use to obtain variable attributes within a dataset in SAS?
• What type of log message will prevent your SAS program from running?
• What does the RUN statement signify in SAS procedures like GCHART and GPLOT?
• What is the main purpose of the DATDIF function?
• What is true about librefs in SAS?
• What option allows SAS to handle missing values in input data without creating a new record?
• In column input, how are data values organized?
• What is the purpose of the DATEPART function in SAS?
• In PROC PRINT, what is the purpose of the NOOBS option?
• What does the FORMAT= option do in a DEFINE statement?
• What is the result of the DATA step when it specifies _NULL_ as the output dataset?
• How many observations are created in the resulting SAS data set with the given DATA step?
• What is the primary purpose of the GCHART procedure?
• What is the main purpose of a FORMAT in SAS?
• What is the value and length of the variable Word in the output data set after executing the provided SAS program?
• In a SAS DATA step, which statement is used to incrementally calculate totals?
• What must you maintain when using pointer control for variable input?
• Which of the following indicates a correctly formatted PROC IMPORT statement?
• What is the purpose of the MDY function in SAS?
• When using ODS, what is the output format for data structured in a table format that can be directly edited in Excel?
• Which variable is used to indicate the dataset being processed in the PROC SORT?
• When merging two data sets with the MERGE statement, how is it possible to filter observations based on a variable condition?
• Which of the following is NOT a valid shape option in the SYMBOL statement?
• What does the PLOT statement within PROC GPLOT specify?
• What is the purpose of the 'RUN;' statement in SAS procedures?
• Which function should replace f_name to change text from Court to Drive in the SAS code provided?
• When should the INFILE method be preferred over DATALINES?
• When using a line pointer control to read in raw data, which statement is FALSE?
• In SAS, which option permits reading remaining values from a single line across multiple iterations?
• What is the general form of the IF-THEN statement?
• What is one of the primary functions of the SORT procedure in SAS?
• What function can prevent converting character values to numeric values that generates a warning in the log?
• What statement is used to sort the variable Salary in ascending order in the highlighted SAS program?
• What happens when the following SAS program runs? ODS HTML FILE='results'; PROC PRINT DATA=work.ds1; RUN; ODS HTML CLOSE;
• What does SAS automatically do to the values of variables at the start of each DATA step?
• Is _Yr2006_Patient_Data a valid libref in SAS?
• What is the function of the MISSOVER option in the INFILE statement?
• How can you denote a numeric variable in SAS?
• Which window is primarily used for managing data sets and libraries within SAS?
• Which function is used to concatenate values with a delimiter in SAS?
• In a GCHART, what does the chart variable determine?
• Which line of code is required to initialize the variable Total to 0 in the provided SAS program?
• In the DATA step below, how many observations will be in the resulting data set?
• What variables are written to the dataset Work.Ds3?
• What does the DATASETS procedure allow you to do in SAS?
• When is a SAS variable considered to be temporary?
• Which feature is NOT typically associated with the Editor window?
• What does the SUBSTR function accomplish?
• When creating a SAS dataset, what is the purpose of the LENGTH statement?
• What's the effect of using a semi-colon at the end of a DATA step?
• In PROC MEANS, what happens when the data set contains missing values?
• What does the general form of the INPUT statement include?
• When utilizing a BY statement, how does SAS handle sorting?
• Which date function returns a number from 1 to 7 representing the day of the week?
• Which SAS syntax would correctly rename variable X and Y in the data set Work.Dept?
• What file extension is associated with SAS data sets?
• What will be the value of x for the last observation in the data set S?
• What function does index() serve in a SAS program?
• Which of the following is considered standard numeric data?
• Which of the following is NOT a property of the SORT procedure?
• What does the INT function do?
• What does the descriptor portion of the output data set contain?
• How many observations will be visible in the output if FIRSTOBS is set to 25 and OBS is set to MAX for a dataset with 40 observations?
• Which of the following indicates a valid permanent SAS data set?
• What kind of variable is Age in the provided DATA step?
• In SAS, what is typically the purpose of the DROP statement?
• What is the purpose of the 'OUTPUT' statement in a DATA step?
• Which option suppresses page numbers in the output of SAS listings?
• What is the purpose of the RENAME statement in a SAS data set?
• What type of regression line is indicated by a cubic equation?
• Given the data step provided, what values are stored in the output data set?
• If age is calculated using the formula Age=(GradDate - DOB) / 365.25, which function is best for reporting age in whole years?
• Which statement correctly describes the DROP option in a DATA step?
• How do you handle multiple statements in an IF-THEN condition?
• What type of variable is Date in the output dataset after executing the provided SAS program?
• What is the output of the UPCASE function?
• Which of these statements is accurate regarding sorting variables?
• What is the typical structure of a DATA step using the DATALINES statement?
• Which of the following is true about the PAGEBY statement?
• When applying the ROUND function, which parameter is required?
• Which of the following is not a part of a SAS data set?
• Which statement is true regarding filename statements in SAS?
• What happens if you use automatic variable conversion in SAS?
• What is the value of x for the fourth observation of the SAS data set test?
• What is the result when the following SAS program is run: PROC PRINT DATA=employees; WHERE name ? E; RUN?
• How does the SORT procedure handle missing values?
• Which of the following best describes formatted input?
• What type of charts can effectively display the distribution of a variable's values?
• In SAS, what is the primary use of the TRIM function?
• What is the function of the line-hold specifier '@' in SAS?
• Which method allows you to directly see your data while using SAS?
• What method does SAS use to direct output when reaching the RUN statement in a DATA step?
• Which statistical method is performed by PROC UNIVARIATE for comparing sample and population mean?
• What is the function of the Double Trailing @@ Modifier?
• What does the BY statement do in a SORT procedure?
• What happens to the observations in the mydata.pay data set after the sorting operation?
• What does the COMPRESS option do in PROC FREQ?
• What is the function of the ID statement in PROC PRINT?
• What is meant by 'fixed' or 'aligned' input format in column input?
• How would you keep a variable during a DATA step operation that you want to initialize or retain across iterations?
• What is the format for the variable Name in the data set Both after merging Employee and Sales?
• Which function would you use to retrieve the current time in SAS?
• Which statistic is NOT included by default in PROC MEANS?
• What does the NMISS function in SAS indicate?
• What occurs when the following SAS program is submitted? DATA work.test; type='SQL'; IF type='SAS' THEN description='SAS Program'; ELSE description='other'; LENGTH description 8; RUN;
• How does the LENGTH function handle empty strings?
• When reading data, what does the option MISSOVER do?
• Which ODS statement is used to create a comma-separated values (CSV) file from a SAS data set?
• What is the default behavior when using the FLOWOVER option in an INPUT statement?
• Which attribute controls the format of a variable during a PROC step?
• What is unique about the SUM statement's initialization behavior?
• Which output type is specifically designed for printers through ODS?
• What is produced as output when the following SAS program is run? ODS CSVALL FILE='c:\test.csv'; PROC PRINT DATA=work.ds1; RUN; ODS CSVALL CLOSE;
• How are the weekday values represented in the WEEKDAY function in SAS?
• What is the primary function of the SYMBOL statement in SAS programming?
• Which of the following DATA steps will correctly read the numeric variables score1, score2, and score3 using a 6. informat?
• When combining Work.Ds_One and Work.Ds_Two with PROC APPEND, what is true regarding the process?
• Which command is essential for creating a new SAS data set in the Sort procedure?
• What statement can be used to complete the SAS program for the desired report?
• What does the VAR statement do in PROC PRINT?
• What modification is needed to correct the SQL error in the given SAS program?
• Which of the following statements correctly utilizes the VAR statement in SAS?
• What is the purpose of the DROP and KEEP statements in a DATA step?
• Which of the following statements about the MISSOVER option is FALSE?
• Which statistic displayed by PROC MEANS is NOT typically part of the summary?
• What is required to define a new library reference (libref) in SAS?
• What functionality does the TRANWRD function provide?
• What does the NOPRINT option achieve in PROC FREQ?
• In a DATA step, what does the variable _N_ represent?
• Which statement about the INPUT statement is true?
• What is the purpose of the SUBSTR function in SAS?
• What will be the output of running a DATA _NULL_ step with a FILE statement?
• Which of the following is NOT a function of the SORT procedure in SAS?
• What does the KEEP statement do in a SAS program?
• Which statement describes the use of 'IF-THEN' in a DATA step?
• What is the purpose of the TYPE option in the GCHART procedure?
• Which of the following is NOT a type of input method in SAS?
• In the merged dataset, what is the expected output for ID 182?
• What does the OUTPUT statement do in a DATA step?
• What is the result if STOPOVER is specified and the record ends without finding all variable values?
• What is the purpose of the MAXDEC= option in SAS procedures?
• Which function capitalizes the first letter in each word of a string?
• What does the TODAY function return in SAS?
• What type of variables can an ARRAY contain?
• What does the PAD option do in SAS?
• In the SAS program provided, what will be the final values of variables X and Index?
• The general form of an assignment statement in SAS includes which of the following?
• What is the expected output value of the variable All in the provided SAS program?
• Which statement is used to modify SAS data sets in PROC DATASETS?
• What type of data does PROC MEANS focus on summarizing?
• What does the concatenation operator (||) do?
• How can you use the UPCASE function effectively in data analysis?
• Which SAS statement completes the program to produce the desired PROC MEANS report?
• What does the '@@' line-hold specifier accomplish in SAS?
• Which command provides information about an entire library in SAS?
• Which kind of DO loop executes a set of statements based on the current value of an index variable?
• Which statement correctly defines the purpose of the DATALINES statement?
• What kind of reports do group variables produce?
• Which DO loop will NOT execute for the values 2, 4, 6, 8?
• What is the purpose of using the _NULL_ keyword in SAS?
• What does the general code structure of PROC SORT include?
• In SAS, what command is used to control the number of lines per output page?
• What is the impact of using the NODUPKEY option in data processing?
• What is the role of the FILL option when creating a chart in PROC GCHART?
• What value does the MONTH function return when given a date in SAS?
• To create only one observation per person in the provided DATA step, what statement should be added?
• Which category does a SAS function NOT belong to?
• Which procedure in SAS allows for the printing of subtotals in a report?
• What is the function of the FLOOR function in SAS?
• What does the PUT function do in a SAS program?
• What does the OPTIONS FIRSTOBS = 1 OBS = MAX; statement accomplish during data entry?
• Which of the following functions extracts the year from a SAS date?
• In the context of plotting, what function does the PLOT statement provide?
• How many observations will be in data set work.one after running the given SAS program?
• Which approach correctly initializes the length of a character variable in a DATA step?
• Which variables are created when a sorted data set is read using the SET and BY statements?
• Can @ and @@ be used together in the same DATA step?
• Which component allows navigation through libraries and data sets in SAS?
• What will be the value of quarter in the statement if today is March 5?
• What is the correct form of the sum statement in a DATA step?
• What should you use if you are evaluating a calculated variable in a dataset?
• Where must line-hold specifiers appear in the INPUT statement?
• Which of the following holds a line of raw data across multiple iterations of the DATA step?
• What is the effect of the YEARCUTTOFF= option in data input?
• Which command summarizes numeric variables within a specified data set?
• How can one control page breaks for subgroups within a report in SAS?
• Which of the following is NOT true about variable attributes in SAS?
• What does a DO-WHILE loop do in SAS?
• Which components does the Program Data Vector (PDV) hold?
• Which part of the GCHART procedure determines the analysis variable for calculations?
• What does the RBREAK statement accomplish in a report?
• What is the role of the INPUT function in SAS?
• Is it true that the raw data file must contain the same number of records for each observation to use line pointers properly?
• Which statement summarizes multiple observations into a new variable while maintaining its value across iterations?
• Which procedure displays a listing of the observations in the data portion of a SAS data set?
• What occurs when the SAS SUM statement ignores missing values?
• What does 'linesize= (ls=)' define in a SAS program?
• Which function allows you to replace text within a character string in SAS?
• What is the role of the BY statement in SAS programming?
• How would you assign a date constant in SAS?
• In the provided example data, how is the address inputted when the Type is 'H'?
• Which of the following best describes character variables in SAS?
• When using SAS/ACCESS to read Excel data, which statement is mandatory?
• Which statement best describes the INPUT statement in SAS?
• What is the value of the TotalCount variable after executing the SAS code regarding Amount?
• Which statement best describes the role of state and ZIP code functions in SAS?
• In the context of SAS procedures, what is the purpose of the REPLACE option in PROC EXPORT?
• When you use column input in SAS, which of the following are you able to do?
• What is the purpose of the Trailing @ Modifier in SAS?
• What does the DSD option in SAS do when reading data?
• In what scenario would you use column input in SAS?
• Which of the following bases can be used in the YRDIF function?
• Which of the following is an optional element in the PROC SORT syntax?
• What will be the contents of the data set created from the SAS program reading COLORS.TXT?
• Which statement is correct regarding the use of input values with the INPUT statement?
• What does the FIND function return if the substring is not found in the string?
• What is the purpose of the INTCK function?
• How many variables will be in the resulting SAS data set C after merging data sets A and B given the specified conditions?
• What is indicated by GROUP variables when creating SAS reports?
• What type of variable list would you use for a specific prefix in SAS?
• What will the IF statement evaluate if the condition is true and multiple actions are required?
• What is the result of using the DELETE statement in a DATA step?
• In a scatterplot, what can be specified to show confidence intervals for predictions?
• Which SAS function would you use to get the day of the month from a specific date?
• Which of the following can be used with the double trailing at sign @@?
• In the context of PROC PRINT, what happens if you do not use the VAR statement?
• What value is assigned to the variable ReferenceID in the following SAS code?
• What is the role of the BY statement in PROC MEANS?
• What SAS keyword is used to retain the values of variables across iterations of a DATA step?
• What does the INPUT statement in pointer control format allow you to do?
• Which window provides the default output format for SAS 9.3?
• If the TRUNCOVER option is applied and a data value is shorter than expected, what outcome can be expected?
• What can happen if invalid values are encountered in named input?
• In the SAS code provided, what effect does the CATX function have?
• Which function can be used to replace text in a string?
• What does the VAR statement do in PROC PRINT?
• What does the command "style=analysis" specify within an ODS statement?
• When would you typically use the FORMAT statement?
• What type of value does the INPUT function convert?
• What happens when the TRUNCOVER option is used in an INPUT statement?
• What is the significance of the DATA option in PROC GCHART?
• What happens if you use KEEP= or DROP= in a DATA step line?
• What is the function of the PROC PRINT code in SAS?
• Which window allows you to view the execution status of SAS procedures?
• Which statement correctly describes the OUTPUT OUT= option in SAS?
• What is the key difference between INFILE and FILE statements in SAS?
• Which statement is true about PROC UNIVARIATE?
• Which PROC FREQ option suppresses cumulative frequencies?
• What is the role of the OUTPUT statement in a DATA step within SAS?
• What is the appropriate way to specify an array for all variables in a data set that contains both numeric and character variables?
• What does the DAY function return when given a date in SAS?
• Which input method requires data values to be separated by spaces?
• Which function returns the smallest integer that is greater than or equal to its argument?
• What does the Excel workbook become when using SAS/ACCESS to read its data?
• Which of the following statements is used to specify the color of the axes in SAS?
• When the following SAS program runs, how many PDF files are created? ODS PDF FILE='results.pdf'; PROC PRINT DATA=work.ds1; RUN; PROC FREQ DATA=work.ds1; PROC FREQ DATA=work.ds2; RUN; ODS PDF CLOSE;
• Which of the following is a key function of the Results window?
• What is the output of the statement SUBSTR('Statistics',1,4)?
• Which data input method allows skipping some data fields if desired?
• How many times can the DATALINES statement be used in a single DATA step?
• What file format does ODS support that is specifically designed for Word?
• What will be the value of Char2 in the provided SAS program?
• What does the 'w=' option in the SYMBOL statement control?
• What caused the error in the submitted SAS log for the DO statement?
• What statement is often used to create a more complex data manipulation by moving from multiple observations to a single summary observation?
• What happens when multiple INPUT statements are used in a DATA step?
• What does the ODS statement enable you to do within SAS?
• What type of variables are designated as Display variables?
• What is the result of using a DROP statement incorrectly in a DATA step?
• Which variables are output to both data sets work.boston and work.dallas?
• Which of the following describes the meaning of CTEXT in relation to graph axes?
• Which option ensures the data step avoids moving to the next line if it encounters any missing variable values?
• What is an essential characteristic of the DATALINES method?
• What will the format statement control in a plot?
• What does the DLM option do in SAS?
• What does the CLASS statement in PROC MEANS allow you to do?
• Which of the following is NOT a feature of the PROC PRINT procedure?
• Which property of system options allows settings to remain until changed?
• Is _Yr2006_Patient_Data a valid data set name?
• Which of the following formats could lead to an invalid variable name in SAS?
• What does the STOPOVER option do when processing data?
• In SAS, how would you handle an ELSE condition with multiple statements?
• For each iteration of the DATA step, how many records are read?
• How is the DATA step compiled in SAS?
• Which of these windows displays previously executed results?
• How does the WEEKDAY function categorize days in SAS?
• Which SAS function is used to read character data with a set length?
• Which PROC CONTENTS option is used to suppress detailed output listing for each SAS data set in a library?
• What function returns the largest value among specified numbers?
• What is the purpose of the TRIM function in SAS?
• Which statement is true regarding the LENGTH statement in SAS when merging datasets with variable name definitions?
• When using the INPUT statement with DSD option, what is the primary effect?
• What information is typically contained in the descriptor portion of a SAS data set?
• What is the primary function of a CLASS statement in SAS programming?
• Which option should be used in the DATA step to create a data set called Last_Sale that contains the last observation in Sales?
• How do you select and delete rows in SAS?
• What variable types can be created in the BY group when sorting data for further analysis in the DATA step?
• When attributes are permanently assigned in a DATA step, what is retained?
• When executing the SAS statement ARRAY Response{*} a b c d e;, what type of array is created?
• What is the function of the 'increment' parameter in the INTNX function?
• What character denotes the end of SAS statements?
• What is the PROC GPLOT primarily used for?
• What does the option DSD do in the context of data export?
• What is the total number of observations that will exist in the resulting output data set after processing the input with the specified conditions?
• Which informat can properly read the raw data format 02/15/85?
• In which scenario is the INFORMAT statement used?
• What does the SAS datetime value represent?
• By default, what does PROC FREQ analyze in a SAS data set?
• What type of information can you derive from analyzing the spread of a dataset?
• What does the SORT procedure accomplish in SAS?
• What does the TODAY() function do in SAS?
• What is the purpose of the SCAN function?
• When is the condition checked in a DO UNTIL loop?
• What is the purpose of the symboln statement in SAS?
• What does a Numbered Range List allow you to do in SAS?
• Is _Yr2006_Patient_Data a valid default variable name in SAS?
• What would be the result of using the CLASS statement incorrectly in a SAS procedure?
• What is the result of the SAS program that filters data based on the conditions of first.x and last.x?
• Which function calculates the median from a set of numbers?
• Which of the following is NOT TRUE about SAS statements?
• In PROC GCHART, which option is used if you want bars to be filled with a specific color?
• How does the named input format work?
• Which statement about PROC MEANS is correct?
• What statement is used in SAS to keep the value of a calculated variable between observations?
• What kinds of variables are primarily used for Analysis in a SAS report?
• Which option sets the upper limit for observations read in a SAS data set?
• What does the ABS function return in SAS?
• What are the Special SAS Names?
• How does the iterative DO loop function in SAS?
• What does the NLEVEL option in PROC FREQ provide?
• What role does the 'report-column-header' play in a DEFINE statement?
• How can one display each distinct data value in PROC FREQ?
• What is the main purpose of the VALIDVARNAME = system option?
• What type of DO loop executes statements until a specified condition is met?
• Which function is used to convert numeric data to character data in SAS?
• What is the purpose of the PUT statement in SAS?
• What is the purpose of the 'firstobs=' option in SAS?
• What statement should be inserted to calculate the quarterly total from the monthly sales data?
• What effect does specifying a decimal in the INPUT statement have?
• Which function can calculate the difference in days between two dates?
• Which input style cannot be combined with @@?
• What does the YEAR function return in SAS when given a date?
• What is the outcome when you run the PROC GPLOT with the DATA option?
• What action does the 'submit' function perform in SAS?
• What is the value of the Date variable in the provided SAS program?
• How many observations are written to the work.report data set from work.sales?
• In SAS, what does the OUTPUT statement accomplish in the MEANS procedure?
• What will be the value of x after executing the DO UNTIL loop in the SAS program?
• What can be used in combination with the RETAIN and OUTPUT statements to write only a summary record?
• What functionality does an INFORMAT provide in SAS?
• Which DATA step will give the last observation from the data set called dogs?
• When reading data lines with multiple date formats, what is a correct YEARCUTTOFF value?
• Which SAS function would be appropriate for finding out which day of the week a date falls on?
• What is a requirement for character values in standard format?
• What does the FIND function in SAS do?
• Which pointer control is used for line pointer control in SAS?
• Which statement completes the SAS program to create the variable X with a value of Jameston?
• What does the PROC CONTENTS procedure produce as output for the DATA work.look?
• Which of the following is an example of a character function in SAS?
• Which PROC PRINT step correctly applies the specified format for the test variable?
• Which of the following describes the Output + Results Viewer?
• What must be true for a variable created in a DATA step regarding its attributes?
• In the ODS HTML statement, what does the option FILE='HTML-file-specification' specify?
• What does SAS display in the log when it encounters a syntax error?
• What is the key difference between the PUT and INPUT functions?
• What does the COMPBL function do?
• What is the purpose of the PROC CONTENTS statement in SAS?
• What is the purpose of the LOWCASE function?
• PROC MEANS is used mainly to perform which of the following tasks?
• The EXPLODE option in GCHART is used for which of the following actions?
• Which option is used to display the regression equation on a graph?
• What is one of the advantages of the Output + Results Viewer in SAS?
• What does the ROUND function do in SAS?
• What does the VAR statement in PROC FREQ do?
• Why does the PROC PRINT call with the following WHERE clause produce no observations? PROC PRINT DATA=work.salaries; WHERE salary GT 20000; RUN;
• Which statement is used to print grand totals in a SAS report?
• What does PROC CONTENTS provide when executed in SAS?
• Running the following code is an example of what type of data set combining?
• Which option scales the horizontal axis in a plot?
• How does the OUTPUT statement affect records in SAS?
• Which statement is correct regarding the vertical variable in PROC GPLOT?
• Which of the following describes a Name Range List?
• What does the SCAN function in SAS do?
• Which SAS program creates a variable named City with a value of Chicago correctly?
• What does the BY statement do in a SAS DATA step?
• After merging data sets A and B, how many observations will be in the resulting SAS data set C?
• Which date function could be used to identify the number of days until the end of this quarter?
• What does the PROC step allow you to do with a data set?
• What does the PUT statement do in a SAS DATA step?
• In PROC MEANS, what does the MAXDEC option specify?
• Which of the following statements about PROC FREQ is true?
• What type of regression line does the option 'i=rl' represent in a plot?
• What does the PROC FREQ statement allow you to do in SAS?
• How is a 'black space' created under the column headers in a SAS report?
• What does the statement 'pageno=' accomplish in SAS programming?
• In the context of PROC FREQ, what does the CHISQ option determine?
• Which option within the DEFINE statement controls the width of a report column?
• To create temporary array elements, which keyword is used?
• Which option in the EXPORT statement is used to specify a file location for the output?
• What type of data can PROC FREQ display?
• What would be the value of the variable 'address' after executing: address=f_name('214 London Court','Court','Drive');?
• What does a SAS function for random number generation provide?
• What are the values for x and y in the output data set when the following SAS program is executed? DATA work.look; x=2; IF x=1 THEN y=100; IF x=2 THEN y=200; IF x=3 THEN y=300; ELSE y=27; RUN;
• In the context of SAS reports, what does the term 'subtotals' refer to?
• After merging Employee and Sales, what is the format for the variable Name in the data set Both if LENGTH for Name was defined in earlier data sets?
• What does the LENGTH function in SAS return?
• Which code segment creates an HTML document with the results of the PRINT procedure?
• What is the value of the index variable that references the variable Jul in the array?
• Which function would you use to determine the quarter of a date in SAS?
• How many tables are generated when the following SAS program is submitted: PROC FREQ DATA=work.schools; RUN;?
• What does the #n option control in SAS?
• What does the input line beginning with "P" denote in the example data provided?
• What is a primary use of the ODS HTML CLOSE statement?
• In the context of SAS, what does the term 'DSD' stand for?
• What format does the DATALINES statement use by default to separate data?
• What is the result of merging two datasets with overlapping and unique IDs?
• What is the main purpose of the ID statement in SAS?
• What is the primary purpose of a DATA step in SAS programming?
• Given the SAS program for the dataset Work.Numbers, what are the output values in Work.Test?
• How does the PUT function operate in SAS?
• What is the condition for numeric values in standard format?
• Informats used in modified list input will NOT do which of the following?
• How do you submit a program in SAS?
• Which function would you use to ensure a character string has no trailing spaces?
• What does the HEADLINE statement accomplish in a SAS report?
• How does the INDEX function operate in SAS?
• Which option correctly specifies the end of variables being read from an INFILE in SAS?
• What must the dataset be before using the BY statement with the SORT procedure?
• What does the GOPTIONS statement in SAS define?
• What will happen if an invalid date format is used in a DATA step?
• What is the primary function of the Editor window in SAS?
• In the context of the SYMBOL statement, what does the 'i=' option specify?
• How does the '@n' line control option function in SAS?
• Which output destination is default for ODS in SAS?
• Why is it important to understand the OUTPUT statement in managing SAS data sets?
• Which statement correctly identifies the general form of the PROC GCHART statement?
• When would you typically encounter undefined references to variables in a data set?
• Which statement is true regarding the OUTPUT statement in SAS?
• What is true about the array Response declared in the SAS program?
• Which option below is TRUE regarding the PROC FREQ procedure?
• Which of the following is a valid option in PROC PRINT for limiting output?
• Which type of variable list allows a range of numbered variables in SAS?
• What type of intervals can be specified with the INTNX function?
• How is data converted from character to numeric type in SAS?
• What is the purpose of a DO-END block in SAS?
• What does the GETNAMES=YES option in a PROC IMPORT statement indicate?
• What is displayed in the Log window?
• What is the purpose of the INPUT statement in a DATA step?
• Which data set option controls the number of observations read from an input data set?
• Can the / and #n line pointer controls be used together in SAS?
• How does the MISSOVER option affect the DATA step in SAS?
• What does the IN= data set option allow you to do?
• Which function would you use to remove specific characters from a string?
• In which kind of expression would you use the FORMAT statement in SAS?
• Which statement will create an array that references all character variables in a dataset?
• If variables already exist in the input dataset, how can you reference them?
• What file extension is used for SAS program files?
• What is the main difference between using the SET and MERGE statements in a DATA step?
• What type of data source is used in a SAS DATA step?
• What will the execution result be if the PUT and FILE statements are swapped in a DATA _NULL_ step?
• What statement is used to display a total at the end of a group?
• What type of variables can you refer to using a Name Prefix List?
• In the context of the SORT procedure, what does "ASCENDING" refer to?
• Which function can be used to remove unwanted characters from a string?
• What is the primary use of PROC EXPORT in SAS?
• What does the INTNX function output when it calculates a date?
• What does the OUT option enable you to do in PROC SORT?
• Which function in SAS is used to retrieve a substring from a character string?
• What does the SUMVAR option in GCHART specify?
• What does the DSD option do in the INFILE statement?