Get Full Version of the Examhttp://www.EnsurePass.com/A00-201.html Question No.201The following SAS program is submitted:Which statement is true about the output data set?The type of the variable CharEmpid is numeric.The type of the variable CharEmpid is unknown.The type of the variable CharEmpid is character.The program fails to execute due to errors.Correct Answer: D Question No.202Given the SAS data set WORK.PRODUCTS:How many variables does the WORK.REVENUE data set contain?A.2B.3C.4D.6Correct Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/A00-201.html Question No.191The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below: WORK.EMPLOYEE WORK.SALARYfname age fname salary Bruce 30 Bruce 25000Dan 40 Bruce 35000Dan 25000The following SAS program is submitted: data work.empdata;merge work.employee work.salary;by fname; totsal salary; run;How many variables are output to the WORK.EMPDATA data set?A.3B.4C.5D. No variables are output to the data set as the program fails to Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/A00-201.html Question No.181The following SAS program is submitted: data work.month;date = put(#39;13mar2000#39;d,ddmmyy10.); run;Which one of the following represents the type and length of the variable DATE in the output data set?numeric, 8 bytesnumeric, 10 bytescharacter, 8 bytescharacter, 10 bytesCorrect Answer: D Question No.182The following SAS program is submitted:Which statement is true about the output data set?The label of the variable Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/A00-201.html Question No.171The following SAS DATA step is submitted: data sasdata.atlantasasdata.boston work.portland work.phoenix;set company.prdsales;if region = #39;NE#39; then output boston; if region = #39;SE#39; then output atlanta;if region = #39;SW#39; then output phoenix; if region = #39;NW#39; then output portland; run;Which one of the following is true regarding the output data sets?No library references are required.The data sets Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/A00-201.html Question No.161Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?libname sasdata #39;SAS-data-library#39;; data sasdata.mydata;copy mydata;run;libname sasdata #39;SAS-data-library#39;; data sasdata.mydata;keep mydata; run;libname sasdata #39;SAS-data-library#39;; data sasdata.mydata;save mydata; run;libname sasdata #39;SAS-data-library#39;; data sasdata.mydata;set mydata; Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/A00-201.html Question No.151The following program is submitted:Why does the program fail?The PAGENO option is invalid in the OPTIONS statement.The RUN statement is missing after the FORMAT procedure.The format name contains a period in the VALUE statement.The LABEL option is missing from the PROC PRINT statement.Correct Answer: C Question No.152Given the SAS data set WORK.ONE:What value will SAS assign to Total?A.3B.1.6C.4.8D.The program fails Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/A00-201.html Question No.141Which of the following programs correctly invokes the DATA Step Debugger?Option AOption BOption COption DCorrect Answer: C Question No.142The contents of the SAS data set PERM.JAN_SALES are listed below: VARIABLE NAME TYPEidnum character variablesales_date numeric date valueA comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. The SALES_DATE values need to be in a MMDDYY10 form.Which Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/A00-201.html Question No.131The following SAS program is submitted and reads 100 records from a raw data file: data work.total;infile #39;file-specification#39; end = eof; input name $ salary;totsal salary; run;Which one of the following IF statements writes the last observation to the output data set?if end = 0;if eof = 0;if end = 1;if eof = 1;Correct Answer: D Question No.132You#39;re attempting to read a raw data file and you see the following Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/A00-201.html Question No.121Which one of the following is true when SAS encounters a data error in a DATA step?The DATA step stops executing at the point of the error, and no SAS data set is created.A note is written to the SAS log explaining the error, and the DATA step continues to execute.A note appears in the SAS log that the incorrect data record was saved to a separate SAS file for further examination.The DATA step stops executing at Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/A00-201.html Question No.91Given the SAS data set PRICES: PRICESProdid priceproducttypesalesreturns K1255.10NETWORK152B132S 2.34HARDWARE30010 R18KY2 1.29SOFTWARE255 3KL8BY 6.37HARDWARE12515 DY65DW 5.60HARDWARE455 DGTY23 4.55HARDWARE672The following SAS program is submitted: data hware inter cheap;set prices(keep = productype price);if producttype = `HARDWARE#39; then output hware; else if producttype = `NETWORK#39; then output inter; if price Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/A00-201.html Question No.81Given the SAS data set EMPLOYEE INFO: EMPLOYEE_INFOIDNumber Expenses2542100.003612133.152198234.342198111.12The following SAS program is submitted: proc sort data = employee_info;lt;insert BY statement heregt; run;Which BY statement completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?by Expenses IDNumber;by IDNumber Expenses;by ascending Expenses IDNumber;by Read more [...]