Which statement describes a characteristic of the SAS automatic variable _ERROR_?
Which statement describes a characteristic of the SAS automatic variable _ERROR_?A . The _ERROR_ variable maintains a count of the number of data errors in a DATA step. B. The _ERROR_ variable is added to the program data vector and becomes part of the data set being created. C. The...
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 . 0 B. 100 C. 200 D. (missing...
What is output?
The SAS data set WORK.ONE contains a numeric variable named Num ana character variable named Char: WORK.ONE Num Char ------ ------ 1 23 3 23 1 77 The following SAS program is submitted: proc print data=WORK.ONE; where Num='1'; run; What is output?A . Num Char--- ---- 1 23 B. Num...
What is the value of the variable FOUND in the output data set?
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?A . 1 B. 12 C. Italy D. RussiaView 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...
How many observations will the data set WORK.EMPSALARY contain?
The following SAS program is submitted: data work.empsalary; set work.people (in = inemp) work.money (in = insal); if insal and inemp; run; The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations. How many observations will the data set WORK.EMPSALARY contain?A . 0 B....
Which of the following is true concerning the submitted program?
The following program is submitted: proc sort data=SASUSER.PROJECTS out=PSORT; by Code descending Date Cost; run; Which of the following is true concerning the submitted program?A . The descending option applies to the variable Code. B. The variable Code is sorted by ascending order. C. The PSORT data set is stored...
Which statement is true?
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 named WORKSALARY contains 10 observations for each department, and is currently ordered by DEPARTMENT. Which statement is true?A ....
What are the values of the AMOUNT and WORD variables in SAS dataset work.new?
The following SAS program is submitted: data work. new; length word $7; amount = 4; it 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...
What new variables are created?
The following SAS program is submitted: data work.test; set work.staff (keep = jansales febsales marsales); array diff_sales{3} difsales1 - difsales3; array monthly{3} jansales febsales marsales; run; What new variables are created?A . JANSALES, FEBSALES and MARSALES B. MONTHLY1, MONTHLY2 and MONTHLY3 C. DIFSALES1, DIFSALES2 and DIFSALES3 D. DIFF_SALES1, DIFF_SALES2 and...