Which data values would be returned based on the following WHERE expression. Select all that apply.

where City like "Sant_ %";

Practice More Questions From: Exploring and Validating Data

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 statement about PROC SORT steps is true?

Q:

Which of the following WHERE statements correctly selects rows based on multiple values? Select all that apply.

Q:

These two statements are equivalent. where Type='Sedan' or 'SUV' or 'Sports';where Type in('Sedan' 'SUV' 'Sports');

Q:

Comparison operators can be expressed with either symbols or letters.

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:

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
Notify of
guest
0 Comments
Inline Feedbacks
View all comments