Question 12:- When a SAS data set is created from a spreadsheet, the spreadsheet column headings are always stored as which of the following? a) variable names b) labels c) formats d) descriptor
BASE SAS PROGRAMMING
Question 12:- When a SAS data set is created from a spreadsheet, the spreadsheet column headings are always stored as which of the following?
a) variable names
b) labels
c) formats
d) descriptor
Question 13:- In SAS, one can test single or joint hypothesis after successful completion of
a) Data portion
b) First observation
c) Descriptor portion
d) PDV
Question 14:- The following SAS program is submitted: data work.products; Product_Number = 5461; Item = `1001`; Item_Reference = Item`/`Product_Number; run; Which one of the following is the value of the variable ITEM_REFERENCE in the output data set?
a) 1111/1502
b) 1001/ 5461
c) (missing numeric value)
d) The value can not be determined as the program fails to execute due to errors.
Question 15:- The following SAS program is submitted: data work.test; Title = `A Tale of Two Cities, Charles J. Dickens`; Word = scan(title,3,`,`); run; Which one of the following is the value of the variable WORD in the output data set?
a) T
b) (missing character value)
c) Dickens
d) of
Question 16:- The SAS data set EMPLOYEE_INFO is listed below: IDNumber Expenses 2542 100.00 3612 133.15 2198 234.34 2198 111.12 The following SAS program is submitted: proc sort data = employee_info; run; Which one of the following BY statements completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?
a) by Expenses IDNumber;
b) by IDNumber Expenses;
c) by ascending (IDNumber Expenses);
d) by ascending IDNumber ascending Expenses;
Question 17:- The following SAS program is submitted: data _null_; set old; put sales1 sales2; run; Where is the output written?
a) the SAS log
b) the raw data file that was opened last
c) the SAS output window or an output file
d) the data set mentioned in the DATA statement
Question 18:- The following SAS DATA step is submitted: data sasdata.atlanta sasdata.boston work.portland work.phoenix; set company.prdsales; if region = `NE` then output boston; if region = `SE` then output atlanta; if region = `SW` then output phoenix; if region = `NW` then output portland; run; Which one of the following is true regarding the output data sets?
a) No library references are required.
b) The data sets listed on all the IF statements require a library reference.
c) The data sets listed in the last two IF statements require a library reference.
d) The data sets listed in the first two IF statements require a library reference.
Question 19:- Which one of the following is true of the SUM statement in a SAS DATA step program?
a) It is only valid in conjunction with a SUM function.
b) It is not valid with the SET, MERGE and UPDATE statements.
c) It adds the value of an expression to an accumulator variable and ignores missing values.
d) It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.
Question 20:- In the following SAS program, the input data files are sorted by the NAMES variable: libname temp `SAS-data-library`; data temp.sales; merge temp.sales work.receipt; by names; run; Which one of the following results occurs when this program is submitted?
a) The program executes successfully and a temporary SAS data set is created.
b) The program executes successfully and a permanent SAS data set is created.
c) The program fails execution because the same SAS data set is referenced for both read and write operations.
d) The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
