Q:
Based on the following program and data, how many rows will be included in the dups table? proc sort data=payment dupout=dups nodupkey; by Amount; run; ID Amount A $916.32 A $854.17 B $879.05 B $932.77 B $879.05 C $747.96
Q:
Based on the following program and data, how many rows will be included in the dups table? proc sort data=payment dupout=dups nodupkey; by ID; run; ID Amount A $997.54 A $833.88 B $879.05 C $894.77 C $894.77 C $998.26
Q:
Based on the following program and data, how many rows will be included in the payments_clean table? proc sort data=emp_payments out=payments_clean dupout=payments_dups nodupkey; by _all_; run; ID Amount A $916.32 A $854.17 B $879.05 B $932.77 C $879.05 C $747.96
Q:
Which of the following FORMAT statements was used to create this output? Obs Order_ID Order_Date Delivery _Date 1 1230058123 11JAN07 01/11/07 2 1230080101 15JAN07 01/19/07 3 1230106883 20JAN07 01/22/07 4 1230147441 28JAN07 01/28/07 5 1230315085 27FEB07 02/27/07
Q:
Which FORMAT statement was used to create this output? Obs Emp_ID Hire_Month Birth_Date 1 59313 JAN2018 12/03/1987 2 62624 JAN2018 05/21/1991 3 73647 APR2018 11/06/1973 4 87231 MAY2018 06/28/1969 5 89828 AUG2018 02/13/1982
Q:
Which of the following FORMAT statements was used to create this output? Obs Order_ID Order_Date Delivery_Date 1 1660079313 09NOV2011 11/13/2011 2 1660079320 12NOV2011 11/16/2011 3 1660079323 13NOV2011 11/16/2011 4 1660079328 17NOV2011 11/21/2011 5 1660079331 26NOV2011 11/28/2011
Q:
Which statements about formats are true? Select all that apply.
Q:
The format name must include a period delimiter in the FORMAT statement.
Q:
Which FORMAT statement applies the DATE format to PopDate and the COMMA format to Population?
Q:
Which data values would be returned based on the following WHERE expression. Select all that apply. where City like “Sant_ %”;
Q:
Which row or rows will be selected by the following WHERE statement? where Job_Title like "Sales%"; Obs Last_Name First_Name Country Job_Title 1 Wu Christine AU Sales Rep 1 2 Stone Kimiko AU Sales Manager 3 Hoffman Fred AU Insurance Sales
Q:
Which row or rows will be selected by the following WHERE statement? where Position_Title like "%Engineer"; Obs Last_Name First_Name Dept Position_Title 1 Gritz Julie Design Engineer l 2 Wills Brandon Design Lead Engineer 3 Jackson Dan Design Program Manager 4 Whittman Ashley Design Engineer lll
Q:
Which statement about this PROC SORT step is true? proc sort data=caps.staff out=work.staff; By Salary descending Location;run;
Q:
Which statement about this PROC SORT step is true? proc sort data=orion.staff; out=work.staff; by descending Salary Manager_ID; run;
Q:
Which of the following WHERE statements correctly selects rows based on multiple values? Select all that apply.
Q:
Which statement about PROC SORT steps is true?
Q:
These two statements are equivalent. where Type='Sedan' or 'SUV' or 'Sports';where Type in('Sedan' 'SUV' 'Sports');
Q:
Which of the following statements selects from a table only those rows where the value of the column Style is RANCH, SPLIT, or TWOSTORY?
Q:
Comparison operators can be expressed with either symbols or letters.
Q:
Which of the following statements selects rows in which Amount is less than or equal to $5,000 or Rate equals 0.095?
Q:
Which of the following statements selects rows where MPG is greater than 27 or MPH is greater than or equal to 0 and less than or equal to 55. Select all that apply.
Q:
Which of the following is a true statement about creating a macro variable with the %LET statement?
Q:
What is the outcome of this statement? %let dog=Labrador;
Q:
Which statement creates the macro variable flower and assigns the value Plumeria?
Q:
The VAR statement is required in the PROC MEANS step.
Q:
Which statement in a PROC MEANS step lets you specify the numeric columns to analyze?
Q:
Which statement about this PROC MEANS step is true? proc means data=school_summary; var StudentCount CountyPopulation;run;
Q:
Suppose you have a table that includes flower sales to all your retail outlets. You want to see the distinct values of Flower_Type with a count and percentage for each. Which procedure would you use?
Q:
The PROC UNIVARIATE procedure performs which of the following?
Q:
The PROC FREQ procedure performs which of the following?
Subscribe
0 Comments
Oldest
Find Questions in This Page: "CTRL+F"