SAS Programming Questions with Correct Solutions Rated A+

[Ch.1] PROC SQL - - SAS procedure to query data sets - Can use in place of data step with less code - data set = table - observation = row - variable = column - a language that describes WHAT you want to do but not how to do it - picks the most efficient processing order [Ch.1] In your PROC SQL code, can you include SAS features that do not conform to the ANSI standard? - YES [Ch.1] The Structure of a PROC SQL Step - PROC SQL options; other statements quit; No run statement needed because of run-group processing [Ch.1] What could you add to the end of this program to stop PROC SQL from running? Select all that apply. - QUIT statement DATA step another PROC step [Ch.1] Using a SELECT Statement - - retrieves data from one or more tables - creates a report by default - made up of clauses - can contain a combination of 6 clauses SELECT item, item,* FROM* WHERE GROUP BY HAVING ORDER BY - each clause does NOT end in semicolon - just one at end - order of column names in select clause determine order they appear in the report - clauses must appear in this order - each SELECT statement generates a report - items in SELECT statement separated by commas [Ch.1] What order must the clauses in the SELECT statement appear? - 1. SELECT clause 2. FROM clause 3. WHERE clause 4. GROUP BY clause 5. HAVING clause 6. ORDER BY clause [Ch.1] Checking PROC SQL Syntax Without Executing the Program - Use VALIDATE statement or NOEXEC option Use VALIDATE statement only before the SELECT statement Must use VALIDATE before each SELECT statement if there are multiple No report created - log will indicate if query has correct syntax NOEXEC in PROC SQL prevents the code from executing and check syntax of all statements Use RESET EXEC statement to reset NOEXEC options [Ch.1] For which of the following PROC SQL statements can you use the VALIDATE statement to check the syntax? Select all that apply. A) select Customer_ID from 1_2007 intersect select Customer_ID from 2_2007; B) describe 1_2007; C) select Employee_Name, City, Birth_Date from yee_payroll as p, yee_addresses as a where p.Employee_ID=a.Employee_ID; D) alter table yee_payroll modify Phone_Type label='Work, Home, Cell'; - A & C You can use the VALIDATE statement with any SELECT statement, but not with other statements. [Ch.1] For which of the following programs will PROC SQL check the syntax without executing the code? a. proc sql; select * from yee_phones; quit; b. proc sql noexec; select * from yee_phones; quit;