- All Exams Instant Download
What value does the variable IDNUM contain when the name of the employee is “Ruth”?
Given the raw data file EMPLOYEE: ----I----1 0---I----20---I----30 Ruth 39 11 Jose 32 22 Sue 30 33 John 40 44 The following SAS program is submitted: data test; infile ‘employee’; input employee_name $ 1-4; if employee_name = ‘Ruth’ then input idnum 10-11; else input age 7-8; run; What value does...
Which INFORMAT reads this raw data and stores it as a SAS date value?
Given the following raw data record: 07Jan2005 Which INFORMAT reads this raw data and stores it as a SAS date value?A . dmy9.B . date9.C . ddMMMyy9.D . ddmmmyyyy9.View AnswerAnswer: B
What describes the SAS automatic _ERROR_ variable?
What describes the SAS automatic _ERROR_ variable?A . The _ERROR_ variable contains the values ‘TRUE’ or ‘FALSE.’B . The _ERROR variable maintains a count of the number of data errors.C . The _ERROR_ variable can be used in expressions or calculations in the DATA step.D . The ERROR_variable contains the...
Which statement best describes the output from the submitted program?
The following program is submitted: proc contents data=_all_; run; Which statement best describes the output from the submitted program?A . The output contains only a list of the SAS data sets that are contained in the WORK library.B . The output displays only the contents of the SAS data sets...
Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?
The following SAS program is submitted: data ONE TWO SASUSER.TWO set SASUSER.ONE; run; Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?A . 2 temporary and 1 permanent SAS data sets are createdB . 3 temporary and 2 permanent SAS data sets are createdC ....
A user-defined format has been created using the FORMAT procedure. Where is it stored?
A user-defined format has been created using the FORMAT procedure. Where is it stored?A . in a SAS catalogB . in an external binary fileC . in a SAS dataset in the WORK libraryD . in a SAS dataset in a permanent SAS data libraryView AnswerAnswer: A
Which statement is true concerning the SAS automatic variable _ERROR_?
Which statement is true concerning the SAS automatic variable _ERROR_?A . It cannot be used in an if/then condition.B . It cannot be used in an assignment statement.C . It can be put into a keep statement or keep= option.D . It is automatically dropped.View AnswerAnswer: D
Which TABLES statement was used to completed the following program that produced the output?
The following output is created by the FREQUENCY procedure: Which TABLES statement was used to completed the following program that produced the output? proc freq data=sales; <_insert_code_> run;A . tables region product;B . tables region,productC . tables region/product;D . tables region*product;View AnswerAnswer: D
What is the value of the TOTALPASSENGERS variable in the output data set?
The following SAS program is submitted: data work.passengers; if OrigPassengers = . then' OrigPassengers = 100; TransPassengers = 100; OrigPassengers = .; TotalPassengers = sum (OrigPassengers, TransPassengers) +0; run; What is the value of the TOTALPASSENGERS variable in the output data set?A . 0B . 100C . 200D . (missing...
What must be submitted prior to this SAS program for the program to execute successfully?
The following SAS program is submitted: data temp.x; set sasuser.y; run; What must be submitted prior to this SAS program for the program to execute successfully?A . A LIBNAME statement for the libref TEMP only must be submitted.B . A LIBNAME statement for the libref SASUSER only must be submitted.C...
